UPDATE a
SET a.enddate = GETDATE()
FROM [SERVER].[database].[dbo].[table] AS a
WHERE NOT EXISTS(SELECT * FROM [localdb].[dbo].[table] AS b
					INNER JOIN [localdb].[dbo].[table2] AS c
					ON  b.id = c.id AND a.key = c.id)