ggilal
asked on
round up a decimal number
I have this line in my SP:
Cast(ceiling((TotalRows/@P ageSize)) as int) as TotPages
I am using CTE and ROW_NUMBER()OVER
when the TotalRows = 282 and @PageSize = 60 I am receiving TotPages = 4 while I really need 5 as the result.
How can this be done?
Thanks
Cast(ceiling((TotalRows/@P
I am using CTE and ROW_NUMBER()OVER
when the TotalRows = 282 and @PageSize = 60 I am receiving TotPages = 4 while I really need 5 as the result.
How can this be done?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
please try
Cast(ceiling( cast(TotalRows as decimal(10,2))/@PageSize) as int) as TotPages
In MSSQL, when you divide an integer with an integer, the result will be an integer. So in your case, 282/60 will be 4 instead of 4.7. So ceiling(4) will return 4. Just cast the variable with float or decimal or any like. it should work.
Try
Cast(ceiling((cast(TotalRo
/peter