A very informative TSQL Post by Syed which explains a very interesting usage of the CROSS APPLY operator. Most of the times we see CROSS APPLY being used for joining the results of a TVF with a table or with the XML Data Type nodes() method. In this post, Syed explains how to use CROSS APPLY to write much more readable and manageable code.
http://smehrozalam.wordpress.com/2010/01/06/t-sql-calculating-cascading-computed-columns-using-cross-apply-operator/
Tags: TSQL,