Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Insert multiple rows in a table with a single select statement RE: Insert multiple rows in a table with a single select statement

  • February 12, 2014 at 2:29 pm

    #1688565

    Luis Cazares (2/12/2014)

    CROSS APPLY works similar to an [INNER] JOIN and OUTER APPLY works similar to LEFT [OUTER] JOIN. Maybe that will help you to understand it better.

    This article series by Paul White might help you:

    Understanding and Using APPLY (Part 1)[/url]

    Understanding and Using APPLY (Part 2)[/url]

    To be fair, you used it more like a cross join (exactly like one in fact), and outer apply would work the exact same when using it like this.

    For clarity, it is only when you join back to the main query in the definition or function parameters that they map to inner/outer join respectively