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

Articles with tag OUTER APPLY Rss

Search for any content tagged outer apply

   Items 1 to 3 of 3   
 

SQL Server CROSS APPLY and OUTER APPLY

Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.  Read more...
By Additional Articles 2016/02/17 | Source: MSSQLTips.com | Category: cross apply
Rating:  Rate this |   Briefcase | 6,538 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,521 reads

Using T-SQL CROSS APPLY and OUTER APPLY

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: developer.com | Category: t-sql
Rating:  Rate this |   Briefcase | 7,090 reads
   Items 1 to 3 of 3