Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Equivalente of LAG/LEAD for SqlServer2005/2008

By Federico Iori,

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 .

Total article views: 775 | Views in the last 30 days: 5
Related Articles

Cross Apply

Cross Apply is Slow


Cross Apply Ambiguity

Cross apply (and outer apply)  are a very welcome addition to the TSQL language.  However, today aft...


CROSS Apply or Outer Apply? DDL attached

Return dynamic columns with CROSS APPLY


to apply different logic for each ID and as per the logic and a single row from each ID(group) would be the result set

I have to apply different logic for each ID and as per the logic and a single row from each ID(group...


Correlated Joins Using "Apply"

Discusses the use of the newly introduced APPLY Statement in SQL Server 2005

analytic functions    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones