I need to always round up in SQL Server TSQL, such that I have the Given and need to return the Needed Result:
Given Needed Result
----------- --------------
25 25
25.1 26
25.001 26
12 12
0.1 1
0.001 1
0 0
CEILING(Given) should do the trick.
Ceiling just rounds the given number up to the next whole integer.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With