>Thanks again! I just used this again.
>
If you want to learn more about this common problem, take a moment to check these blog posts

Optimizing TOP N per Group Queries - blog by Itzik Ben-Gan explaining various optimization ideas

Including an Aggregated Column's Related Values - Erik and mine blog presenting several solutions of the problem with explanations for each

Including an Aggregated Column's Related Values - Part 2 - my blog post with use cases for the previous blog