Stored Procedure to Output CSV from Select Query

Question

Post reply

Stored Procedure to Output CSV from Select Query

Viewing 2 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

water490 Ten Centuries Points: 1210 More actions · Answer 1

i found a way better way to do the same thing.

https://analytics4all.org/2018/03/10/ssis-lesson-1-export-to-csv/

it works and its safe. none of the headaches with the original approach I was trying earlier

jcelko212 32090 SSCrazy Eights Points: 9304 More actions · Answer 2

You're missing the fundamental concept of a tiered architecture. Display formatting is done in a separate layer from the database. Yes, I know in the old days with COBOL and Fortran, we did this sort of formatting for inputs and outputs in the program itself. That ended sometime in the early 1970s.

Please post DDL and follow ANSI/ISO standards when asking for help.