Yesterday I wrote article about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. I had used CROSS APPLY in the query. I got email from one reader asking what is CROSS APPLY. In simpler words, cross apply is like inner join to table valued function which can take parameters. This particular operation is not possible to do using regular JOIN syntax You can see example of CROSS APPLY in my article here.
For further example and explanation of the CROSS APPLY I recommend the example from BOL, which is quite clear about what CROSS APPLY can do.
Reference : Pinal Dave (http://blog.SQLAuthority.com)