-- 1️⃣ Expire current rows that are being updated UPDATE tgt SET EffectiveTo = src.EffectiveFrom, IsCurrent = 0 FROM dbo.DimCustomer tgt JOIN dbo.stg_Customer src ON tgt.CustomerKey = src.CustomerKey WHERE tgt.IsCurrent = 1 AND (tgt.Name <> src.Name OR tgt.Email <> src.Email OR tgt.Address <> src.Address);
Certain edited versions may appear on mainstream Japanese VOD services. Conclusion SSIS-668
=`Ранее („ "
-- 1️⃣ Expire current rows that are being updated UPDATE tgt SET EffectiveTo = src.EffectiveFrom, IsCurrent = 0 FROM dbo.DimCustomer tgt JOIN dbo.stg_Customer src ON tgt.CustomerKey = src.CustomerKey WHERE tgt.IsCurrent = 1 AND (tgt.Name <> src.Name OR tgt.Email <> src.Email OR tgt.Address <> src.Address);
Certain edited versions may appear on mainstream Japanese VOD services. Conclusion
=`Ранее („ "