Thanks Sergiy,

That is a cleaner solution.

Because I am stubborn, I probably keep calculated field in the criteria. In my working database, it is persisted with an index, but the index...

It doesn't like text files either. Lets try with a zip.

True. I need a new brain.

Renamed the file to *.txt

I tried to attach the plan. I missed this message.

Upload Errors:

Trouble_Level100.sqlplan: Sorry, this file type is not permitted for security reasons.

So I guess I won't be doing that. I'm not...

Eirikur - Sure I've attached the plan running at Level 100.

This area of SQL, I am very much still learning. I can spot some stuff, but I'm still gaining the...

I figured it was something besides compatibility level, but I just could not see it.

Lynn's solution is able to meet my needs with pulling the view out of the Order...

Thanks Alan,

I've been scratching my head about it. The Ten Percent function was designed to grab a random set of records. Using the New ID is a pseudo way to...