Home Forums Article Discussions Article Discussions by Author Discuss content posted by Chris Morris The Cascading (CROSS) APPLY RE: The Cascading (CROSS) APPLY

  • April 16, 2013 at 9:29 am

    #1606874

    Tim Walker. (4/16/2013)

    Interesting, entertaining and educational with worked examples and performance statistics make this a great read.

    The fact that it is also genuinely very useful and will help me to accurately solve a problem I have right now makes it invaluable.

    Great job Chris. Thanks for sharing.

    Thank you very much, Tim. Almost every day, something comes up on ssc which requires a cCA or some other manipulation of APPLY. I don't know what we did without it.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden