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, Mar 18, 2009 6:26 AM
> 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 ..
FROM Syndicated S
ORDER BY S.Category
Thoughts on getting this to work in tsql?
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!