Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: sproc SPACE ->  

    Hello everyone,

    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:

    ASP
    ASPtools
    ASPtools2
    ASPprograms
    etc.....


    CREATE PROCEDURE sproc_bookmark AS
    SELECT bookmark_title = convert(varchar, SPACE(2 * (bookmark_level - 1) ) + bookmark_title)
    FROM adw_bookmark
    ORDER BY bookmark_thread_id
    GO

    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.....

    But how do you do this?????

    THANKS!

    Evan

  2. #2
    Join Date
    Oct 2003
    Location
    Dallas
    Posts
    76

    ...

    + ' ' +


    just place that between your two fields, and yes those are single quotes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •