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)
pinaldave
I will very thankful to you if you add the details and example of OUTER APPLY and what is the difference between CROSS APPLY and OUTER APPLY………..
Thanks & Regards
Shashi Kant Chauhan
really fine and helpful………
thank you!!!!!!!!!1111
…….Ak
Example of Cross apply and outer apply