That said, even though my personal focus is pretty much OO, I still miss stuff. SQL Server 2005 came out with the CROSS APPLY and OUTER APPLY operators and I have just started learning how to use APPLY in the last month or so. When I think I have it figured out, I am fortunate enough that some of you are interested in reading about my understanding of the technology.  Read more...

This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY  Read more...

Learn how you can split a delimited string in a single query using XML with Divya Agrawal.  Read more...

Phil shows how 'CROSS APPLY' can be useful for writing thank-you letters or thinking of excuses as to why your project has failed....  Read more...