Awesome, never seen
CROSS APPLY
used like this! FWIW it's 118x7 columns I'm combining here (I know, it's completely indecent!); the single table-scan issued 270,179 rows in 48 seconds - I'm shoving that query into a view and using that as my SSIS source now! —
Mat's Mug 1 min ago