Created
June 1, 2018 01:10
-
-
Save tdmitch/156fe3be7d6c40a04e8a3834d2c2b83d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @StartVersionID BIGINT | |
, @EndVersionID BIGINT | |
-- Set the starting version ID | |
SET @StartVersionID = (SELECT Change_Tracking_Version | |
FROM etl.Change_Tracking_Version | |
WHERE Table_Name = 'Emp') | |
-- Set the ending version ID | |
SET @EndVersionID = CHANGE_TRACKING_CURRENT_VERSION() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment