SQL data extract

[Mich]

I've got data in a SQL 2000 db that I need extracted. It's simple enough to create a query or DTS package, but this is a little different and I'm stuck.

What I need to do is create text file similar to the following:

UNIQUE HEADER
DATA LINE 1
DATA LINE 2
.
.
.
DATA LINE X
UNIQUE FOOTER

The header, data lines, and footer can be created by 3 fairly simple queries/packages. However, I'm having a VERY hard time merging the three into a one text file. I hope I've provided enough information. Let me know if not.

Any ideas?

-If it ain't broke, break it and make it better.

 

[SQLBill]

SQL really isn't designed to do that (create reports). You should use a third party application to create reports (Crystal Reports, Access, VB, etc).

-SQLBill

 

[Mich]

I was beginning to move in the direction of Crystal and VB. Just hoped there was something in SQL I had missed.

-If it ain't broke, break it and make it better.