Please see link from this message #1413220 discussing this very problem in details.

>I'm having a group by brain-fart. Somebody please point me in the right direction...
>
>I have the following data:
>

>ID|FK|Status|StartDate
>1|1|Started|1/1/2008
>2|1|Finished|1/2/2008
>3|2|Started|3/2/2008
>4|3|Started|5/1/2008
>5|3|Finished|5/4/2008
>

>
>This is a transactional flow of items through statuses. I would like to see what status each item is currently set to, which should be the greatest StartDate. In my example, I want to see:
>

>FK|Status
>1|Finished
>2|Started
>3|Finished
>

>
>Thanks in advance!