Дзюндзя (![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small} syarzhuk) wrote,@ 2006-04-13 11:01:00 |
|
| Entry tags: | code, sql |
SQL Server stinks!
SELECT Round(59999.0 * 0.155,2)
9299.8500 - correct
SELECT Round(Cast(59999.0 as money) * Cast(0.155 as float),2)
9299.8400000000001 - wrong!
Fix:
SELECT Round(Cast(Cast(59999.0 as money) * Cast(0.155 as float) as money) ,2)
