Very Computer

My Problem is this....

I am using T-SQL in SQL 7.0 to create an output file from a Query (A stored
procedure actualy).

But My query results contain a heading i.e.

query result heading
----------------------
my data here !!

There is a connection setting available through the GUI.
Current Connections, Advanced, and there is a Print headers check box which
allows you to turn the headings off.

But can I change this at run time (during the execution of my Stored
Procedure) ??

Since I don't want any headings to appear in my output file.

Any help would be great.

Thanks In Advance,

Lee.
:>

Perhaps exec the sql using isql command line executed from
master..xp_cmdshell - use the switch -H-1 to get rid of headers.

You could also use print but it would be inefficient as you would need to
use a cursor to print each row.

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk (UK User group, code library, FAQ etc..)

Quote:> My Problem is this....

> I am using T-SQL in SQL 7.0 to create an output file from a Query (A
stored
> procedure actualy).

> But My query results contain a heading i.e.

> query result heading
> ----------------------
> my data here !!

> There is a connection setting available through the GUI.
> Current Connections, Advanced, and there is a Print headers check box
which
> allows you to turn the headings off.

> But can I change this at run time (during the execution of my Stored
> Procedure) ??

> Since I don't want any headings to appear in my output file.

> Any help would be great.

> Thanks In Advance,

> Lee.
> :>

Thanks Tony,

I'm running my procedure within the SQL Server Job Scheduler
I added the osql command line execution
(with -h-1 switches as you suggested).

It worked a treat.

Cheers

Lee

:>

* Sent from Devdex.com http://www.devdex.com The Web Developers Index *
The world's largest index site for Microsoft web technologies.