How to retrieve query results with now field names, dotted line or footer

[Daniel.Peaper]

Hi folks,

I'm trying to write a simple SELECT statement that will execute in
query analyser but will just have the data with no column names, or the
dotted line between them and the data. I also want to avoid the
statement at the end which says nnn rows affected. any ideas? I want to
do this because I intend to write the results to a flat file.

Thanks for your help
Danny....

[Stu]

The easiest way that I know how to do this is to change the output
format in query analyzer. Look under Tools, Options, Results, Results
Output Format and see if one of the format options will meet your
needs. You can issue the SQL command SET NOCOUNT ON; to eliminate the
rows affected message.

Stu
Da***********@gmail.com wrote:

Hi folks,

I'm trying to write a simple SELECT statement that will execute in
query analyser but will just have the data with no column names, or the
dotted line between them and the data. I also want to avoid the
statement at the end which says nnn rows affected. any ideas? I want to
do this because I intend to write the results to a flat file.

Thanks for your help
Danny....

[Daniel.Peaper]

Thanks for that Stu,

it worked a treat. I also found that by submitting the query with the
following switches would supress the header info:- -h, -1

Danny...