how to round the decimals to the upper value
15,653
You need to use the CEILING
function. Not ROUND
or FLOOR
as in your question.
Author by
Abbas
Updated on June 05, 2022Comments
-
Abbas almost 2 years
i am using sql server 2008 procedure, i have total rows divide by per page, i want that if the results contains any decimal value it should be rounded to its upper value.
i used below:
SELECT FLOOR(@TOTAL / CAST(@PageSize AS FLOAT)) AS TOTALPAGES, @TOTAL AS TOTALROWS
where @total is the float, this does not work. i also tried below
SELECT ROUND(@TOTAL / CAST(@PageSize AS FLOAT),0) AS TOTALPAGES, @TOTAL AS TOTALROWS
This works only when the decimal is >= 5, else it does not take the upper value.
i want that if the results is 12.2 then it should return 13