CROSS APPLY

On Twitter this morning I saw a plea for an explanation on what CROSS APPLY is in Transact-SQL.  I answered the question via email and then realized that it may make for a post here on The SQL Agent Man… When used, CROSS APPLY will execute the function listed in the CROSS APPLY sub-clause of the [...]