Ed Wagner (11/21/2014)

---

lshanahan (11/21/2014)

---

Recently been trying to wrap my brain around APPLY and it's sibling CROSS APPLY as I have some situations where they could prove useful.

I'm using 2005 at the moment, so I don't get to play with some of the other toys...(sniff) :crying:

APPLY lets you use a TVF (table-valued function) as a table in your query. Think of CROSS APPLY as an INNER JOIN and OUTER APPLY as an OUTER JOIN. To get you going, Paul White has published a couple of articles at http://www.sqlservercentral.com/articles/APPLY/69953/ and http://www.sqlservercentral.com/articles/APPLY/69954/.

Just as a hint so you start off in the right direction, for good performance your TVFs should be ITVFs - inline table-valued functions.