I believe I finally figured out on my own the best approach on getting my desired results. I first thought that a While Loop syntax would be the appropriate direction...

I believe I finally figured out on my own the best approach on getting my desired results. I first thought that a While Loop syntax would be the appropriate...

Okay.. I have attached a visualization. You will see two data sets; first one is what you will see when you run the virtual logic table and what you...

Great!! I didn't know if you got to see my verbiage in my first message (towards the bottom), but in the event you haven't I'll add it here:

So I need...

My apologies! my first time using the site with visual example: here is a virtual table you can use:

CREATE TABLE #temptable (ReportingMonth Varchar(6), Fee_Code Varchar(20), Fee_Transaction_Amount Decimal(12,2), Fee_Transaction_Date...

Thank everyone for all the relative insight!

I believe I found a solution with regards to amortizing mulitple loans at once; In the section where you are creating cluster indexes:

CREATE CLUSTERED...

Yeah I realized from all the postings that this subject has not been in the fore front, but as an avid T-SQL user I am tasked to create an amortization...

Hello Greg!

I love you your logic regarding the Mortgage Amortization table. I was wondering if there was a way to tweak the logic to allow for multiple loans? ...