SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
--MERGE SQL statement - Part 1

--Create a target table
CREATE TABLE Wrike_Task_Kimble_Log
(
   Taskid varchar(50)NOT NULL,
   Wrike_Update_Task_URL varchar(max),
   ActualMargin float,
   BudgetMargin float,
   IsProcessed bit default 0,
   Rootpid varchar(50)
) 


--Insert records into target table
INSERT INTO Wrike_Task_Kimble_Log (TaskId,Wrike_Update_Task_URL,ActualMargin,BudgetMargin,IsProcessed,Rootpid)
VALUES
   ('T1',NULL,10,5,0,'test1')


--Create source table
CREATE TABLE temp_Wrike_Kimble
(
   Taskid varchar(50)NOT NULL,
   Wrike_Update_Task_URL varchar(max),
   ActualMargin float,
   BudgetMargin float,
   IsProcessed bit default 0,
   Rootpid varchar(50)
) 


--Insert records into source table
INSERT INTO temp_Wrike_Kimble (TaskId,Wrike_Update_Task_URL,ActualMargin,BudgetMargin,IsProcessed,Rootpid)
VALUES
('T1',NULL,10,5,0,'test2')


SELECT * FROM Wrike_Task_Kimble_Log
SELECT * FROM temp_Wrike_Kimble


Taskid
Wrike_Update_Task_URL
ActualMargin
BudgetMargin
IsProcessed
Rootpid


T1
null
10
5
False
test1




Taskid
Wrike_Update_Task_URL
ActualMargin
BudgetMargin
IsProcessed
Rootpid


T1
null
10
5
False
test2


--MERGE SQL statement - Part 2

--Synchronize the target table with refreshed data from source table
MERGE Wrike_Task_Kimble_Log AS TARGET
USING temp_Wrike_Kimble AS SOURCE 
ON (TARGET.TaskId = SOURCE.TaskId)

WHEN MATCHED AND TARGET.Rootpid <> SOURCE.Rootpid AND TARGET.IsProcessed = SOURCE.IsProcessed 
THEN UPDATE SET TARGET.Rootpid = SOURCE.Rootpid

--When no records are matched, insert the incoming records from source table to target table
WHEN NOT MATCHED BY TARGET
THEN INSERT (TaskId,Wrike_Update_Task_URL,ActualMargin,BudgetMargin,IsProcessed,Rootpid) 
VALUES (SOURCE.TaskId, SOURCE.Wrike_Update_Task_URL,SOURCE.ActualMargin,SOURCE.BudgetMargin,SOURCE.IsProcessed,SOURCE.rootpid)

OUTPUT $action, 


INSERTED.TaskId AS TargetTaskId, 
INSERTED.Wrike_Update_Task_URL AS TargetWrike_Update_Task_URL,
INSERTED.ActualMargin AS TargetActualMargin, 
INSERTED.BudgetMargin AS TargetBudgetMargin,
INSERTED.IsProcessed AS TargetIsProcessed,
INSERTED.Rootpid AS TargetRootpid;



SELECT @@ROWCOUNT;


$action
TargetTaskId
TargetWrike_Update_Task_URL
TargetActualMargin
TargetBudgetMargin
TargetIsProcessed
TargetRootpid


UPDATE
T1
null
10
5
False
test2




(No column name)


1


INSERT INTO M
     (
       TaskId,Wrike_Update_Task_URL,ActualMargin,IsProcessed,Rootpid

     ) 
      SELECT S.TaskId,S.Wrike_Update_Task_URL,S.ActualMargin,S.IsProcessed,S.Rootpid
      FROM S s
	  LEFT JOIN M m
	  ON S.TaskId = M.TaskId --AND S.Wrike_Update_Task_URL = M.Wrike_Update_Task_URL
	  WHERE (M.TaskId IS NULL) OR (S.ActualMargin != M.ActualMargin)
Msg 208 Level 16 State 1 Line 1
Invalid object name 'S'.

SELECT * FROM Wrike_Task_Kimble_Log


Taskid
Wrike_Update_Task_URL
ActualMargin
BudgetMargin
IsProcessed
Rootpid


T1
null
10
5
False
test2