Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/selectchanges.sql

Created June 1, 2018 01:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tdmitch/4cce5627cf42b55de90c8c8a61fd4e2d to your computer and use it in GitHub Desktop.
Save tdmitch/4cce5627cf42b55de90c8c8a61fd4e2d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
selectchanges.sql
SELECT ct.ID
, e.FirstName
, e.MiddleName
, e.LastName
, ct.SYS_CHANGE_OPERATION [Operation]
FROM CHANGETABLE(CHANGES dbo.Emp, @StartVersionID) ct
LEFT JOIN dbo.Emp e
ON e.ID = ct.ID
WHERE (SELECT MAX(v) FROM (VALUES(ct.SYS_CHANGE_VERSION), (ct.SYS_CHANGE_CREATION_VERSION)) AS VALUE(v)) <= @EndVersionID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment