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 |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2008-09-30 : 06:13:29
|
| child Parent closing1 Null 02 1 03 1 14 3 1 5 4 16 3 27 4 28 1 29 7 210 1 311 1 312 10 313 9 314 9 315 8 3 Question is: Find out those child who doesnot Sponsor any body in closing 3 . child belongs to closing: 0 to 2 plz.. help me..Ved Prakash Jha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 06:31:58
|
| If you're using sql 2005 search for recursive CTEs in this forum. And if you're using SQL 2000 then refer below link for samplecodehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76414&SearchTerms=hierarchies |
 |
|
|
|
|
|
help plz...