<div>
You could do this:<br />
<br />
@echo off<br />
<br />
setlocal<br />
<br />
set oldFile=output.txt<br />
set newFile=newFile.txt<br />
<br />
del &quot;%newFile%&quot; 2&gt;NUL<br />
<br />
for /f &quot;tokens=* skip=2&quot; %%a in ('type &quot;%oldFile%&quot;') do (echo %%a)&gt;&gt;&quot;%newFile%&quot;<br />
<br />
echo Output in &quot;%newFile%&quot;<br />
<br />
Good Luck,<br />
Steve
</div>


You could do this:

@echo off

setlocal

set oldFile=output.txt
set newFile=newFile.txt

del "%newFile%" 2>NUL

for /f "tokens=* skip=2" %%a in ('type "%oldFile%"') do (echo %%a)>>"%newFile%"

echo Output in "%newFile%"

Good Luck,
Steve

<div>
I tried the -h options, but it still gave me headers in the outputfile.<br />
I'll try the answer Steve gave.<br />
<br />
To be continued.
</div>


I tried the -h options, but it still gave me headers in the outputfile.
I'll try the answer Steve gave.

To be continued.

<div>
The -h work for me as did my manual batch file processing. Maked sure not specify the parameter exactly:<br />
<br />
-h-1<br />
<br />
No spaces in between characters for this parameter.
</div>


The -h work for me as did my manual batch file processing. Maked sure not specify the parameter exactly:

-h-1

No spaces in between characters for this parameter.

<div>
Thanks Steve for the solution.<br />
It must be -h-1 instead of -h.<br />
<br />

</div>


Thanks Steve for the solution.
It must be -h-1 instead of -h.



<div>
Yes, that will do the trick.
</div>


<div>
<div class="content wysiwyg-content">
I'm using MSSQL 2000 osql to run scripts against databases for monitoring purpose.<br />
The output of the script is saved into an output file.<br />
<br />
I would llike to get rid of the column headers in the output file.<br />
So instead of<br />
<br />
Column A &nbsp;Column B<br />
----------- &nbsp; -----------<br />
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
<br />
I would like to get<br />
a &nbsp; &nbsp; &nbsp; 1<br />
<br />
What parameter of option can i use either with osql or within the t-sql script?
</div>
</div>


I'm using MSSQL 2000 osql to run scripts against databases for monitoring purpose.
The output of the script is saved into an output file.

I would llike to get rid of the column headers in the output file.
So instead of

Column A  Column B
-----------   -----------
a                1

I would like to get
a       1

What parameter of option can i use either with osql or within the t-sql script?

Wanted: no column headers in output file

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.