Think of CROSS APPLY as a kind of INNER JOIN but without an ON predicate. It's real purpose is to easily use table valued functions, though I use it for other reasons too. Sometimes it reads better than inner join, sometimes not.
Think of CROSS APPLY as a kind of INNER JOIN but without an ON predicate. It's real purpose is to easily use table valued functions, though I use it for other reasons too. Sometimes it reads better than inner join, sometimes not.