SQLServerCentral.com Articles tagged cross apply

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.

Compatibility issue and CROSS APPLY

Thu, 06 Aug 2009 06:00:00 UT

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY

Split string using XML

Thu, 25 Jun 2009 06:00:00 UT

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.

Accessing results in a random order: Towards the automated Thank-you letter

Wed, 18 Mar 2009 06:00:00 UT

Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....