Something I have been able to accomplish some time ago but I haven't got it documented :(, in the following stored proc I manage to show my information in a hiearchial maner, and displays when running my information like:
CREATE PROCEDURE sproc_bookmark AS
SELECT bookmark_title = convert(varchar, SPACE(2 * (bookmark_level - 1) ) + bookmark_title)
ORDER BY bookmark_thread_id
Since I'm parsing this SPROC through asp.net I would like to have the instead of a space within my SPROC so it's already pre-formatted and ready to go in my ASP.NET page (in html format) when I receive the information from my database.....