There are two types of APPLY: CROSS APPLY and OUTER APPLY. CROSS APPLY returns only rows from the outer table that create a result set of table-valued function. OUTER APPLY returns both rows that create a result set as well as those rows where this is not the case. By table-valued function NULL values are [...]