Output Query Analyzer

[brutus6294]

This is a very stupid question, but I have about 10 Queries in query analyzer I would like to capture the output to. Ideally I'd like to capture the query and the output in one readable file, but will settle for capturing the results (including the column headers). Is there a good way of doing this? File formats I've tried have been a little rough...

 

[kaht]

Ctrl + A
Ctrl + C
Ctrl + V

???

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson

 

[brutus6294]

That will not give column names, will it? Thanks

 

[kaht]

It will if you are returning values as text

In QA:

Tools > Options > Results Tab > Default Results Target ---> "Results to Text"

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson

 

[philhege]

There are other approaches which are better suited to what you want to do, especially if this is a recurring requirement.

Look up "Copying Data From a Query to a Data File" in BOL.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.