Matt Velic is hosting T-SQL Tuesday this month. You have a week to get a post ready on the apply operator.
To help you out, here’s the BOL page on Using the Apply operator. It’s an operator that essentially lets you invoke a table valued function for each row of a result set. Not necessarily the most efficient way to get some things done, but it can be a powerful way of combining complex data that requires a function to interpret.