SSChampion,

Thanks that worked.  max(MessageLogDate) as MessageLogDate was what I was missing.

In my searching, I started seeing ROW_NUMBER and OVER search variations.

Thanks, I'll try this and try to understand those elements a little better.

Correct.

I am searching through a log file to get distinct error messages.  The extra is to then grab them in a date range.