CEILING returns FLOOR result - SQL SERVER 2008 R2

sql database sql-server-2008 floor ceil

Try:

SELECT CEILING (@a/CAST(@b AS float))

And consider NULLIF(@b,0) too, to avoid a Division By Zero error.

sql database sql-server-2008 floor ceil

After dividing 9 by 2 a decimal fraction is Truncated to its integer part - 4, not Rounded to 5. Try:

SELECT 9/2

Resilt is 4. Then CEILING(4) = 4

To get next integer declare variables as data types that can handle decimal part: NUMERIC,FLOAT, REAL.

sql database sql-server-2008 floor ceil

SQL Server does integer division. So 9/2 = 4 in SQL Server.

Taking the ceiling of an integer is the same integer.

CodeHunter