Get formatting and explanation in the article.
For a followup article, maybe you could go into more detail about where the changed data is located internally in SQL Server:
FROM [person].[person] source
INNER JOIN CHANGETABLE(CHANGES [person].[person], 0) ct
ON source.BusinessEntityID = ct.BusinessEntityID
WHERE ct.SYS_CHANGE_OPERATION = 'I' AND ct.SYS_CHANGE_VERSION <=4
Explain the CHANGETABLE(CHANGES [person].[person], 0) forus.
Thanks,
Thomas
Thomas LeBlanc, MVP Data Platform Consultant