Get the Most Current Row From a Detail Table

This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.