Crap! I just discovered the problem.

Was testing (again), entering all but the last character. When I was typing the confirming entry my brain, having typed it so many times was...

Thank you both, Artoo22 & opc.three for your replies. I read the links.

The following is what I got out of the articles. Let me know if I'm on the right...

Actually, I'm glad you didn't. Having to execute the different scenarios was good practice for me to understand it...

The SNAPSHOT isolation level would have to be enabled at the database level before you could use it, so you will want to check with the DBA, if that's you,...

Thanks!

sp_who2 should have had a bit in the BlockBy column showing your open transaction blocking your other update. Won't see it now, but you could reproduce it by starting and...

I realize...

Problem Resolved: It was a PICNIC - Problem In Chair, Not In Computer

I had run an UPDATE on the table earlier in another query window, but, had not COMMITted it.

Discovered...

Are you asking for: dbo

i.e. dbo.ClosedJobsSumms

All the other tables created in this DB are dbo.

Stop The Presses... My Thread has been hijacked. 🙂

Would you please take this REFERENCES conversation to another thread?

Wow! 🙂

There's a lot I have to learn.

Some of what you mentioned was over my head. That's OK, just letting you know.

Did a cursory read of the Forum Etiquette....

LOL - I know what you mean.

If this customer follows their pattern, next year they will have a request with something else that is different. It's always been YTD Sales...

I just took a moment to get an appreciation of CTEs, found and article by Robert Sheldon, with examples that make it clear.

Jeff - What do you mean by the...

LOL - The first thing that pops into my head is that "10,000 Hours Rule" (Malcolm Gladwell, more familiar as a quote by Bill Gates).

Thanks for the advise. ... I...

🙂

So much to learn! And so little time. (ha, ha)

This job has been quite the learning experience for me. Before 2004, when I started, I had developed two custom ERP...

First! Thank you all for taking the time to reply. I appreciate all the feedback.

A little background about me and my situation. We have a 3rd party ERP system, SQL...