hi Guys , i am a bit stuck here
i have this value "0.833333333333333"
and i want the asnwer to be 83 , i tried this
but it does not workCode:SELECT ROUND(0.833333333333333,2)
Printable View
hi Guys , i am a bit stuck here
i have this value "0.833333333333333"
and i want the asnwer to be 83 , i tried this
but it does not workCode:SELECT ROUND(0.833333333333333,2)
try:
Code:SELECT ROUND(0.833333333333333 * 100,0)
This will bring back "83".
select convert(decimal(12,0),ROUND(0.833333333333333 * 100,0))
"but it does not work" -- I beg to differ... it does work... it's doing exactly what you told it to do... round to two decimal places (.83). just so happens that the result isn't what you want... (83)
There's two solutions... 1) multiply it by 100 then round to 0 decimal places...as the previous posters did.... or, round to 2 decimal places THEN multiply by 100.
-tg