rsluyter@web.de
I tried version 0.8 and i runs good so far but the
stored procedure´s listed have all the same code in.
Example Northwind DB:
Stored Procedures
CustOrderHist
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
Ten Most Expensive Products
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
Do I sthg. wrong or where is the error??
Thx in advance