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 |
|
sgebbie
Starting Member
7 Posts |
 Posted - 2002-06-20 : 18:15:23
|
| I really need some help here.I have a table [family]:parent_name, my_nameand I want to pass 'adam' as a parameter and count the number of family members at each generation down 3 generationsthe data would be:god, adamadam, MichaelMichael, Luciferadam, johnJohn, MatthewMatthew, DavidDavid, PeterPeter, PaulPaul, Wendyso 'Adam' has 5 members (3 levels deep, john&michael&Lucifer&Matthew&David)Level1:2 members-John&MichaelLevel2:2 members-Matthew&LuciferLevel3:1 member-David, David's offspring are ignored.I cannot understand 'books online' so am pretty much completly stuck and the topics i have seen are similar but still different and confuse me more than anything.If anyone can help I would really appreciate itthanks in advanceStephen |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
|
|
|
|
|
complicated count