Select current version when change tracking SQL - D365 FO
select 'CURRENT_VERSION' [CURRENT_VERSION], CHANGE_TRACKING_CURRENT_VERSION();
set @current_CT_Version = 63660
--63632, 63638, 63645, 63651, 63658, 63660, 63663, 63669
SELECT CT.SYS_CHANGE_OPERATION,*
FROM InventTable I
RIGHT OUTER JOIN
CHANGETABLE(CHANGES InventTable, 63669) AS CT
ON I.ITEMID = CT.ITEMID
No comments:
Post a Comment