The one thing I would suggest reading about is the MERGE statement. This may be what you really need.

Start here: http://msdn.microsoft.com/en-us/library/bb510625(v=sql.100).aspx.