Hi here it is..

MERGE dbo.TargetTable as Target

USING dbo.ImportTable as Source

ON (source.WidgetID = Target.WidgetID)

WHEN MATCHED

THEN UPDATE SET

Target.Attribute1 = Source.Attribute1,

Target.Attribute2 = Source.Attribute2,

Target.Attribute3 = Source.Attribute3,

Target.DateTimeStamp = Source.DateTimeStamp;

Based on my understanding of MERGE I...