Very funny Sturner - thanks for the smile.

I executed the 3 different statements as requested, each 3 times.

SALES_SUMMARY has 34,000 records, about 380 Bytes/record, data storage space is 14 MB

SalesForecast...

Thank you all for our assistance. I got a solution from Utter Access message board.

UPDATE DIAPLUSDB.dbo.SalesForecast

SET JUL_FOR = isnull(sf.JUL_FOR,0) +

( SELECT SUM(SLS_DOL)

...

Thanks. I started out trying to do just that - I use aggregate functions in SELECT statements.

I couldn't figure out how to construct the statement by including the SUM and...

Please accept my apologies! Problem solved.

Your responses (and it being the morning when my mind is fresh) got me to stop and 'walk' through everything again.

I knew the wildcard pertained...

Again - Thanks for your help (and Excel's Text To Column Functionality).

Sean! Hi again!

No, at this time I want to exclude the % records.

The original clause was, WHERE EST_UOM <> '%'

The results included the % records. I want the results to...

Hi Sean,

Thanks for continuing to help me out. I'm working on it, in between other tasks.

1. It looks like we can't split the results into separate columns, but, are going...

Hi Sean,

Thanks for the reply. This isn't a Pivot situation. There is no column/field to determine which column it is to be assigned to. Quick analogy: 2 Tables: (1) Parents...

Thanks for the reply. Good point. I checked the Maintenance Plan entries - they reference E:It was good to get this information, a tidbit for future checklists - I learned...

Actually the question is simply to understand whether SQL Server can be the culprit or I can contact the vendor and request a bug fix.I have no plans to dig...

Yes! Standard Rule Of Thumb (IMO) for Quantity On Hand (QOH) "Don't store totals, always calculate on demand." And, you're right that the consideration is response time, i.e. when the...

I inquired with our ERP system vendor about changing database level setting and they do NOT recommend the change.

Of course my mind wants to understand. Not knowing 'what goes on...

Thanks for the suggestion Gail.

Read up on Read Committed Snapshot and it sounds good.

Since I'm working with our LIVE database I want to be sure all the bases are covered...

Sean - Thanks for your input. I appreciate it - especially since I'm still wet behind the ears and need to be aware of things to consider and be aware...

Richard - Thanks!

What you know is correct.

And, I learned something else, because simply substituting for the column name didn't work. I also had to remove the ORD_MACH_OPS (table) reference -...