See my code on page 4 of this thread - and it's Mike 😉

I can't go through the details of CLR with you- but basically it's c# that you publish to sql server (and you or your DBA need to do a bit of config to enable CLR on the server itself). SQL Server can then call the routine.

When I did this before it did 36k rows in under a second (according to my last post anyway!)