Antares,

We do make use of lookup tables in most of our applications. These tables in particular are not taking full advantage of them. Also another good point on column order...

Thank you Antares,

That was very informative, and makes a lot of sense.  I guess our best bet is to index, defrag or reindex some tables if need be and...

OK so heres where my mind is going in circles,.. any help will be appreciated.

Below is a table with the results of an exponential moving average calculation for Eastman Kodak....

Heres so people get the idea of what exponential moving averages is all about,

http://www.stockcharts.com/education/IndicatorAnalysis/indic_movingAvg.html

I think we are looking for a moving average over a period of time, I would...