LISTING 1: Stored Procedure to Retrieve Item Information

CREATE PROC GetItemInfo @Itemid INT
AS
SELECT Items.ItemName, Items.ItemDescription, Items.ItemImage,
ItemPrice = SUM(Products.ProductPrice * Products_Items.Quantity)
FROM Products
   INNER JOIN Products_Items ON Products.ProductId = Products_Items.ProductId
      INNER JOIN Items ON Products_Items.ItemId = Items.ItemId 
      AND Items.ItemId = @ItemId and Items.ItemIsAvailable = 1
GROUP BY Items.ItemName, Items.ItemDescription, Items.ItemImage