David Walker-278941 (4/19/2010)

---

This article, like many discussions of Cross Apply and Outer Apply, says "APPLY is named after the process of applying a set of input rows to a table-valued function."

It then backtracks a little and says that you don't have to use a table-valued function. Still, I think it's a disservice that many examples leave you with the impression that the only use for Apply is with functions.

I often use an expression on the right side of the Apply operator. I wish there were more examples like this.

The right side of the expression can be a correlated subquery, for example, and that can be very useful.