It loops over one table and inserts the values, one by one, into another table. That's not hard to replace with a single insert.
You get better at programming by doing it, not by someone doing it for you, so give it a try.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass