SQLSever 2012 introduces SQL Analytic Functions LAG and LEAD in Oracle Style .
In SqlServer 2008 or earlier, is possible, anyway, to obtain similar results using the TSQL APPLY operator .
Note that APPLY operator used in complex queries with large result can give lieu to poor performance, because APPLY executes using nested loop join algorythm : if needed, it will be necessary to ensure that first are executed hash joins and filter, and last outer apply , only on the final query result set .
