I think patterns only exist within each loan, so I have to accommodate for all...

I think i got it...

I first created this function to return the last day of any...

I was afraid of this... I have over 170,000 loans, that when ballooned out with all the payment dates is over 4million rows...

I have the the MaturityDate to work with...

Coming from you, that really puts a big smile on my face (well my ego just went sky high)... thanks,

I think back in the early 20's maybe Einstien, said "My...

I read somewhere (i think it was AskTom) but depending on how you wanted your data or the business logic (the way you write your query if using a subquery...

ah, is that why you used a temp table rather than the table variable, or does it matter...

Looks good, thanks, I will test it out now... and let you know...

John

See if my trigger will help you... it's using the Tally Table, SYSCOLUMNS, and the COLUMNS_UPDATED...

The WHERE CLAUSE are the Columns I want to capture data for, and my CASE...

Hey,

thought you might be interested in my stats...

My first attempt at this Amortization was doing a loop to create 3 Mill + Records took 45 Mins

Then I did an insert...

Hi,

I was so excited when I figured it out, I left in a rush to celebrate...

It does work, the fix was in my last post... weird; I would like to...

I knew you would post...lol

I'll check it out...

But i did figure it out, see my other post

Running Total isn't working in the UPDATE CLAUSE... doesn't that look familiar...

I've been using sp_executesql and found that if I try to pass in the table name it never works... I think it's comparable to early binding or somthing...

I put...

I'll ask the boss, 2 questions on that... in the query you'll see where I query the tblauthorizations, I think that just lets the user use the MS Access;

What...

I was thinking that, just wanted to verify...

Just wondering how taking a column out of a view deals with a DDL...

I did notice before I do the update link,...