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

Content with tag APPLY Rss

   Items 1 to 9 of 9   
 

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 14,676 reads

Stairway to Advanced T-SQL Level 2: Using the APPLY Operator

The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.  Read more...
By Gregory Larsen 2015/01/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,495 reads

APPLY - 2

By bitbucket-25253 2012/10/01 | Category: apply
Rating: (not yet rated) |  Discuss |   Briefcase | 2,427 reads

APPLY - 1

By bitbucket-25253 2012/09/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,678 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 | 755 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 21,633 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 36,250 reads

Understanding and Using APPLY (Part 2)

The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.  Read more...
By Paul White 2012/01/13 (first published: 2010/04/19) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 21,633 reads

Understanding and Using APPLY (Part 1)

The first of a two-part series of articles examining the APPLY operator. Learn the basics of how this operator works and how it can help you solve some tricky problems.  Read more...
By Paul White 2012/01/06 (first published: 2010/04/12) | Source: SQLServerCentral.com | Category: apply
Rating: |  Discuss |   Briefcase | 36,250 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (5)    
sql server 2005 (2)    
sql server 2008 (2)    
advanced t-sql (1)    
analytic functions (1)    
dry (1)    
lag (1)    
lead (1)    
queries (1)    
stairway series (1)