Take Advantage of SQL Server 2012's Window Functionality. - Yitzhak, D. (SQL Server Pro, 2012)