Aqui está
Otra cosa sí le agrego la condición que solo lo cambie cuando el precio sea diferente lo reescribiría así? :
Código SQL:
Ver originalUPDATE Item
SET Price = t1.Price
FROM
(
SELECT * FROM Item_Temp AS t1
LEFT JOIN Item AS t2 ON (t1.PartNumber = t2.PartNumber)
WHERE t2.PartNumber IS NOT NULL AND t1.Price <> t2.Price
) AS t1 WHERE t1.PartNumber = Item.PartNumber
WHERE t2.PartNumber IS NOT NULL AND t1.Price <> t2.Price
Muchas Gracias Namiwis,
Saludos Cordiales,