Bridge the row gap in isql output file from 2 store procedures results

[fredong]

Anyone knows how can I close the gap between the first results and the second resutls in 2 store procedures that I ran together in a osql batch file. basically I appendded the second store preocedure results to the first store procedures output file.If you see below my results you notice that between line 16(which is the first results) and line 17 (which is the second result) there is a row gap that I wanted to close up.Please advise. Thanks.


//STX12//850ABCDEF 000000000000000000000401080922 0401080922
0100NE000000000000000003704520021121
02
03
04
05ST ZZ
0655109998
07EFGHIJ
08
09
10
11
12
13
14
15
16

17236.00000000EA
18EXXL7997A

 

[md67]

I see you posted this a while ago and no one has responded. I'm having the same problem and wanted to know if you found a solution yet?

 

[fredong]

instead of using 2 store procedures I consolidated into 1 SP and then used UNION clause in my SQL query to bridge the gap. I hope that will help you.