Thanks for your reply. It's an example of what the bell curve calculations are. Obviously equal distribution would be a matter of dividing the margin equally over the course of the term (i.e. $250K / 9)... With the bell curve calculation its different in that the calculations for each month vary... 10% of margin one month followed by say 20% the following and so on....

I havent ever written anything like this before and havent seen any examples anywhere on the net. I was thinking maybe a stored procedure or CURSOR may be an option but was hoping someone on here has coded something like this before and could offer a suggestion.