• Right now, I have created SP and used sqlcmd to dump to file. But, when I open in text file, it shows up lots of empty space as it takes some width on each column like below.

    "Text1" ,"Text2"

    "ttt" ,"T"

    I'm still not sure if this is the best way!!