So Simple - Thanks!

I tried doing this using nested loops and it kept crashing my system after hours of processing. I just made the change to the CTE and it...

That was PERFECT! 😀 Thanks for pointing me to that link. I was able to generate the exact same trend values as Excel reported.

I stuck the values in Excel and used the FORECAST function.

The X value was period 14

Known X's were periods 8 thru 13

Know Y's were the pcts for periods 8...

Figured it out. I had to explicitly declare the value as a date: TO_DATE('3/28/2010', 'MM/DD/YYYY')

I hear what your saying, however as a company we are trying to minimize user interaction with the files. I would prefer to do that as a last step if...

It ended up being the OLE Provider.

Ok, were getting close. It works as you said except that if one of the files is not in the directory and that loading routine doesn't kick off, the Run...

I tried what you said and the Run SP_... task kicks off before all of the files have loaded.