create a flat file from sql table

[bunmiA]

How do you create acomma delimited flat file from a sql table. I know how to do it using a print statement withing a cursor. but I would like to do it using a select staement only. (and not the cursor.) any ideas???

 

[mwolf00]

SELECT '"' + isNull(textField1,'') + '",' 
+ isNull(convert(varchar(10), intField),0) + ','
+ isNull(convert(varchar(10), dateField,1),'""')
FROM myTable

Note that you want isNull() statements or a whole row will be lost if any one value is null.
Also, all non-text data will need to be converted to text since you are outputing a text string.

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)

 

[bunmiA]

thanks