updateversionid.sql

MERGE etl.Change_Tracking_Version AS target
USING (
	SELECT 'Emp' [Table_Name]
		, ? [Version_ID] -- Get the change tracking version ID
) AS source
	ON target.Table_Name = source.Table_Name
WHEN MATCHED
THEN UPDATE 
SET target.Change_Tracking_Version = source.Version_ID
WHEN NOT MATCHED
THEN INSERT (Table_Name, Change_Tracking_Version)
VALUES (source.Table_Name, source.Version_ID);