Roberto Kohler wrote:

>Arithmetic with integer and money data types produces invalid results.
>Is this a known SQL bug?
>Are there any guidelines for doing arithmetic with the money data type?
>
>The following operation
>select round(@amount *((@units*@unitPrice)/@invoiceTotal),2)
>returns an incorrect value
>if @amount, @unitPrice and @invoiceTotal are of type money
>and @units is of type int
>
>round(3742.20 * (2 * 43.48) / (188338.77 - 24565.93), 2)
>returns 1.73 which is correct
>round(@amount * ((@units*@unitPrice)/@invoiceTotal), 2)
>returns 1.50 which is wrong
>
>You can try it:
>
>declare @amount money
>declare @units int
>declare @unitPrice money
>declare @invoiceTotal money
>
>select @amount = 3742.20
>select @units = 2
>select @unitPrice = 43.48
>select @invoiceTotal = 188338.77
>
>
>select round(3742.20 * ((2 * 43.48) / 188338.77), 2) "correct answer",
> round(@amount * ((@units*@unitPrice)/@invoiceTotal),2) "wrong
>answer"
>
>
>correct answer wrong answer
>-------------------------- ---------------------
>1.7300000000000 1.5000
>
>
>