Getting Sneaky With Forced Parameterization

In which Erik works around the documented limitations with CROSS APPLY.

Parse Data from a Field Containing Multiple Values using CROSS APPLY

It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.

The Christmas CROSS APPLY

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.

CROSS APPLY on named sets

Cross Apply

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...

UNPIVOT a table using CROSS APPLY

I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://www.sqlservercentral.com. I read through questions that have already...

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.

Find all actual words from Dictionary Table using jumbled word

How to get all actual word from a table,if I pass a jumbled word