You have Polybase... ...{snip}... where all you need to focus on is the INSERT and NEVER THE UPDATE.
Now THAT's an interesting idea! I'm going to have to look into that and you should write an article on it. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row. First step towards the paradigm shift of writing Set Based code: ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.