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
>