LISTING 3: Script to Update Every Row in the Package Table

CREATE TABLE
#PriceHolder
(PackageId INT,
PackagePrice MONEY)

INSERT #PriceHolder
SELECT Packages.PackageId,
PackagePrice = SUM(((Products.Productprice * Products_Items.Quantity) * Items_Packages.Quantity) *.90)
FROM Products
   INNER JOIN Products_Items ON Products.Productid = Products_Items.ProductId
      INNER JOIN Items ON Products_Items.ItemId = Items.ItemId 
      AND Items.ItemIsAvailable = 1
         INNER JOIN Items_Packages ON Items.ItemId = Items_Packages.ItemId
            INNER JOIN Packages ON Items_Packages.PackageId = Packages.PackageId
              GROUP BY Packages.PackageId

UPDATE Packages
SET PackagePrice = #PriceHolder.PackagePrice
 FROM #PriceHolder INNER JOIN Packages
 ON #PriceHolder.Packageid = Packages.PackageId
DROP TABLE #PriceHolder