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.