Tag Archives: CROSS APPLY
-
CROSS vs OUTER APPLY
2June 10, 2021 by Kenneth Fisher
I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
Continue reading -
Explain CROSS APPLY like I’m 5.
5May 11, 2020 by Kenneth Fisher
A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s …
Continue reading -
“sql_handle” is not a recognized table hints option.
Leave a commentSeptember 23, 2015 by Kenneth Fisher
I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
Continue reading -
You can’t use aggregate/windowing functions with CROSS APPLY
11October 6, 2014 by Kenneth Fisher
One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
Continue reading -
Lots of ways to UNPIVOT a table
Leave a commentAugust 21, 2013 by Kenneth Fisher
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
Continue reading -
Using CROSS APPLY to calculate an aggregate across a single row.
2May 28, 2013 by Kenneth Fisher
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last …
Continue reading -
Using CROSS APPLY instead of a calculated variable
3May 22, 2013 by Kenneth Fisher
Earlier this week I posted The many uses of CROSS APPLY and I’m quite glad I did. I’ve been working …
Continue reading -
The many uses of CROSS APPLY
4May 20, 2013 by Kenneth Fisher
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the …
Continue reading
SQL Studies 