>Hi,
>I need to be able to round some totals to the nearest 0.05.
>
>I have done this in C# using this code:
>
>

        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;
>        }

>
>Is there a way to do this in SQL Server? Shall I just try to use the same logic in a UDF?
>
>I will need to use it in queries like:
>
>SELECT RoundToNearest(SUM(SomeAmount), 0.05) AS RoundedTotal

As a function:

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)
go

Inline in a Select statement:

SELECT ROUND(17.08 / 0.05) * 0.05