CROSS APPLY

Table-values constructor

Data modification statements

Combination of detailed and aggregated data

Getting summarizing values

CROSS APPLY / OUTER APPLY

New sql features