Getting Sneaky With Forced Parameterization
In which Erik works around the documented limitations with CROSS APPLY.
2018-12-19
2,722 reads
In which Erik works around the documented limitations with CROSS APPLY.
2018-12-19
2,722 reads
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.
2019-06-07 (first published: 2017-10-30)
11,602 reads
2016-09-28
1,312 reads
Arshad Ali demonstrates what the APPLY operator is, how it differs from regular JOINs, and what its applications are.
2016-02-17
7,571 reads
2016-01-13
1,476 reads
2015-10-15
1,750 reads
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...
2013-05-23 (first published: 2013-05-20)
21,405 reads
I generally spend part of each day looking through http://www.stackoverflow.com, http://dba.stackexchange.com or http://qa.sqlservercentral.com. I read through questions that have already...
2013-04-12 (first published: 2013-04-01)
4,134 reads
A suggested design for creating flight schedules makes querying easy. Includes basic airport and airlines data. Get started now with this tricky query problem.
2012-12-11
12,158 reads
How to get all actual word from a table,if I pass a jumbled word
2012-09-27 (first published: 2012-09-05)
811 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers