public static decimal RoundToNearest(decimal value, decimal nearest) > { > decimal remainder; > decimal returnValue; > > remainder = value % nearest; > if (remainder >= (nearest/2)) > { > returnValue = value + (nearest - remainder); > } > else > { > returnValue = value - remainder; > } > return returnValue; > }>
create function dbo.RoundToNearest (@value float, @nearest float) returns float as begin return round(@value / @nearest, 0) * @nearest; end; go select dbo.RoundToNearest(17.08, 0.05) goInline in a Select statement:
SELECT ROUND(17.08 / 0.05) * 0.05