How to get rid of messages when outputing from QA

[jmj]

I need to output a bunch of queries from Queyr Analyzer.
I'd like them to be exported without any space between each query.
I've turned off the header. But after each query there are a couple of lines with a msg like "(10 row(s) affected)".
Is there a way I can do this cleanly? I saw one solution, that worked from the Grids Result screen, but that will only let me pick one query result at a time. I'd like all of them to export on the same page.
Thanks,
J

 

[vongrunt]

SET NOCOUNT ON.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[jbenson001]

use SET NOTCOUNT ON

 

[SQLDenis]

Andif you have aggregate's with nulls ("Warning: Null value is eliminated by an aggregate or other SET operation.
")
use SET ANSI_WARNINGS OFF


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jmj]

That takes out the count, but I still get a whole blank line between queries. Any way to get rid of that?

 

[vongrunt]

Ah... output as text?

AFAIK that blank line cannot be turned off.

If there are no headers and blank lines, how will you know where one output ends and another one begins?

If all queries return identical columns, try UNION ALL.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)