Quibble quibble quibble...but I might as well live up to my screen name.
> Ok, so his source table has a column called "Name". But it is clearly the "Path" of the nodes.
Actually, it's not. To quote him (in part):
Raw data:
7 3 Root1_Child1_SubChild2
Desired output from SELECT:
7 3 0/Root1/Root1_Child1/Root1_Child1_SubChild2
And then full quote:
"i used strings for the Formatted path just so you can see a better visual, i will end up using the ID. for example instead of the formatted output of '0/Root2/Root2_Child1' i will need '0/2/5'"
So his name field is really just trash, insignificant in the example or code.
But never mind, the rest of your answer is sufficient.
|
