Hi Greg,

Would like to extend my sincere thanks for such beautiful and elaborate articles on SQL Server.

I have a question hovering in my mind from past few months since I have read about MERGE. Can we use multiple conditions in 'ON' clause . For example :

MERGE dbo.Sales AS T -- Target

USING dbo.NewSalesNAdjustments AS S -- Source

ON T.Id = S.Id

AND T.SalesAmount = S.SalesAmount -- Can we use this condition too in 'ON' clause ??? I did try

--to test this but I wasn't getting correct results

WHEN MATCHED THEN -- Update

UPDATE SET T.SalesAmount = S.SalesAmount

WHEN NOT MATCHED THEN -- Insert

INSERT (Id,SalesAmount) VALUES (S.Id,S.SalesAmount);

Please Advise !