Procedure: Northwind.dbo.[Sales by Year]

Collapse All Expand All

Procedure Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
Type	Standard T-SQL
Encrypted
ID	773577794
Implementation Type	Transact SQL

Creation options

Parameters

	Name	Description	DataType	Max Length	Type
	@Beginning_Date		datetime	8	Input
	@Ending_Date		datetime	8	Input

Recordsets returned

	Name	DataType	Max Length
	ShippedDate	datetime	8
	OrderID	int	4
	Subtotal	money	8
	Year	nvarchar	30

Objects that depend on [Sales by Year]

Objects that [Sales by Year] depends on

	Object Name	Object Type	Dep Level
	[Order Subtotals]	View	1
	Orders	Table	1
	Customers	Table	2
	Employees	Table	2
	[Order Details]	Table	2
	Shippers	Table	2
	Products	Table	3
	Categories	Table	4
	Suppliers	Table	4

Total 9 object(s)

Column Level Dependencies

	Object Name	Column	Object Type
	Orders	OrderID	Table
	Orders	ShippedDate	Table
	[Order Subtotals]	OrderID	View
	[Order Subtotals]	Subtotal	View

Total 4 column(s)

Graphical Dependencies

Permissions

Extended Properties

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

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
GO

See also

Buildmasters.com.au