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 - 2006-08-11 : 08:43:51
|
| kalyani writes "Hi, I am working on Project where User creates lists. Each user can copy the list created by another user . In the list table ,I am storing ReferrerID /Parent List ID . The database structure is like hierarchial tree ..My problem:- User 1 creates list. User 2 copies list from User 1 . User 1 again copies the list from user 2 . User 3 copies list from user 1. User 4 copies list from user 1. I am displaying all the child nodes of User 1 with their depth level . USer 3, 4 are appearing at level 1 as well as level 3. I would like to display user 3 /4 only once . Is it possible to implement using CTE.Thanks" |
|
|
|
|
|
Recursive Query