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 - 2004-12-08 : 08:06:31
|
| Thomas writes "Hi,My Item table has 3 column as follows ID INT Description NVARCHAR(150) ParentItem INTIn my Item table, I have few records as follows50,Item A,5555,Item AA,056,Item B,5757,Item BB,058,Item C,5659,Item D,5060,Item AAA,55In this Item table, ParentItem column stores the Parent Item ID which is a record from Item table itself.One Item can have only one parent, but the same parent Item can be a parent of another Item. (sample records: Item ID 55 is the Parent Item of Item 50 and Item 60.)Child Item can be a Parent of another Item but Circular Reference is not allowed. (sample records: Item ID 50 is the Parent Item of Item 59, but Item 50 can't be a Parent Item of Item 55 because Item 55 is the Parent Item of Item 50) This Parent - Child - Children realtionship can go up any level.I am not sure how to call the relationship between these records, i just call it Parent - Child - Children.My quesion is now I want a list of all the possible related item list. based on my sample records,lets say if i want all the related items for Item 50, that will be 50,Item A55,Item AA59,Item D60,Item AAA[Item 50 is the item which i requested, Item 55 is the parent of Item 50, Item 59 is the child of Item 50, Item 60 is the child of Item 55(Item 55 is parent of Item 50)]how i will write the sql query for this? please give me hand on this query." |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
|
|
Parent - Child-Children relaltionship 
)