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

Content with tags T-SQL, cross apply Rss

   Items 1 to 6 of 6   

The Christmas CROSS APPLY

By Steve Jones 2016/09/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,142 reads

CROSS APPLY on named sets

By M Martin 2016/01/13 | Category: cross apply
Rating: (not yet rated) |  Discuss |   Briefcase | 1,421 reads

The many uses of CROSS APPLY

Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...  Read more...
By Kenneth Fisher 2013/05/23 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 15,900 reads


I generally spend part of each day looking through, or I read through questions that have already...  Read more...
By Kenneth Fisher 2013/04/12 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,391 reads

Departures from Origins and Arrivals at Destinations

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.  Read more...
By Dwain Camps 2012/12/11 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,526 reads


That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.  Read more...
By Additional Articles 2009/11/06 | Source: | Category: t-sql
Rating:  Rate this |   Briefcase | 7,149 reads
   Items 1 to 6 of 6   
blogs (2)    
outer apply (2)    
cte (1)    
pivot (1)    
tally table (1)