Skip to content

Instantly share code, notes, and snippets.

  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
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)
)
*/
UPDATE p
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