updatedelete.sql

-- Updates
UPDATE dw
SET dw.FirstName = dws.FirstName
	, dw.MiddleName = dws.MiddleName
	, dw.LastName = dws.LastName
	, dw.UpdatedDate = dws.UpdatedDate
FROM [dw].[DimEmp] dw
INNER JOIN [dwstage].[DimEmp] dws
	ON dw.EmpID = dws.EmpID
WHERE dws.Operation = 'U'

-- Deletes
UPDATE dw
SET dw.Active = dws.Active
	, dw.UpdatedDate = dws.UpdatedDate
FROM [dw].[DimEmp] dw
INNER JOIN [dwstage].[DimEmp] dws
	ON dw.EmpID = dws.EmpID
WHERE dws.Operation = 'D'