You could add the new MERGE operator added in Sql Server 2008. I believe it's the best way to perform multiple operations (INSERT/UPDATE/DELETE) at the same time.
Reggards, Emito.
Featured Editor
Brent Ozar
Editor In Chief
Editor-in-chief basically means that Brent keeps the pipes unclogged and makes sure the rest of the editors have the tools they need in…