hello,

The join between #source and #Target in the SELECT .... EXCEPT is not essential

You can obtain the same result with a best cost

SELECT .[ID]

, .[Item]

, .[Price]

, .[OrderDate]

, .[Units]

, .[ShipmentDate]

FROM [Source]

EXCEPT

SELECT [T].[ID]

, [T].[Item]

, [T].[Price]

, [T].[OrderDate]

, [T].[Units]

, [T].[ShipmentDate]

FROM [Target] [T]

;

Am I wrong?

Arnaud