Hello kev4king2000,

maybe like this:

BEGIN TRAN

DECLARE @ETL_HISTORY TABLE(

[Action] [varchar](50) NULL,

[New_FirstName] [nvarchar](50) NULL,

[New_MiddleName] [nvarchar](50) NULL,

[New_LastName] [nvarchar](50) NULL,

[New_EmailAddress] [nvarchar](50) NULL,

[Old_FirstName] [nvarchar](50) NULL,

[Old_MiddleName] [nvarchar](50) NULL,

[Old_LastName] [nvarchar](50) NULL,

[Old_EmailAddress] [nvarchar](50) NULL)--,

MERGE DBO.Contact T

USING Person.Contact S

ON T.EmailAddress...