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/2008This 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|FinishedThanks in advance!