What is Cross Apply and Outer Apply

By Greg No comments

A few years ago I needed to join a table to the result of a table-value function and came across Cross Apply. Cross Apply and Outer Apply were introduced back in SQL 2005.