Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
-- the following external database with new prices should have ben created before execution of this script
CREATE TABLE tmpProductPrices
ProductId int
, Price number(10,2)
SET p.Price = tmp.Price
FROM Products AS p
INNER JOIN tmpProductPrices as tmp
ON p.ProductId = tmp.ProductId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment