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 |
|
adlo
Posting Yak Master
108 Posts |
 Posted - 2004-12-02 : 12:10:09
|
| Group (Group_ID,Name,Parent_ID)Member_Group (Group_ID,Member_ID)I need a sp that gets a list of al the Member_ID's for a spesific group(@Group_ID) and all its child groups. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-02 : 12:41:39
|
| Some sample data would help, and what you're expected results should be...BUTYou're missing a column that shouws the relationships between id'sBrett8-) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-02 : 12:42:07
|
| http://www.nigelrivett.net/RetrieveTreeHierarchy.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
adlo
Posting Yak Master
108 Posts |
Posted - 2004-12-03 : 06:05:56
|
| Group TableGroup_ID Name Parent_ID1 Action Groups 04 Music Teams 06 Leaders 07 Office 010 Youth 011 Kids 1012 Teens 1014 Tuesdays 115 Wednesday 117 Thursdays 118 Fridays 119 Morning 1420 Afternoon 1454 Youth Choir 455 Ladies Choir 456 Childrens choir 459 Office Staff 7Member_GroupMember_ID Group_ID100 54101 15102 15103 18104 19105 19106 20Results must be101102103104105106I am preferably looking for a non cursor and non temp table sp. |
|
|
|
|
|
|
Simple Hierarchical Query