Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trees & Hierarchies question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-09 : 07:16:46
Mazen writes "Hi,
Based on the "More Trees & Hierarchies in SQL" article found at (http://www.sqlteam.com/item.asp?ItemID=8866), how can I find all the parents-nested nodes of a specific node (all the bosses of an employee).

Thanks,

Mazen"

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-06-09 : 08:22:25
In that specific example you can use the lineage as a csv list.

you can then build you query using methods discussed here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36048

Corey
Go to Top of Page
   

- Advertisement -