Cross Apply, Outer Apply some unique scenarios.

A deeper look at Cross Apply and Outer Apply trying to resolve a performance issue with my query which was challenging to get with the traditional joins. CROSS APPLY allows for more detailed control on individual rows, while INNER JOIN operates on sets of data. It becomes very useful when we need to perform row-wise operations or apply subqueries dynamically for each row.