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.
--sb--