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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability