Query to return nested info

Question

Query to return nested info

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jpipes SSChampion Points: 12230 More actions · Answer 1

OK, not to sound pessimistic, but this kind of thing is generally better left to the filesystem. That is specifically what it is designed for. But, that said, I guess the answer depends to your table schema. You've posted the fields, but not the keys, so I'm not sure how to interpret your FolderAccess table. Could you identify the PK on the table?

Edited by - jpipes on 09/03/2003 08:40:58 AM

NPeeters SSChampion Points: 12625 More actions · Answer 2

There is another thread around just dealing with this kind of problem.

Look for http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15815&FORUM_ID=23&CAT_ID=2&Topic_Title=Recursive+Stored+Procedure+in+SQL+SERVER&Forum_Title=General

To go short. You will need the maximum depth of the tree and build some dynamic query.

Or you can use a cursor to run through the tree.