Tag Archives: CROSS APPLY

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

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

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

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

  5. 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 804 other followers