Solved

# SQL Server Stored Procedure

Posted on 2009-03-28

Could you guys help me with this code?

I hope it's not too hard.

I need an SQL Server stored procedure that does the follwing calculation:

Teble A:

" Account_Number

" Current_Balance

" Final_Maturity_Date

" Interest_Rate (%)

Table B:

" Account_Number

" Payment_Amount

" Payment_Frequency

" Payment_date

Table A and B join based on an Account_Number

Calculation to be done (This example is for monthly payments only)

" Take Current_Balance from Table A and calculate the interest amount for 1 period

" Calc1 = a.Current_Balance x (( a.Interest_Rate/ 12) / 100)

" Add this to the balance

o New_Balance = a.Current_balance + Calc1

" Subtract the payment amount from the updated balance

o Ending_Monthly_Balance = New_Balance b.Payment_amount

" Add 1 month to the b.Payment_date

" Go to next month and repeat above calculation

" Stop when balance becomes zero or negative

" Compare the payment date calculated to the a.Final_Maturity_Date to determine number of months difference and return that number.

Input arguments:

Account_Number

Current_Balance

Final_Maturity_Date

Interest_Rate

Payment_Amount

Payment_Frequency

Payment_date

Thanks,