RE: rounding up to the next whole number

SSC Guru

Points: 1003867

January 2, 2018 at 2:39 pm

#1974134

Thanks for the feedback. Also consider the ROUND function. Use of the normally missed 3rd parameter can help solve certain problems.
https://docs.microsoft.com/en-us/sql/t-sql/functions/round-transact-sql

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)