Are you saying that total commissions % could be bigger than 100%?

>Total commission paid is 3000.00. The first line pays 5% of 3000.00 for 150.00. The second line pays 15% of the remainder of 3000.00-150.00 or 2850. If I calculate this as a set, I have to know the balance remaining for each line. Maybe this is not possible to do without a cursor.
>
>Thanks.
>
>>Hi James,
>>
>>I'm not sur why do you need running balance. Can you clarify?
>>
>>>
>>>I am using Sybase SQLAnywhere database. This database uses T-SQL but probable more compatible with the 2000 version.
>>>
>>>I am working a a commission matrix that I need to calculate. The matrix consist of a number of rows that pay different recipients for their portion of the total commission for a sale. I need a way to calculate a remainder of commission for each row until all the commission has been allocated. For example:
>>>
>>>

>>>Total commission 3000.00
>>>Recipient		Rate				Amount		Balance
>>>Starting Balance							3000
>>>George			5%				150.00	        2850
>>>Henry			15%				427.50	        2422.50
>>>Jack			70%				1695.75	        726.75
>>>Me 			Remainder	    	        726.75	        0
>>>

>>>
>>>I know how to do this in VFP but I hope to be able to do this using a stored procedure.
>>>
>>>Thanks.