Thou cross apply and union all combined data set, the are used for different purpose. Cross apply is used when you want to interact with the data at the row level while union all is used to combined two data sets.