anthony.green (8/16/2012)
You can use the wizard to run a query to export to a flat file.You can also run the query to file, but to save it as CSV, you would have to put in a ',' in between each column other wise it will export it as one cell, not multiple cells.
I am using temp table as #temp1 in my query
but export wizard don't allow that
so how to handle that?