Finding a path from NodePath

[neeko1226]

I have a vendor software that stores files in folders in the gui. In the actual db (SQL 2005), the files and folders are stored as Node_Name (varchar(128)), Node_ID (int) and Node_Path (varchar(900)).
Here's an example of the data:

Node_Name​

Node_ID​

Node_Path​

Mortgage 2004​

4​

.1.2.4.​

HMDAMonthly​

184​

.1.2.4.184.​

APR​

187​

.1.2.4.187.​

What I would like to do is create a query that would take that data and show a "GUI File Path" for the users. For example \\Mortgage 2004\HMDA Monthly\Test\Retail.

Any Ideas?

 

[bborissov]

Read for recursive query in BOL.

Borislav Borissov
VFP9 SP2, SQL Server

 

[TheBugSlayer]

Common Table Expressions would be a good topic to read up on.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)