This could most likely be done without a loop. As it appears you are also using SQL Server 2008, may I suggest you take a look at the MERGE statement?