Northwind
Basic Index Expanded Index
| Stored Procedure: | Sales by Year |
| Parameter | Type | In/Out | | @Beginning_Date | datetime | IN |
| @Ending_Date | datetime | IN |
create procedure "Sales by Year"
@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal, DATENAME(yy,ShippedDate) AS Year
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date