OK.Thank you. This is the whole code i wanted to use:

MERGE INTO dbo.Client_SCD2 AS DST

USING dbo.Client AS SRC

ON SRC.ID = DST.BusinessKey

AND DST.ClientName=SRC.ClientName

AND DST.Country = SRC.Country

AND DST.Town=SRC.Town

AND DST.Address1=SRC.Address1

AND DST.Address2=SRC.Address2

AND DST.ClientType=SRC.ClientType

AND DST.ClientSize=SRC.ClientSize

WHEN...

Thank you! Great article!

I have question about SCD type 2.

Can we compare all columns in ON clause like this:

MERGE INTO dbo.Client_SCD2 AS DST

USING dbo.Client AS SRC

ON SRC.ID = DST.BusinessKey

AND DST.ClientName=SRC.ClientName

AND...