Viewing post 1 (of 2 total)
Luis Cazares (10/8/2014)No need for a while loop, you just need to use REPLICATE() function.SELECT REPLICATE('_', [LEVEL]) + NAMEFROM @Tree
Luis Cazares (10/8/2014)
SELECT REPLICATE('_', [LEVEL]) + NAME
FROM @Tree
That's awesome. Saved me a lot of work...
Thank you so much.
October 8, 2014 at 12:38 pm
#1751082