SQLTeam.com | Weblogs | Forums

Convert scientific notation to text and saving in .csv file


Hi all,

How do I handle long number so when I convert my sql result set, I wont have the scientific notation in csv?

Thanks all


what are you using to produce the CSV? SSIS, C#, PoSH, Excel? The answer will depend on that.


Hello gbritton, I am using sql query. Thank you.


OK -- please post your query