MERGE TargetTable target
USING (SELECT DISTINCT X FROM SourceTableImport) source
ON target.Key = source.Key
WHEN MATCHED THEN
  UPDATE SET ...
WHEN NOT MATCHED BY TARGET THEN
  INSERT (...) VALUES (...);