Tag Archives: CROSS APPLY



    June 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

  2. Explain CROSS APPLY like I’m 5.


    May 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

  3. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 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

  4. You can’t use aggregate/windowing functions with CROSS APPLY


    October 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

  5. Lots of ways to UNPIVOT a table

    Leave a comment

    August 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

  6. Using CROSS APPLY to calculate an aggregate across a single row.


    May 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

  7. Using CROSS APPLY instead of a calculated variable


    May 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

  8. The many uses of CROSS APPLY


    May 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013