merge.sql

MERGE etl.Change_Tracking_Version AS target
USING (SELECT 'Emp' [Table_Name]
, CHANGE_TRACKING_CURRENT_VERSION() [Version_ID] — Get the change tracking version ID
) AS source
ON target.Table_Name = source.Table_Name

WHEN MATCHED — Exists? Then update
THEN UPDATE
SET target.Change_Tracking_Version = source.Version_ID

WHEN NOT MATCHED — No match? Insert
THEN INSERT (Table_Name, Change_Tracking_Version)
VALUES (source.Table_Name, source.Version_ID)