getting column headers from a grid view

[rds80]

If I want to copy the results of a query with the column headers, is there a way to do that in a grid view?

 

[nice95gle]

You can set the results to text (query-> results to-> results to text). Run your statment then you can just copy and paste what ever you want.

 

[rds80]

Forgot to mention that the results of the query has to be pasted to Excel. Copying the text data to excel isn't the cleanest.

 

[AlexCuse]

I don' know that you can do this from Query Analyzer. The query results to excel menu option will place results in an excel file, but the whole row is in one cell. I imagine this is not what you're looking for.

You could use a simple dts package for this, but that might be overkill. Have you considered using MS Query?

Good Luck,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[nice95gle]

A little messy, but have fun.

http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx