The header row would look like this:

1XXXXX2XXXXX3XXXX4 -- no column headers and all fixed width.

I wish I had a DBA like that!  My DBA locked down the system so hard, that when I tried to run...

Pivot tables would be a good idea, if the client was willing to make their own pivot tables!   They just want it how...

Okay, I have another question...I've found a ton of information on bcp, but from what I've read, you can either use the bcp from the windows command...

Actually, I hadn't searched for that because I didn't know what it was called.  Cool.  Thanks for the info!

I've searched the help and it wasn't there.

I don't know the client, but since I write SQL queries all day long to be used in reports, I think I might have an answer......