Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag APPLY Rss

   Items 1 to 10 of 10   
 

Cross Apply

By Adrian D'Ews 2015/10/15 | Category: apply
Rating: (not yet rated) |  Discuss |   Briefcase | 1,614 reads

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 | 15,084 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 | 12,968 reads

APPLY - 2

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

APPLY - 1

By bitbucket-25253 2012/09/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,698 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 | 778 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 | 22,038 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,753 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 | 22,038 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,753 reads
   Items 1 to 10 of 10   
 
Tags
t-sql (5)    
sql server 2005 (2)    
sql server 2008 (2)    
advanced t-sql (1)    
analytic functions (1)    
cross apply (1)    
dry (1)    
lag (1)    
lead (1)    
queries (1)    
stairway series (1)    
top (1)    
top n (1)