How can you supress the dash line in the output

Question

How can you supress the dash line in the output

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

david.kelly-684973 SSC Enthusiast Points: 148 More actions · Answer 1

:angry:I can feel the pain and I also suffer with it.

I believe what we are trying to discover is how do we turn off the dashed line in query results. In my Management Studio (2005) with results to text turned on

the first query

select count(1) from vw_cdm

returns

----------- :sick:

4373

(1 row(s) affected)

I can set off the (1 row(s) affected) by using

set nocount on

select count(1) from vw_cdm

which returns

----------- <---- still that irritating dashed line :unsure:

4373

Any way to turn it off?

J-440512 SSCertifiable Points: 6285 More actions · Answer 2

Hammer and Chisel?

Funny Jeff!

How about:

PCM (Puff Cloud Modulation)

Writing it on snow (don't eat the yellow snow)

Skywriting

No offense intended to anyone.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

david.kelly (2/3/2009)
:angry:I can feel the pain and I also suffer with it.
I believe what we are trying to discover is how do we turn off the dashed line in query results. In my Management Studio (2005) with results to text turned on
the first query
select count(1) from vw_cdm
returns
----------- :sick:
4373
(1 row(s) affected)
I can set off the (1 row(s) affected) by using
set nocount on
select count(1) from vw_cdm
which returns
----------- <---- still that irritating dashed line :unsure:
4373
Any way to turn it off?

Yes.

Tools - Options - Query Results - SQL Server - Results to Text

then uncheck 'Include column headers in the result set'

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

david.kelly-684973 SSC Enthusiast Points: 148 More actions · Answer 4

Thanks. Life is just too short to be irritated all the time. 😛

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

david.kelly (2/3/2009)
Thanks. Life is just too short to be irritated all the time. 😛

Commendable philosophy, David. Not only that, it's now beertime! 😀

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 6

[font="Verdana"]From my reading of the question, a job defined in SQL Agent is running a series of queries, and the results from the queries are being logged to a file. So changing the options of Management Studio probably won't help much, as the queries are being run under SQL Agent.

My suggestion: create a report in SQL Server Reporting Services (SSRS). Then you can format it however you wish, and include your multiple queries on the one page. You can set SSRS to run the report and e-mail it out on a schedule.

SQL Agent isn't the best tool for creating periodic reports. So, time to delve into SSRS!

[/font]