Geeks With Blogs
Jim Giercyk January 2014 Entries
CROSS APPLY: SQLs Red-Headed stepchild
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', ......

Posted On Friday, January 3, 2014 10:30 AM

Copyright © Jim Giercyk | Powered by: