April 1, 2010 at 10:04 am
Greetings to the group,
I am writing an extract file from our HR system for a new implementation. The required output is text (csv).
What I need to do is have the output from three separate (different number of fields in each one) statements write consecutively to one file.
For example, the three areas below would represent the output from the three statements.
100,0,welcome etc
(1) row returned
200,john doe record…
200,jane doe record…
200,charles doe record…
(3) rows returned
700, approver record…
700, approver record…
(2) rows returned
What I need is the output to write to one file as...
100,0,welcome etc
200,john doe record…
200,jane doe record…
200,charles doe record…
700, approver record…
700, approver record…
Any ideas would be greatly appreciated! (This is on a SQL 2000 db)
Bob
April 17, 2010 at 8:05 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply