If life should ever punish you by challenging you to round up decimals by a quarter of an hour – always up and never down – here’s a liferaft
In a scenario where you wish for 2.04 to be rounded up to 2.25 instead of down to 2.00:
Declare @myNum decimal(18,2) = 2.04
( Ceiling((@myNum + 0.24) * 100)
Ceiling((@myNum + 0.24) * 100)
% 25 )
This solution is based on the solution posted in 2001 on VBForums – props to original poster MartinLiss!