Using Ranking and Windowing Functions in SQL Server 2005. See it here.
Page rendered at Friday, March 19, 2010 4:44:28 PM (Eastern Daylight Time, UTC-04:00)
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.