Answer: Real life example, when to use OUTER / CROSS APPLY in SQL

answer re: Real life example, when to use OUTER / CROSS APPLY in SQL

Feb 14 '12

199

Some uses for APPLY are...

1) Top N per group queries (can be more efficient for some cardinalities)

SELECT pr.name,
       pa.name
FROM   sys.procedures pr
       OUTER APPLY (SELECT TOP 2 *
                    FROM   sys.parameters pa
                    WHERE  pa.object_id = pr.object_id
                    ORDER  BY pr.name) pa
ORDER  BY pr.name,
          pa.name

2) Calling a Table Valued…