| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|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.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved