In other words, good quality costs less.  Here it is, rediscovered.

Before working in IT for thirty years, I was a manufacturing quality control engineer (semiconductors).  We spent many hours...

Jack - -

The questions still stands, since we can set MAXDOP to 8, and have six users running hairy queries with eight schedulers each.

- - Herb

Actually, we're not going to be using per-core licensing. We will be way ahead of the game with CAL licensing.

Thank you all for your interesting and thoughtful responses.

If this query must executed frequently and from various contexts, you could put a trigger on nums that would store the most recent customer number. Then, you'd have instant...

I am a development DBA, and now somewhat production as well.

I implement views all the time; however, I don't want app code accessing anything other than a stored procedure. ...

I have been building DB systems on SQL Server since the days when Microsoft and Sybase were the same thing. My code is tightly structured and reusable. Read...

Are using a sheet reference, or named range? If you're using a named range, make sure that this range is defined properly.

Also, if you need to do fancy footwork...

What are you setting [Last Row] to?