CROSS APPLY and OUTER APPLY in SQL Server
In this article, we are learning the use of the CROSS APPLY and OUTER APPLY SQL Server APPLY operator has two variants: CROSS APPLY and OUTER APPLY The CROSS APPLY operator returns only those rows from the left table expression (in its final output) if it matches with the right table
Read more