SQL Server Performance

Display of Data category wise

Discussion in 'T-SQL Performance Tuning for Developers' started by gopalanmani, Dec 13, 2007.

  1. gopalanmani New Member


    I need to list all the categories in order like tree view model.
    my category table structure
    ---------------------------------------
    catid catname parant_catid
    1books0
    2Software0
    3MS Ref book1
    4C#3
    5MS products2
    6Asp.net3
    7Java product2
    8Msoffice5
    9Java Books1
    10JSDK7
    i want to like
    1.books(0)
    9.Java Books(1)
    3.MS Ref book(1)
    6.Asp.net(3)
    4.C#(3)
    2.Software(0)
    7.Java product(2)
    10.JSDK(7)
    5.MS products(2)
    8.Msoffice(5)
    Thanks & Regards,
    Gopalan Mani
  2. anandchatterjee New Member

  3. gopalanmani New Member

Share This Page