Tag Info

bcp utility ORDER (column [ASC | DESC] [, ...n]) The sort order of the data in the data file. Bulk import performance is improved if the data being imported is sorted according to the clustered index ...

No there isn’t a way to run exec directly in the cte while it’s mostly a select statement alternative but you can use a temptable to get the output and use it in cte CREATE TABLE #t (...); INSERT ...