2 Line breaks appearing in my result set (SQLServer)

[PDEvans]

Using osql I call a stored procedure that runs a query against my SQL Server database. The output has to be formatted to an exact format which I have partly successfully achieved.

The problem I am having is that every time the query is run SQL Server places 2 blank lines at the bottom of the result set causing problems when feeding into my other system.

I have set nocount on in order to remove any "Rows Affected" messages but alas I still hit the problem of having 2 empty rows.

Can anyone help???????

[MAK]

why can't you use DTS?

[PDEvans]

I'm going to avoid explaining too much detail as to what we are trying to do because it will just cloud the issue. The data our stored procedure calls is to be fed into a mainframe system. DTS is not an option for us.

We simply need to establish if there is a way of removing these two carriage returns at the bottom of our result set.