Drew-

Thanks for the input. The table I am updating from is a daily updated temp table to a primary table of 23 billion records. So rather than using Merge I am attempting to perform a single update statement with transaction that then allows insert of the upload fails. The table will never be empty. In addition, the keys are SDP_ID and DateTime both, and there is no auto increment key so using a @@Identity scope is not possible either.