T-SQL Querying

by Ben-Gan Itzik

CROSS APPLY allows you to apply a correlated table expression, you’re not limited to returning only one column.