Query formatting to a text file

[billum]

Hi,
Iam taking the output of a query to a text file.I used bcp ...queryout filename for that.This is working fine
In the text file I need to get the query result with some heading and footers like :

command1
row1
row2
---
---
command2
command3
command4

Actually this text file later need to be used as a command file for another application
How can this be done ? Any ideas?
Thanks
Bill

 

[rebeccah2004]

hello- i am having this same issue, have you found a fix? i have been working on this formatting issue forever.

thanks in advance,
rebecca