Home Forums SQL Server 2012 SQL Server 2012 - T-SQL What's wrong in this .. simple calculations RE: What's wrong in this .. simple calculations
laurie-789651
SSCertifiable
Points: 7680
More actions
September 27, 2012 at 11:05 am
#1543018
Money & Smallmoney both have 4 decimal places, so that's why they lose the detail. If you're looking for accuracy it's better to use decimal.
It's all a bit of a minefield.:hehe: