SQL Merge Statement

gistfile1.sql

select * from toolkitnotifications;

MERGE toolkitnotifications as target
USING (
  select 
		ti.N2ItemId, ti.Id as ToolkitItemId, t.UserId, GETDATE() as Created, 'UpdatedContent' as [Action]
	FROM ToolkitItems ti
		LEFT JOIN Toolkits t
		ON ti.ToolkitId = t.Id
		WHERE ti.IsDeleted = 0
		AND t.IsDeleted = 0
		AND t.IsDefault = 0
		AND ti.N2ItemId = 196
) as source
ON target.N2ItemId = source.N2ItemId
AND target.ToolkitItemId = source.ToolkitItemId
AND target.UserId = source.UserId
AND target.IsRead = 0
AND target.[Action] = source.[Action]
WHEN MATCHED THEN
	UPDATE SET Created = GetDate()
WHEN NOT MATCHED THEN
	INSERT(n2itemid, toolkititemid, userid, Created, [Action])
	VALUES (source.N2ItemId, source.ToolkitItemId, source.UserId, GetDate(), source.[Action]);

select * from toolkitnotifications;

update toolkitnotifications set isread = 0