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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 15:37:37
|
Ramesh Senthiappan writes "I have a node table that has node_id and parent_id. The parent_id links to the node_id of the parent and so on. The parent_id of the top most node is null. (SQL Server 7)
Question: Given a node is it possible to get the list of parents (recursive) in a single query. If so, how to accomplish the task?
Thanks
Ramesh" |
|
|
|
|
|
Self Join - How to trace the parents?