Procedure: Northwind.dbo.[Employee Sales by Country]

Collapse All Expand All

Procedure Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
Type	Standard T-SQL
Encrypted
ID	757577737
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
	Country	nvarchar	15
	LastName	nvarchar	20
	FirstName	nvarchar	10
	ShippedDate	datetime	8
	OrderID	int	4
	SaleAmount	money	8

Objects that depend on [Employee Sales by Country]

Objects that [Employee Sales by Country] depends on

	Object Name	Object Type	Dep Level
	Employees	Table	1
	[Order Subtotals]	View	1
	Orders	Table	1
	Customers	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
	Employees	EmployeeID	Table
	Employees	Country	Table
	Employees	LastName	Table
	Employees	FirstName	Table
	Orders	OrderID	Table
	Orders	EmployeeID	Table
	Orders	ShippedDate	Table
	[Order Subtotals]	OrderID	View
	[Order Subtotals]	Subtotal	View

Total 9 column(s)

Graphical Dependencies

Permissions

Extended Properties

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

create procedure "Employee Sales by Country" 
@Beginning_Date DateTime, @Ending_Date DateTime AS
SELECT Employees.Country, Employees.LastName, Employees.FirstName, Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal AS SaleAmount
FROM Employees INNER JOIN 
    (Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID) 
    ON Employees.EmployeeID = Orders.EmployeeID
WHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date
GO

See also

Buildmasters.com.au