Maybe the OP wants to use something like the MERGE statement http://msdn.microsoft.com/en-us/library/bb510625(v=sql.100).aspx

Dave