Get Child Record under Parent record with SQL Query without loops using

• kiran_ramisetti

  SSC Rookie

  Points: 26

  More actions

  June 15, 2009 at 6:46 am

  #135204

  Table: tbUser

  ID Name Descr ParentName

  1 XYZ this is Parent record NULL

  2 ABC this is parent record NULL

  3 PQR this is child record 1

  4 STU this is Child Record 1

  5 MNO this is child 1

  6 IJK this is child 2

  Expected Result Like this:

  ID Parent Name

  1 Select XYZ

  1 PQR

  1 STU

  1 MNO

  2 Select ABC

  2 IJK

• kjell.rasmundson

  Grasshopper

  Points: 13

  More actions

  June 16, 2009 at 5:29 am

  #1010100

  select id, [Name], Descr, isnull(parentId, id) as ParentId2 from #tbUser

  order by ParentId2, id 😛