This is specfic for 2005:

It is IMPORTANT to perform the update first:

-- UPDATE Destination FROM (Source INTERSECT Destination)

-- INSERT INTO Destination FROM (Source EXCEPT Destination)