a: thanks, I can’t tell you how many times I looked for this, and I never noticed that I can change the format of the output.

b: just a note if you have any numbers with leading zeros in the data (some zipcodes, etc): if you save the file with a csv extension excel will open it and drop the zeros, if you save it as .txt and then open it in excel you will get a text import wizard, the wizard will allow you to set that column as text so it comes in correctly.

Pinal Dave is a technology enthusiast and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and have written over 3800 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. For any SQL Server Performance Tuning Issue send email at pinal @ sqlauthority.com .

Nupur Dave is a social media enthusiast and and an independent consultant.