var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: strange update query ........
I have two tables [InvUpdate] and [product] the [InvUpdate] is sent to me everyday with updated inventory numbers and the [product] is my store database that I have to update .
I need to compare [product.product_inv] to [InvUpdate.Stock] and update [product.product_inv] if [InvUpdate.Stock] is different than [product.product_inv]
Something like :
UPDATE product, InvUpdate SET product.product_inv = InvUpdate.Stock
product.product_id and InvUpdate.ItemID are the part numbers and should be equal to allow the update .
I thought the statement above would work but , it wants to update like 30,000 rows in a database with only 1500 records ..........
on product.product_id = InvUpdate.ItemID
set product.product_inv = InvUpdate.Stock
where product.product_inv <> InvUpdate.Stock