You are correct. I originally had fineamount numeric(8,2) and changed to numeric(8,2) before I posted on UT but I forgot to change my cursor in ISQL.
Thanks again and thanks Naomi as well.
>>Still the wrong answer.
>>Results
>>
>>3500 = 50.00 sb 40.00
>>2500 = 30.00 sb 22.50
>>1500 = 15.00 sb 10.00
>>500 = 5.00 sb 2.50
>>
>>Sergey's solution clarified by you :).
>>
>>Thanks.
>>
>I get this in SQL Server:
>
>1 3500 40.0000
>1 2500 22.5000
>2 1500 10.0000
>1 500 2.5000
>2 500 2.5000
>