Please give me query to display hierarchy

• Balaji-129603

  Newbie

  Points: 9

  More actions

  April 12, 2004 at 8:42 pm

  #161361

  I have one table named "ut_Sections" with fields Section_ID, Name,IsParent(bit),PrentSection_ID Now i should display the hierarchy like: ParentSection_1        ChildSection_1               SubschildSection_1         ChildSection_2          ChildSection_3                  SubchildSection_2                  SubChildSection_3 ParentSection_2 ParentSection_3            ChildSection_4                    SubchildSection_4          ................etc i should display like this...how can i design the table and and query...please help me.

• Jeff Moden

  SSC Guru

  Points: 1004339

  More actions

  April 12, 2004 at 10:41 pm

  #502489

  Lookup "hierarchical information" in Books on Line for an example.  Has a bug in it but shouldn't be hard for you to find.

  --Jeff Moden

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)