file with formatting, no header and delimiters. I want to set this up as a job so I can't really set the options in Query Alalyzer. Is my only choice to do a BCP?
I seem to be getting a lot of mileage out of that post.
The down side to it is that I think you would need to use PRINT statements within a cursor instead of just a standard SELECT, but perhaps you know of a way to suppress reporting headers in a SELECT.