Tag Archives: CROSS APPLY

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

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

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

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

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

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


Get every new post delivered to your Inbox.

Join 847 other followers