SELECT distinct
ChTbl.projectid, ChTbl.outputid,
CHANGE_VERSION = SYS_CHANGE_VERSION,
CHANGE_CREATION_VERSION = SYS_CHANGE_CREATION_VERSION,
CHANGE_OPERATION = SYS_CHANGE_OPERATION,
DescriptionChanged = CHANGE_TRACKING_IS_COLUMN_IN_MASK
(COLUMNPROPERTY(OBJECT_ID('Results.ProjectOutput'), 'ProjectOutputDescription', 'ColumnId')
,ChTbl.sys_change_columns),
AssumptionChanged = CHANGE_TRACKING_IS_COLUMN_IN_MASK
(COLUMNPROPERTY(OBJECT_ID('Results.ProjectOutput'), 'Assumption', 'ColumnId')
,ChTbl.sys_change_columns)
FROM CHANGETABLE(CHANGES Results.ProjectOutput, 1) AS ChTbl
inner join Results.projectoutput RP on ChTbl.projectid = RP.projectid where ChTbl.projectid = 100003
Translate
Migrated from the original suvoBGD WordPress archive. View the original source.
legacy-blogwordpress-archive
