Understanding CROSS APPLY and OUTER APPLY in SQL Server

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

pietlinden SSC Guru Points: 63572 More actions · Answer 1

CROSS APPLY is analogous to INNER JOIN <table-valued function> and OUTER APPLY is analogous to OUTER JOIN <table-valued function>.

That was easy!

ildjarn.is.dead Ten Centuries Points: 1167 More actions · Answer 2

Itzik Ben-Gan has a nice video about the APPLY operator on YouTube:

MMartin1 One Orange Chip Points: 27836 More actions · Answer 3

Did you end up needing the #employees table ?

----------------------------------------------------