|
Friends, I need to store in a CSV file the result of a procedure. I am using the following command: I need the result to be separated by column. How can I do this?
(comments are locked)
|
|
If you mean separated by comma, then use the ' The default without specifying is tab - same as saying ' MSDN BOL reference here I do not want to be separated by comma. I need every column of the stored procedure is in a different column in the CSV.
Mar 03 '10 at 11:56 AM
Felipe
You will have to use a comma or tab seperated. A CSV stands for "comma seperated values"????
Mar 03 '10 at 12:00 PM
sp_lock
I'm sorry I don't understand your question - could you show some data as an example?
Mar 03 '10 at 12:18 PM
Kev Riley ♦♦
possibly a column inbetween each result column ... ???
Mar 03 '10 at 12:51 PM
Fatherjack ♦♦
Simple. For example, my procedure returns 2 columns: Column A and Column B. In the CSV file, the first column should contain the result of Column A and the second column should contain the result of Column B. Do you understand?
Mar 03 '10 at 01:20 PM
Felipe
(comments are locked)
|
