Learn about SQL Server CROSS APPLY and OUTER APPLY and how they differ from regular JOINs and how to use these along with scripts and a video.