Thanks guys, I appreciate the help!

Jude

Just to clarify, the apprentice_id has multiple agreement_ids. I was trying to return the most recent (by start_date) agreement_id for each apprentice_id. I initially tried to do it by an...

Thanks Jack!

Hey Seth,

As I am in a bit of a time crunch here, I'm going with Jack's solution. I really appreciate all the advice but I don't have time to play...

Hey Jack,

How do I turn on "show actual execution plan"? I'm a bit of a newbie to SQL Server. 😀

Thanks Seth, that works too. Is there a performance benefit to doing it your way over Jack's? Just so you know, the code will be a sub-query inside of another...

Thanks Jack! That does seem to work.

Jude

Thanks so much for your quick reply! What I want is the agreement_id that goes with the MAX(start_date). For each apprentice_id I have several agreement_id's. I want to pull the...