Hello -
Can someone tell me what is wrong with this stored procedure? Sql Server is whining and I can't see why . . . maybe I've just looked at it too much --
Create Procedure QuarterlyOrdersByProject
@BeginDate datetime,
@EndDate datetime
AS
Select *
FROM
(Select Products.ProductName,
Orders.CustomerID, Year([OrderDate]) AS
OrderYear
From Products INNER JOIN (Orders Inner Join [Order Details] ON Orders.OrderID = [Order Details].OrderID) ON
Products.ProductID = [Order Details].ProductID
Where Orders.OrderDate >= @BeginDate and Orders.OrderDate <= @EndDate
Group By Products.ProductName, Orders.CustomerID, Year([OrderDate])) t
PIVOT
(SUM([Order Details].UnitPrice*[Order Details].Quantity*1-[Order Details].Discount])/100*100) as ProductAmount
FOR 'Qtr ' & DatePart(q, OrderDate) ...
Go to the complete details ...