drunk_irishman
asked on
How do I round up to the nearest 100??
I'm using SQL to run some very in depth estimating formulas and need to be able to Round Up within the statement. For instance, if the value my formula shoots out is 7122, I want that to be 7200.
Round(7122,-2) gives me 7100
Ceiling(7122) gives me 7122 (too bad ceiling doesn't take 2 arguements).
Any ideas?
Round(7122,-2) gives me 7100
Ceiling(7122) gives me 7122 (too bad ceiling doesn't take 2 arguements).
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
clever, thank you sir.
use this
i had to use a dummy table just ignore it
CEILING returns the smallest integer which is equal to or greater than the number it is given
the result on my example is the following
note just use ceiling(NUMBER/100)*100 in the example i show you all the results
i had to use a dummy table just ignore it
CEILING returns the smallest integer which is equal to or greater than the number it is given
the result on my example is the following
note just use ceiling(NUMBER/100)*100 in the example i show you all the results
select top 1 7122
, 7122/100.0 as dividedby100
, ceiling(7122/100.0) as ceilingresult
, ceiling(7122/100.0)*100 as myfinalnumber
from gl20000
ceiling.JPG
set @x = 7100
SELECT case when @x%100 > 0 THEN ((@x/100)+1 )*100 ELSE (@x/100)*100 end