Hi All
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.