Many SQL developers shy away from the CROSS APPLY, because it is not very well understood. There is not a lot of documentation or examples available online; CROSS APPLY is the SQL Query’s Redheaded step-child, but also a well-kept secret. Essentially, all a CROSS APPLY does is connect 2 queries that cannot be resolved as stand-along queries. Using the AdventureWorks2008R2 database, I have put together a simple example: USE AdventureWorks2008R2 SELECT p.FirstName + ' ' + p.LastName 'Sales Person', ......