April 12, 2011 at 10:43 am
Not so much a question as much as a searchable note for myself later on (an hopefully becomes handy for someone else out there).
Ran into an issue with a report that was obtaining it's data via a PROC that was generating data via temp tables, that did not have matching metadata down in the actual tables.
CONVERTing precision on NUMERIC and DECIMAL data types is not seen the same in Microsoft Excel. Original precision was set to 38,6 and 25,6. Customer needed the precision scaled down to 2 digits to the right of the decimal, but needed to maintain appropriate rounding of values. Excel does not like the DECIMAL data type, and thus would not work properly with the CONVERTed precision, but NUMERIC was fine. Had to change all column datatypes in the temp table to NUMERIC, with the original precision (28,6 and 25,6) and then CONVERT in my last SELECT statement to the 2 digit precision (28,2 and 25,2) in order for this to port down to Excel properly for the customers Pivot table, and later import into their finance application.
April 12, 2011 at 3:30 pm
Check that...3 digit precision! (e.g. from 38,6/25,6 to 38,3/25,3).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply