Thanks! It wasn't clear to me that SELECT INTO wasn't INSERT SELECT. Microsoft documentation is often inprecise. I'll look into this. We cannot change most of the SQL, but we...

There is no order by. Both queries are the same query. In the application we are moving data from a staging area into the live area after appropriately scrubbing the...