Say a record is defined with attribute A as primary key and some other attributes like B, C and D.
If now an update on record A1 is happened, then one or more values for B, C, D changed.
I worked with CHECKSUM(,, ) to check if an update of on a record is happened (e.g. a price change of an instrument). This because the performance is very essential to get the data processed and ready (so I cannot do a simple update on each column)
In certain cases the CHECKSUM deliver the same number even an update was happen.
see example for
CHECKSUM('Misc Partner - Central North - Central North')
CHECKSUM('Misc Partner - Central South - Central South')
I also can work with HASHBytes which can lead to same behavior.
What else can I try?