SQL Apply operator: CROSS APPLY and OUTER APPLY

Definition:   The APPLY operator is used to apply a table-valued function to each row of a table expression. It allows us to join a table expression …