When I tried the Max(timestamp) query on my larger data set, I got multiples on business units if the timestamps was exactly the same for the download types. Meaning...

Yes this gives me the desired results.

I was so focused on the timestamp I did not think about the Manifest_ID.

THANKS!!

Jason

The expected results based on the data provided should be:

Business_Unit_ID Download_type Status_code timestamp

1002359 A ...

Thanks for pointing me in the right direction.

Here is the sql to create a table and the test data.

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