It seems so appropriate after my recent bout with Time Warner’s customer service about the difference between megabits and megabytes that XKCD should publish this comic:
I Want One!
Quote of the Day
SQL Server Query Analyzer Results to Excel (TSV)
I tried to run a query today and have the results go to a file. The output was a ton of rows with only one column. If you need to output query analyzer results to a format compatible with Excel just do the following:
- Go to “Tools”
- Click “Options”
- Click the “Results” tab
- Under “Results output format: (*)”, select “Tab Delimited”
- Make sure “Print column headers (*)” is selected
- Click “OK”
Now when you run your query the results will be in TSV format with the column headers.
Enjoy!
