Query to produce column names at top of results?

bugs2bugs

Hello,
We're using SQL Server 2000 and Query Manager (not Visual Studio). When your query results are returned, the column names are displayed at the top, but this information is NOT available for cut/paste to Excel. One of the workarounds we thought of was to return the column names within the query itself, and thought there was perhaps an option or other feature of SQL Server that would allow us to put the column headings into Excel without having the type in the column names. Ideas/suggestions are appreciated.
Thanks

Jim Doherty

Quote:

Originally Posted by bugs2bugs

Hello,
We're using SQL Server 2000 and Query Manager (not Visual Studio). When your query results are returned, the column names are displayed at the top, but this information is NOT available for cut/paste to Excel. One of the workarounds we thought of was to return the column names within the query itself, and thought there was perhaps an option or other feature of SQL Server that would allow us to put the column headings into Excel without having the type in the column names. Ideas/suggestions are appreciated.
Thanks

Heres one to add to your arsenal, adjust to suit you

Expand|Select|Wrap|Line Numbers

  CREATE PROCEDURE dbo.usp_MakeSpreadsheet AS 

exec sp_makewebtask @outputfile = 'c:\myspreadsheet.xls', 

    @query = 'Select * from dbo.MyTable',

    @colheaders =1, 

@FixedFont=0,@lastupdated=0,@resultstitle='Here are the results',

    @dbname ='NameOfYourDatabase'

GO

Regards

Jim :)

Query to produce column names at top of results?

re: Query to produce column names at top of results?

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about