Query for organizational chart

• vickilross

  SSC Rookie

  Points: 26

  More actions

  May 6, 2003 at 7:42 am

  #101463

  I need a query that returns who works for who.

  My table contains

  userID, name, reportsTo

  ie.

  1 Mary 0

  2 John 1

  3 Harry 1

  4 Tom 2

  5 Ann 2

  6 Sue 5

  So, if my userID is John, then I want the query to return Tom, Ann, Sue. If my userID is

  Mary then the query should return John Tom Ann Sue Harry. I guess I also need another indicator for levels because in the last example I don't know that Tom and Harry are at the same level. Please help me sort this out.

  Thanks

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  May 8, 2003 at 8:09 am

  #456534

  I had replied to a similar query earlier

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

  If you need more help let me know