Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 3: Building a Correlated Subquery RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 3: Building a Correlated Subquery

  • March 6, 2014 at 5:56 am

    #1694667

    The correlated subquery may be executed many times. It will be run once for each candidate row selected in the outer query.

    I believe that Jeff Moden refers to this as RBAR (row by agonizing row).

    A nice followup article would be "How to avoid using the Correlated Subquery."