rounding up to the next whole number

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » rounding up to the next whole number

rounding up to the next whole number

Rate Topic

Display Mode

Topic Options

Author

Message

slkorf

Posted Monday, April 14, 2008 7:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 10, 2009 8:47 AM
Points: 2, Visits: 6

I'm trying to round a number up to the next whole number in sql server 2005 query analyzer.

i.e. 12.2 needs to display as 13

I've tried the round function but the value displayed is 12. I researched online and found the 'int' function but sql server 2005 doesn't recognize this. I'm new to sql...done most of my calcs via excel. Anyone know how to do this?

Post #484732

Jeff Moden

Posted Monday, April 14, 2008 8:08 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:26 PM
Points: 32,899, Visits: 26,781

SELECT CEILING(CAST (12.2 AS FLOAT))

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #484737