writing reults to file

[sexydog]

HI

How can i write the results of my query to a comma deliminated list.....is this possible

Thanks
DJ

 

[mwolf00]

If you use query analyzer (sql srvr 2000), you can select "Results to File" and get a Tab separated report. You could also use a language like ASP to execute a query and write the results to a CSV.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[nigelrivett]

see

http://www.nigelrivett.net/WriteTextFile.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.