| Welcome to WebmasterWorld Guest from 184.108.40.206 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Building a tree from individual file paths in T-SQL|
| 2:34 am on Oct 5, 2010 (gmt 0)|
Usually I'm the one answering database questions, but I'm completely stumped here. Looking for some T-SQL code to get the results I need.
I have a table that contains a couple of file paths, lets say the table is called FOLDERS and the field name is FOLDER. Some results would be:
Basically what I need to do is figure out how to select these in such a way that I can build a collapsible folder tree in an application. So my results would need to be something like:
Anyone have any ideas? I know I could do this using a temp table and a cursor, but I'm wondering if there is a more efficient way first.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved