recursive select

• kraks

  SSC Veteran

  Points: 295

  More actions

  August 5, 2003 at 2:59 pm

  #101607

  i have a table

  ------------------------

  id name parentid

  ------------------------

  1col1NULL

  2col21

  3col31

  4col42

  5col52

  6col63

  7col74

  what would be the easiest way to get a list of all child ids for an id.

  for eg. for id = 1, i would need the the child ids as 2,3,4,5

  and the levels deep can be dynamic.

  Thanks

• kraks

  SSC Veteran

  Points: 295

  More actions

  August 5, 2003 at 3:00 pm

  #468734

  small correction

  for eg. for id = 1, i would need the the child ids as 2,3,4,5,6

  and the levels deep can be dynamic.

• winash

  SSChampion

  Points: 11446

  More actions

  August 5, 2003 at 3:33 pm

  #468736

  check this link...it has a discussion (and a solution) on something on the same lines...

  http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11640&FORUM_ID=8&CAT_ID=1&Topic_Title=hierarchies&Forum_Title=T%2DSQL