SELECT * INTO temp_duplicates FROM tbl_master
INSERT INTO temp_duplicates
SELECT * FROM tbl_staging
SELECT id,name,COUNT(*)
FROM temp_duplicates
GROUP BY id,name
HAVING COUNT(*)>1
GO
INSERT INTO tbl_master
SELECT * FROM temp_duplciates
WHERE NOT EXISTS(SELECT 1 FROM tbl_master WHERE tbl_master.id = temp_duplciates.id AND tbl_master.name = temp_duplciates.name)
DROP TABLE duplicates
[Edit]Code block added[/Edit]