View: Northwind.dbo.[Summary of Sales by Year]

Collapse All Expand All

View Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
Is Schema Bound
Encrypted
ID	725577623

Creation options

Resultset

	Name	Description	Data Type	Max Length
	ShippedDate		datetime	8
	OrderID		int	4
	Subtotal		money	8

Total: 3 column(s)

Indexes

Statistics

Objects that depend on [Summary of Sales by Year]

Objects that [Summary of 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

Extended Properties

Permissions

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

create view "Summary of Sales by Year" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate
GO

See also

Buildmasters.com.au