General information
Forum:
Microsoft SQL Server
Title:
Query help: with root, find all child nodes
Hello,
I have a relationship between parent and child nodes as such.
The - indicates related to
A - B, C
B - D,E
D - F
C - J,H
E - G
What I am trying to accomplish is to write a query that will be supplied a root value.. ie A and I want to find the downlines..
Therefore, all the alphabets you see in the list above should appear..
I hope this is enough info.
I am in process of writing this query.. any help is appreciated.
Alvin
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only