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

Content with tag LAG Rss

   Items 1 to 8 of 8   
 

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2014/05/27 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 11,825 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.   Read more...
By Eirikur Eiriksson 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 8,550 reads

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...
By Wayne Sheffield 2013/12/26 (first published: 2012/01/19) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 18,820 reads

The SQL of Gaps and Islands in Sequences

Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.  Read more...
By Additional Articles 2013/08/13 | Source: SimpleTalk | Category: gaps
Rating:  Rate this |   Briefcase | 2,337 reads

SQL Server Analysis Services-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions

Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead functions. Are these functions available in SSAS? What other related functions are available?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,385 reads

Equivalente of LAG/LEAD for SqlServer2005/2008

Is possible to get similar result as analytic function LAG/LEAD using operator APPLY  Read more...
By Federico Iori 2012/06/18 | Source: SQLServerCentral.com | Category: lag
Rating: (not yet rated) |  Discuss |   Briefcase | 695 reads

Analytic Enhancements in SQL Server 2012 - Part II

The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.  Read more...
By Additional Articles 2012/04/25 | Source: Database Journal | Category: sql server 2012
Rating:  Rate this |   Briefcase | 2,998 reads

The new Analytic functions in SQL Server 2012

SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.  Read more...
By Wayne Sheffield 2013/12/26 (first published: 2012/01/19) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 18,820 reads
   Items 1 to 8 of 8   
 
Tags
lead (6)    
sql server 2012 (3)    
analysis services (ssas) (2)    
t-sql (2)    
analytic function (1)    
analytic functions (1)    
apply (1)    
closingperiod (1)    
cte (1)    
cume_dist (1)    
cursor (1)    
datediff (1)    
first_value (1)    
gaps (1)    
last_value (1)    
openingperiod (1)    
over clause (1)    
percent_rank (1)    
percentile_cont (1)    
percentile_dist (1)    
performance (1)    
window function (1)    
window functions (1)