Wednesday, March 27, 2013

Query analyzer related

Output to text file that can be opened by Excel correctly (esp. for numeric columns):
Tools \ Options \ Results \ Custom Delimiter: ";" (semi-colon)
When opening/importing to Excel, check "Advanced..." settings (usually on Step 3) to make sure that correct Decimal and Thousands separators are used


No comments:

Post a Comment