• 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