Sunday, March 11, 2012

double lines with osql

Does anyone know how to eliminate the double lines that osql puts in your
output?
The help file says: "When running stored procedures, osql prints a blank
line between each set of results in a batch."
This may or may not be my problem. A very simple example:
osql -S[server_name] -U[logon_id] -P[pwd] -d[database] -w100 -otest.txt -Q"s
p_helptext tu_patient_insert" /h-1
The results gives an extra hard return after every line.
Any ideas would be appreciated!
TorryI don't see any way to circumvent it. If this is a single user process, you
could run 2 osql, one to dump the result from the sp into a global temp
table, the other to select from the global temp.
-oj
"Torry Slaton" <tslaton@.tcshealthcare.com> wrote in message
news:MdKdncmHg_DoWJ7fRVn-oQ@.megapath.net...
> Does anyone know how to eliminate the double lines that osql puts in your
> output?
> The help file says: "When running stored procedures, osql prints a blank
> line between each set of results in a batch."
> This may or may not be my problem. A very simple example:
> osql -S[server_name] -U[logon_id] -P[pwd] -d[database] -w100 -otest.txt -Q"s
> p_helptext tu_patient_insert" /h-1
> The results gives an extra hard return after every line.
> Any ideas would be appreciated!
> Torry
>

No comments:

Post a Comment