Try this one , It might help ;

Merge into desttable as target

using

(

select col1, col2,col3,col4,col5 from sourcetable

except

select col1, col2,col3,col4,col5 from desttable

) as source

on target.col1=source.col1 -- (use primary key )

when matched then

update set target.col1=source.col1,

.......

when not matched bye target then insert

(col1,col2,col3,col4,col5) values (source.col1,.....)

merge statement to update or insert or delete the records.