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)
Thank this author by sharing:
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 .
Cross Apply is Slow
Cross apply (and outer apply) are a very welcome addition to the TSQL language. However, today aft...
Return dynamic columns with CROSS APPLY
I have to apply different logic for each ID and as per the logic and a single row from each ID(group...
Discusses the use of the newly introduced APPLY Statement in SQL Server 2005