470,638 Members | 1,510 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

Column Names with a cursor

I have set up a query where I am using a cursor to pass result from one
query to use as select parameters in another query. The problem I am
having is that when I pass the results into the second query I get the
column headers?

How do you suppress the column headers from showing in the query? I
see how you select options - print headers.



Jul 23 '05 #1
2 1836

If you dont want to have headers, then you can use ' '

Select col1 as ' ', col2 as ' ' ........ from table


Jul 23 '05 #2
Why use a cursor at all? You should be able to make the first query into a
correlated subquery.

David Portas
SQL Server MVP
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Robert Ferber | last post: by
1 post views Thread by beef | last post: by
1 post views Thread by Korara | last post: by
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.