How do you export a SQL Query to a file?

[Brian1219]

I am trying to create a procedure to export the results of its query into a text file. I am relatively new to SQL so any help would be appreciated.

Thanks,

 

[tlbroadbent]

Check this link.

http://www.swynk.com/faq/sql/sqlfaq_development.asp#FlatFile

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.