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 3:36 pm

    #1607064

    ChrisM@Work (4/16/2013)

    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.

    For single row things, we use to use "Correlated Sub-Queries" in the SELECT list. Of course, those didn't have the flexibility of returning multiple rows like Cross Apply does.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)