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?