Taking a look at CROSS APPLY (SQL Server 2005)

I think the easiest way to think of CROSS APPLY is that it is like doing a CROSS JOIN with a correlated sub-query instead of a derived table. Let's take a look ....