In going through the code I realized that the code was still not quite right. Now the code pulls all rows where the ONLY status is 'Not Processed'. If there...

That did it. Now I have to dissect the code and figure out how it works.

No, because that doesn't look at the most recent entry for each order. It still returns most orders instead of just the ones that have "not processed" as the most...

No, all records where the most recent record is not processed. The results should only have included 37,38,41.

Any other ideas?

Okay, I was wrong. That query pulls any order that has ever had a status of 'Not processed'.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#orders','U') IS NOT NULL

DROP TABLE #orders

--===== Create...