title: when choose CROSS APPLY and when EXISTS?
body: <p>I read, <a href="http://social.msdn.microsoft.com/Forums/en/transactsql/thread/796821b0-ba48-49b4-ba42-1783061d8c41" rel="noreferrer">CROSS APPLY</a> is just like JOIN.. and I think JOIN can be accomplished with EXISTS also (correlated sub query)</p>
  
  <p>I am confused, what is the difference in using CROSS APPLY and EXISTS?</p>
  
  <p>when should I go for CROSS APPLY against EXISTS?</p>