Question: what is the difference between cross join and cross apply?
Answer: CROSS JOIN returns a Cartesian product so if you have 10 rows in each table the query will return 100 rows, 1 row for each combination. CROSS APPLY from BOL: The APPLY operator allows you to invoke a table-valued function for each row returned by an outer table expression of a query.