Description
CustOrderHist stored procedure
Parameters
| Name | Type | Direction | Description |
|---|---|---|---|
 @CustomerID |
nchar(5) | Input | My IN parameter description. |
Definition
CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)
AS
SELECT ProductName, Total=SUM(Quantity)
FROM Products P, [Order Details] OD, Orders O, Customers C
WHERE C.CustomerID = @CustomerID
AND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID
GROUP BY ProductName