Hi Koen,

Yes. I want the two updates.

They will both be entered into the warehouse and have appropriate EffectiveFrom and EffectiveTo datetime fields. The latest one has a null EffectiveTo value.

They...

Hi Phil,

Yes. LastModifiedDateTime would work if you don't need to capture all change and don't allow deletions (which is a different story).

If you allow deletions and don't just mark them...

Thanks Andy. I'll check it out.