Skip navigation
cfwild
cfwild
Currently Being Moderated

sql add blank row to result

Mar 17, 2009 6:05 PM

Hi,

I currently use a temporary table to add a blank row to the top/beginning of my query results. I'm moving to MS SQL stored procedures and wanted to know if it's possible to add a blank row right into my SQL so I can eliminate the temporary table solution.

Any thoughts on this are appreciated!

cfwild
7102 Views   4 Replies   Latest reply: cfwild, Mar 18, 2009 6:26 AM
 
Replies
  • -==cfSearching==-
    Currently Being Moderated
    1. -==cfSearching==-,
    Mar 17, 2009 7:23 PM   in reply to cfwild
    Report
    > wanted to know if it's possible to add a blank row right into my SQL so I can eliminate
    > the temporary table solution

    You could use a union to merge your blank row with your other results and order it so the blank sorts on top. But why do you need a blank row? It sounds like mixing user interface code with database code ..
     
    |
    Mark as:
  • cfwild
    Currently Being Moderated
    2. cfwild,
    Mar 17, 2009 7:57 PM   in reply to -==cfSearching==-
    Report
    Hi,

    Thanks for responding.

    I fashioned this up, but I'm throwing an error:

    SELECT S.Category
    FROM Syndicated S
    UNION '<HI>'
    ORDER BY S.Category

    Thoughts on getting this to work in tsql?

    cfwild

    My problem is that I'm binding this to the cfselect, the bind doesn't allow the queryposition above|below functionality to work. So I'm forced to a). temp table (which is working fine) or b). investigate adding into the sql. Thanks!
     
    |
    Mark as:
  • -==cfSearching==-
    Currently Being Moderated
    3. -==cfSearching==-,
    Mar 17, 2009 8:16 PM   in reply to cfwild
    Report
    You have to use SELECT with the string literal

    SELECT Category
    FROM Syndicated
    UNION
    SELECT '<HI>'
    ORDER BY Category
     
    |
    Mark as:
  • cfwild
    Currently Being Moderated
    4. cfwild,
    Mar 18, 2009 6:26 AM   in reply to -==cfSearching==-
    Report
    Hi,

    Thanks for the insight. It worked perfectly! For anyone looking for just a blank row insert "above" the query results, here was the final code:

    SELECT Category
    FROM Syndicated
    UNION
    SELECT ''
    ORDER BY Category

    Again, thanks for the help!
     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points