Departures from Origins and Arrivals at Destinations

Tue, 11 Dec 2012 07:00:00 UT

A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.

Using T-SQL CROSS APPLY and OUTER APPLY

Fri, 06 Nov 2009 07:00:00 UT

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.

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

SQLServerCentral.com Articles tagged OUTER APPLY

Departures from Origins and Arrivals at Destinations

Using T-SQL CROSS APPLY and OUTER APPLY