>>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 an addition to what Antonio said, you could directly make your C# function a CLR function for SQL server. Then you could call it as if it was a built-in SQL server function (caveat: the function would only available in the database(s) that register the dll. Good side: You can write some complex functions in C#\Vb.Net).
Thanks Cetin