Follow up
Gh.., March 22, 2017 - 7:06 pm UTC
What is you opinion :
If big table say many millions od rows .Use exchange as you suggest above.
If small tables use a regular staging area ed. Insert..Select.
Plesae elaborate.
March 23, 2017 - 3:47 am UTC
Do whatever works easiest and best for you.
I hate "rules"...I prefer to test options, weigh pros and cons of each up against my business requirements, and work from that.