USE [AdventureWorks]
GO
/****** Object:  Table [Production].[Location]    Script Date: 05/31/2009 11:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Production].[Location]') AND type in (N'U'))
BEGIN
CREATE TABLE [Production].[Location](
	[LocationID] [smallint] IDENTITY(1,1) NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[CostRate] [smallmoney] NOT NULL,
	[Availability] [decimal](8, 2) NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Location_LocationID] PRIMARY KEY CLUSTERED 
(
	[LocationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'COLUMN',N'LocationID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Location records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'LocationID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Location description.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'COLUMN',N'CostRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Standard hourly cost of the manufacturing location.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'CostRate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'COLUMN',N'Availability'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Work capacity (in hours) of the manufacturing location.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'Availability'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'COLUMN',N'ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product inventory and manufacturing locations.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'PK_Location_LocationID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key (clustered) constraint' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'PK_Location_LocationID'
GO
SET IDENTITY_INSERT [Production].[Location] ON
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (1, N'Tool Crib', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (2, N'Sheet Metal Racks', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (3, N'Paint Shop', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (4, N'Paint Storage', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (5, N'Metal Storage', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (6, N'Miscellaneous Storage', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (7, N'Finished Goods Storage', 0.0000, CAST(0.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (10, N'Frame Forming', 22.5000, CAST(96.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (20, N'Frame Welding', 25.0000, CAST(108.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (30, N'Debur and Polish', 14.5000, CAST(120.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (40, N'Paint', 15.7500, CAST(120.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (45, N'Specialized Paint', 18.0000, CAST(80.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (50, N'Subassembly', 12.2500, CAST(120.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
INSERT [Production].[Location] ([LocationID], [Name], [CostRate], [Availability], [ModifiedDate]) VALUES (60, N'Final Assembly', 12.2500, CAST(120.00 AS Decimal(8, 2)), CAST(0x00008C6900000000 AS DateTime))
SET IDENTITY_INSERT [Production].[Location] OFF
/****** Object:  Table [Purchasing].[ShipMethod]    Script Date: 05/31/2009 11:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]') AND type in (N'U'))
BEGIN
CREATE TABLE [Purchasing].[ShipMethod](
	[ShipMethodID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[ShipBase] [money] NOT NULL,
	[ShipRate] [money] NOT NULL,
	[rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_ShipMethod_ShipMethodID] PRIMARY KEY CLUSTERED 
(
	[ShipMethodID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'ShipMethodID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for ShipMethod records.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipMethodID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company name.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'ShipBase'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Minimum shipping charge.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipBase'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'ShipRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping charge per pound.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ShipRate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'rowguid'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'rowguid'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'COLUMN',N'ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping company lookup table.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'PK_ShipMethod_ShipMethodID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key (clustered) constraint' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'PK_ShipMethod_ShipMethodID'
GO
SET IDENTITY_INSERT [Purchasing].[ShipMethod] ON
INSERT [Purchasing].[ShipMethod] ([ShipMethodID], [Name], [ShipBase], [ShipRate], [rowguid], [ModifiedDate]) VALUES (1, N'XRQ - TRUCK GROUND', 3.9500, 0.9900, N'6be756d9-d7be-4463-8f2c-ae60c710d606', CAST(0x00008C6900000000 AS DateTime))
INSERT [Purchasing].[ShipMethod] ([ShipMethodID], [Name], [ShipBase], [ShipRate], [rowguid], [ModifiedDate]) VALUES (2, N'ZY - EXPRESS', 9.9500, 1.9900, N'3455079b-f773-4dc6-8f1e-2a58649c4ab8', CAST(0x00008C6900000000 AS DateTime))
INSERT [Purchasing].[ShipMethod] ([ShipMethodID], [Name], [ShipBase], [ShipRate], [rowguid], [ModifiedDate]) VALUES (3, N'OVERSEAS - DELUXE', 29.9500, 2.9900, N'22f4e461-28cf-4ace-a980-f686cf112ec8', CAST(0x00008C6900000000 AS DateTime))
INSERT [Purchasing].[ShipMethod] ([ShipMethodID], [Name], [ShipBase], [ShipRate], [rowguid], [ModifiedDate]) VALUES (4, N'OVERNIGHT J-FAST', 21.9500, 1.2900, N'107e8356-e7a8-463d-b60c-079fff467f3f', CAST(0x00008C6900000000 AS DateTime))
INSERT [Purchasing].[ShipMethod] ([ShipMethodID], [Name], [ShipBase], [ShipRate], [rowguid], [ModifiedDate]) VALUES (5, N'CARGO TRANSPORT 5', 8.9900, 1.4900, N'b166019a-b134-4e76-b957-2b0490c610ed', CAST(0x00008C6900000000 AS DateTime))
SET IDENTITY_INSERT [Purchasing].[ShipMethod] OFF
/****** Object:  Table [Purchasing].[Vendor]    Script Date: 05/31/2009 11:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Purchasing].[Vendor]') AND type in (N'U'))
BEGIN
CREATE TABLE [Purchasing].[Vendor](
	[VendorID] [int] IDENTITY(1,1) NOT NULL,
	[AccountNumber] [dbo].[AccountNumber] NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[CreditRating] [tinyint] NOT NULL,
	[PreferredVendorStatus] [dbo].[Flag] NOT NULL,
	[ActiveFlag] [dbo].[Flag] NOT NULL,
	[PurchasingWebServiceURL] [nvarchar](1024) NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Vendor_VendorID] PRIMARY KEY CLUSTERED 
(
	[VendorID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'VendorID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Vendor records.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'VendorID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'AccountNumber'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Vendor account (identification) number.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'AccountNumber'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'Name'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Company name.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'Name'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'CreditRating'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'CreditRating'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'PreferredVendorStatus'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'PreferredVendorStatus'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'ActiveFlag'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Vendor no longer used. 1 = Vendor is actively used.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'ActiveFlag'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'PurchasingWebServiceURL'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Vendor URL.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'PurchasingWebServiceURL'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'COLUMN',N'ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Companies from whom Adventure Works Cycles purchases parts or other goods.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'CONSTRAINT',N'PK_Vendor_VendorID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key (clustered) constraint' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'CONSTRAINT',@level2name=N'PK_Vendor_VendorID'
GO
SET IDENTITY_INSERT [Purchasing].[Vendor] ON
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (1, N'INTERNAT0001', N'International', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (2, N'ELECTRON0002', N'Electronic Bike Repair & Supplies', 1, 1, 1, NULL, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (3, N'PREMIER0001', N'Premier Sport, Inc.', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (4, N'COMFORT0001', N'Comfort Road Bicycles', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (5, N'METROSP0001', N'Metro Sport Equipment', 1, 1, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (6, N'GREENLA0001', N'Green Lake Bike Company', 1, 1, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (7, N'MOUNTAIN0001', N'Mountain Works', 1, 0, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (8, N'CONTINEN0001', N'Continental Pro Cycles', 3, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (9, N'ADATUM0001', N'A. Datum Corporation', 1, 1, 1, N'www.adatum.com/', CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (10, N'TREYRE0001', N'Trey Research', 3, 1, 1, N'www.treyresearch.net/', CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (11, N'ANDERSON0001', N'Anderson''s Custom Bikes', 1, 1, 1, NULL, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (12, N'COMPETE0002', N'Compete, Inc.', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (13, N'BEAUMONT0001', N'Beaumont Bikes', 1, 0, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (14, N'LIGHTSP0001', N'Light Speed', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (15, N'SUPERSAL0001', N'SUPERSALES INC.', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (16, N'IMAGEMA0001', N'Image Makers Bike Center', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (17, N'COMPETE0001', N'Compete Enterprises, Inc', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (18, N'G&KBI0001', N'G & K Bicycle Corp.', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (19, N'CYCLING0001', N'Cycling Master', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (20, N'JEFFSSP0001', N'Jeff''s Sporting Goods', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (21, N'BUSINESS0001', N'Business Equipment Center', 2, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (22, N'VICTORY0001', N'Victory Bikes', 5, 1, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (23, N'NORSTAN0001', N'Norstan Bike Hut', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (24, N'FIRSTRA0001', N'First Rate Bicycles', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (25, N'READYRE0001', N'Ready Rentals', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (26, N'FIRSTNA0001', N'First National Sport Co.', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (27, N'CAPITAL0001', N'Capital Road Cycles', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (28, N'WIDEWOR0001', N'Wide World Importers', 2, 1, 1, N'www.wideworldimporters.com/', CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (29, N'INTEGRAT0001', N'Integrated Sport Products', 1, 1, 1, NULL, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (30, N'CONSUMER0001', N'Consumer Cycles', 3, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (31, N'FEDERAL0001', N'Federal Sport', 3, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (32, N'ADVANCED0001', N'Advanced Bicycles', 1, 1, 1, NULL, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (33, N'SIGNATUR0001', N'Signature Cycles', 2, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (34, N'INDIANA0001', N'Indiana Bicycle Center', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (35, N'MITCHELL0001', N'Mitchell Sports', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (36, N'RECREATI0001', N'Recreation Place', 4, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (37, N'INNERCI0001', N'Inner City Bikes', 3, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (38, N'ALLENSON0001', N'Allenson Cycles', 2, 1, 1, NULL, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (39, N'HILLSBI0001', N'Hill''s Bicycle Service', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (40, N'WESTJUN0001', N'West Junction Cycles', 1, 1, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (41, N'SPEEDCO0001', N'Speed Corporation', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (42, N'LEGENDC0001', N'Legend Cycles', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (43, N'INLINEA0001', N'Inline Accessories', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (44, N'COMPETIT0001', N'Competition Bike Training Systems', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (45, N'CHICAGO0001', N'Chicago City Saddles', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (46, N'BURNETT0001', N'Burnett Road Warriors', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (47, N'BIKESAT0001', N'Bike Satellite Inc.', 1, 0, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (48, N'GARDNER0001', N'Gardner Touring Cycles', 1, 0, 0, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (49, N'MAGICCY0001', N'Magic Cycles', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (50, N'VISIONC0001', N'Vision Cycles, Inc.', 1, 0, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (51, N'BERGERON0001', N'Bergeron Off-Roads', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (52, N'HYBRIDB0001', N'Hybrid Bicycle Center', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (53, N'JACKSON0001', N'Jackson Authority', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (54, N'PROSPOR0001', N'Pro Sport Industries', 1, 0, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (55, N'SPORTFA0001', N'Sport Fan Co.', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (56, N'INTERNAT0002', N'International Bicycles', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (57, N'WOODFIT0001', N'Wood Fitness', 1, 1, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (58, N'MIDWEST0001', N'Midwest Sport, Inc.', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (59, N'ELECTRON0001', N'Electronic Bike Co.', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (60, N'INTERNAT0003', N'International Sport Assoc.', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (61, N'LINDELL0001', N'Lindell', 1, 1, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (62, N'TRAINING0001', N'Training Systems', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (63, N'MERITBI0001', N'Merit Bikes', 5, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (64, N'CIRCUIT0001', N'Circuit Cycles', 1, 0, 0, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (65, N'INTERNAT0004', N'International Trek Center', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (66, N'LAKEWOOD0001', N'Lakewood Bicycle', 1, 1, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (67, N'KNOPFLER0001', N'Knopfler Cycles', 1, 1, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (68, N'LEAFRIV0001', N'Leaf River Terrain', 1, 0, 1, NULL, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (69, N'NATIONAL0001', N'National Bike Association', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (70, N'SPORTPL0001', N'Sport Playground', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (71, N'VISTARO0001', N'Vista Road Bikes', 3, 1, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (72, N'VARSITY0001', N'Varsity Sport Co.', 1, 1, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (73, N'CROWLEY0001', N'Crowley Sport', 1, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (74, N'AUSTRALI0001', N'Australia Bike Retailer', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (75, N'NORTHERN0001', N'Northern Bike Travel', 3, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (76, N'CRUGERB0001', N'Cruger Bike Company', 1, 1, 1, NULL, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (77, N'CUSTOMF0001', N'Custom Frames, Inc.', 2, 1, 1, NULL, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (78, N'AURORAB0001', N'Aurora Bike Center', 1, 1, 1, NULL, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (79, N'GMASKI0001', N'GMA Ski & Bike', 1, 1, 1, NULL, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (80, N'BICYCLE0001', N'Bicycle Specialists', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (81, N'BLOOMING0001', N'Bloomington Multisport', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (82, N'ILLINOIS0001', N'Illinois Trek & Clothing', 1, 1, 1, NULL, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (83, N'LITWARE0001', N'Litware, Inc.', 1, 1, 1, N'www.litwareinc.com/', CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (84, N'PROSE0001', N'Proseware, Inc.', 4, 0, 0, N'www.proseware.com/', CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (85, N'AMERICAN0001', N'American Bicycles and Wheels', 1, 1, 1, NULL, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (86, N'CARLSON0001', N'Carlson Specialties', 2, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (87, N'EXPERTB0001', N'Expert Bike Co', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (88, N'GREENWOO0001', N'Greenwood Athletic Company', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (89, N'SPORTSH0001', N'Sports House', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (90, N'RELIANCE0001', N'Reliance Fitness, Inc.', 2, 0, 0, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (91, N'WESTAMER0001', N'WestAmerica Bicycle Co.', 1, 0, 1, NULL, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (92, N'AMERICAN0002', N'American Bikes', 1, 1, 1, NULL, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (93, N'CHICAGO0002', N'Chicago Rent-All', 2, 1, 1, NULL, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (94, N'SUPERIOR0001', N'Superior Bicycles', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (95, N'TEAMATH0001', N'Team Athletic Co.', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (96, N'HILLBIC0001', N'Hill Bicycle Center', 1, 1, 1, NULL, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (97, N'NORTHW0001', N'Northwind Traders', 1, 1, 1, N'www.northwindtraders.com/', CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (98, N'TRIKES0001', N'Trikes, Inc.', 2, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (99, N'MARSH0001', N'Marsh', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (100, N'HOLIDAY0001', N'Holiday Skate & Cycle', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
GO
print 'Processed 100 total records'
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (101, N'TOURING0001', N'Touring Equipment Center', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (102, N'FITNESS0001', N'Fitness Association', 1, 1, 1, NULL, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (103, N'MORGANB0001', N'Morgan Bike Accessories', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[Vendor] ([VendorID], [AccountNumber], [Name], [CreditRating], [PreferredVendorStatus], [ActiveFlag], [PurchasingWebServiceURL], [ModifiedDate]) VALUES (104, N'PROFESSI0001', N'Professional Athletic Consultants', 1, 1, 1, NULL, CAST(0x000091C600000000 AS DateTime))
SET IDENTITY_INSERT [Purchasing].[Vendor] OFF
/****** Object:  StoredProcedure [dbo].[uspGetManagerEmployees]    Script Date: 05/31/2009 11:54:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uspGetManagerEmployees]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[uspGetManagerEmployees]
    @ManagerID [int]
AS
BEGIN
    SET NOCOUNT ON;

    -- Use recursive query to list out all Employees required for a particular Manager
    WITH [EMP_cte]([EmployeeID], [ManagerID], [FirstName], [LastName], [RecursionLevel]) -- CTE name and columns
    AS (
        SELECT e.[EmployeeID], e.[ManagerID], c.[FirstName], c.[LastName], 0 -- Get the initial list of Employees for Manager n
        FROM [HumanResources].[Employee] e 
            INNER JOIN [Person].[Contact] c 
            ON e.[ContactID] = c.[ContactID]
        WHERE [ManagerID] = @ManagerID
        UNION ALL
        SELECT e.[EmployeeID], e.[ManagerID], c.[FirstName], c.[LastName], [RecursionLevel] + 1 -- Join recursive member to anchor
        FROM [HumanResources].[Employee] e 
            INNER JOIN [EMP_cte]
            ON e.[ManagerID] = [EMP_cte].[EmployeeID]
            INNER JOIN [Person].[Contact] c 
            ON e.[ContactID] = c.[ContactID]
        )
    -- Join back to Employee to return the manager name 
    SELECT [EMP_cte].[RecursionLevel], [EMP_cte].[ManagerID], c.[FirstName] AS ''ManagerFirstName'', c.[LastName] AS ''ManagerLastName'',
        [EMP_cte].[EmployeeID], [EMP_cte].[FirstName], [EMP_cte].[LastName] -- Outer select from the CTE
    FROM [EMP_cte] 
        INNER JOIN [HumanResources].[Employee] e 
        ON [EMP_cte].[ManagerID] = e.[EmployeeID]
        INNER JOIN [Person].[Contact] c 
        ON e.[ContactID] = c.[ContactID]
    ORDER BY [RecursionLevel], [ManagerID], [EmployeeID]
    OPTION (MAXRECURSION 25) 
END;
' 
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'PROCEDURE',N'uspGetManagerEmployees', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'uspGetManagerEmployees'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'PROCEDURE',N'uspGetManagerEmployees', N'PARAMETER',N'@ManagerID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Input parameter for the stored procedure uspGetManagerEmployees. Enter a valid ManagerID from the HumanResources.Employee table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'uspGetManagerEmployees', @level2type=N'PARAMETER',@level2name=N'@ManagerID'
GO
/****** Object:  Table [Purchasing].[VendorAddress]    Script Date: 05/31/2009 11:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]') AND type in (N'U'))
BEGIN
CREATE TABLE [Purchasing].[VendorAddress](
	[VendorID] [int] NOT NULL,
	[AddressID] [int] NOT NULL,
	[AddressTypeID] [int] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_VendorAddress_VendorID_AddressID] PRIMARY KEY CLUSTERED 
(
	[VendorID] ASC,
	[AddressID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'COLUMN',N'VendorID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to Vendor.VendorID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'COLUMN',@level2name=N'VendorID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'COLUMN',N'AddressID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to Address.AddressID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'COLUMN',@level2name=N'AddressID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'COLUMN',N'AddressTypeID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Address type. Foreign key to AddressType.AddressTypeID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'COLUMN',@level2name=N'AddressTypeID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'COLUMN',N'ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference mapping vendors and addresses.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'CONSTRAINT',N'PK_VendorAddress_VendorID_AddressID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key (clustered) constraint' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'CONSTRAINT',@level2name=N'PK_VendorAddress_VendorID_AddressID'
GO
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (1, 357, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (2, 335, 3, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (3, 381, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (4, 323, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (5, 373, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (6, 344, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (7, 377, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (8, 328, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (9, 346, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (10, 363, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (11, 306, 3, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (12, 325, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (13, 310, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (14, 368, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (15, 393, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (16, 352, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (17, 324, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (18, 341, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (19, 332, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (20, 362, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (21, 316, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (22, 399, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (23, 379, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (24, 339, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (25, 384, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (26, 338, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (27, 317, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (28, 333, 3, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (29, 356, 3, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (30, 327, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (31, 337, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (32, 302, 3, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (33, 387, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (34, 353, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (35, 375, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (36, 385, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (37, 355, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (38, 303, 3, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (39, 348, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (40, 402, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (41, 388, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (42, 367, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (43, 354, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (44, 326, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (45, 320, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (46, 315, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (47, 313, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (48, 342, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (49, 370, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (50, 400, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (51, 311, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (52, 350, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (53, 361, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (54, 382, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (55, 389, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (56, 358, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (57, 404, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (58, 374, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (59, 334, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (60, 359, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (61, 369, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (62, 396, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (63, 372, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (64, 322, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (65, 360, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (66, 365, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (67, 364, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (68, 366, 3, CAST(0x000091C200000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (69, 378, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (70, 390, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (71, 401, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (72, 398, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (73, 329, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (74, 309, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (75, 380, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (76, 330, 3, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (77, 331, 3, CAST(0x000091B600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (78, 308, 3, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (79, 343, 3, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (80, 312, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (81, 314, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (82, 351, 3, CAST(0x0000919D00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (83, 301, 3, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (84, 307, 3, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (85, 304, 3, CAST(0x000090AB00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (86, 318, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (87, 336, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (88, 345, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (89, 391, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (90, 386, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (91, 403, 3, CAST(0x000091D600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (92, 305, 3, CAST(0x000090B900000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (93, 321, 3, CAST(0x0000919E00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (94, 392, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (95, 394, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (96, 347, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (97, 319, 3, CAST(0x000091BE00000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (98, 397, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (99, 371, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (100, 349, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (101, 395, 3, CAST(0x000091C700000000 AS DateTime))
GO
print 'Processed 100 total records'
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (102, 340, 3, CAST(0x000091C700000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (103, 376, 3, CAST(0x000091C600000000 AS DateTime))
INSERT [Purchasing].[VendorAddress] ([VendorID], [AddressID], [AddressTypeID], [ModifiedDate]) VALUES (104, 383, 3, CAST(0x000091C600000000 AS DateTime))
/****** Object:  View [Purchasing].[vVendor]    Script Date: 05/31/2009 11:54:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Purchasing].[vVendor]'))
EXEC dbo.sp_executesql @statement = N'
CREATE VIEW [Purchasing].[vVendor] AS 
SELECT 
    v.[VendorID]
    ,v.[Name]
    ,ct.[Name] AS [ContactType]
    ,c.[Title]
    ,c.[FirstName]
    ,c.[MiddleName]
    ,c.[LastName]
    ,c.[Suffix]
    ,c.[Phone]
    ,c.[EmailAddress]
    ,c.[EmailPromotion]
    ,a.[AddressLine1]
    ,a.[AddressLine2]
    ,a.[City]
    ,[StateProvinceName] = sp.[Name]
    ,a.[PostalCode]
    ,[CountryRegionName] = cr.[Name]
FROM [Purchasing].[Vendor] v
    INNER JOIN [Purchasing].[VendorContact] vc 
    ON vc.[VendorID] = v.[VendorID]
    INNER JOIN [Person].[Contact] c 
    ON c.[ContactID] = vc.[ContactID]
    INNER JOIN [Person].[ContactType] ct 
    ON vc.[ContactTypeID] = ct.[ContactTypeID]
    INNER JOIN [Purchasing].[VendorAddress] va 
    ON va.[VendorID] = v.[VendorID]
    INNER JOIN [Person].[Address] a 
    ON a.[AddressID] = va.[AddressID]
    INNER JOIN [Person].[StateProvince] sp 
    ON sp.[StateProvinceID] = a.[StateProvinceID]
    INNER JOIN [Person].[CountryRegion] cr 
    ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'VIEW',N'vVendor', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Vendor (company) names and addresses and the names of vendor employees to contact.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'VIEW',@level1name=N'vVendor'
GO
/****** Object:  View [Sales].[vSalesPerson]    Script Date: 05/31/2009 11:54:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Sales].[vSalesPerson]'))
EXEC dbo.sp_executesql @statement = N'
CREATE VIEW [Sales].[vSalesPerson] 
AS 
SELECT 
    s.[SalesPersonID]
    ,c.[Title]
    ,c.[FirstName]
    ,c.[MiddleName]
    ,c.[LastName]
    ,c.[Suffix]
    ,[JobTitle] = e.[Title]
    ,c.[Phone]
    ,c.[EmailAddress]
    ,c.[EmailPromotion]
    ,a.[AddressLine1]
    ,a.[AddressLine2]
    ,a.[City]
    ,[StateProvinceName] = sp.[Name]
    ,a.[PostalCode]
    ,[CountryRegionName] = cr.[Name]
    ,[TerritoryName] = st.[Name]
    ,[TerritoryGroup] = st.[Group]
    ,s.[SalesQuota]
    ,s.[SalesYTD]
    ,s.[SalesLastYear]
FROM [Sales].[SalesPerson] s
    INNER JOIN [HumanResources].[Employee] e 
    ON e.[EmployeeID] = s.[SalesPersonID]
    LEFT OUTER JOIN [Sales].[SalesTerritory] st 
    ON st.[TerritoryID] = s.[TerritoryID]
    INNER JOIN [Person].[Contact] c 
    ON c.[ContactID] = e.[ContactID]
    INNER JOIN [HumanResources].[EmployeeAddress] ea 
    ON e.[EmployeeID] = ea.[EmployeeID] 
    INNER JOIN [Person].[Address] a 
    ON ea.[AddressID] = a.[AddressID]
    INNER JOIN [Person].[StateProvince] sp 
    ON sp.[StateProvinceID] = a.[StateProvinceID]
    INNER JOIN [Person].[CountryRegion] cr 
    ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Sales', N'VIEW',N'vSalesPerson', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales representiatives (names and addresses) and their sales-related information.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'VIEW',@level1name=N'vSalesPerson'
GO
/****** Object:  UserDefinedFunction [dbo].[ufnGetProductListPrice]    Script Date: 05/31/2009 11:54:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ufnGetProductListPrice]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
BEGIN
execute dbo.sp_executesql @statement = N'
CREATE FUNCTION [dbo].[ufnGetProductListPrice](@ProductID [int], @OrderDate [datetime])
RETURNS [money] 
AS 
BEGIN
    DECLARE @ListPrice money;

    SELECT @ListPrice = plph.[ListPrice] 
    FROM [Production].[Product] p 
        INNER JOIN [Production].[ProductListPriceHistory] plph 
        ON p.[ProductID] = plph.[ProductID] 
            AND p.[ProductID] = @ProductID 
            AND @OrderDate BETWEEN plph.[StartDate] AND COALESCE(plph.[EndDate], CONVERT(datetime, ''99991231'', 112)); -- Make sure we get all the prices!

    RETURN @ListPrice;
END;
' 
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'FUNCTION',N'ufnGetProductListPrice', N'PARAMETER',N'@ProductID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Input parameter for the scalar function ufnGetProductListPrice. Enter a valid ProductID from the Production.Product table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'ufnGetProductListPrice', @level2type=N'PARAMETER',@level2name=N'@ProductID'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'FUNCTION',N'ufnGetProductListPrice', N'PARAMETER',N'@OrderDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Input parameter for the scalar function ufnGetProductListPrice. Enter a valid order date.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'ufnGetProductListPrice', @level2type=N'PARAMETER',@level2name=N'@OrderDate'
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'dbo', N'FUNCTION',N'ufnGetProductListPrice', NULL,NULL))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Scalar function returning the list price for a given product on a particular order date.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'ufnGetProductListPrice'
GO
/****** Object:  Default [DF_ShipMethod_ShipBase]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_ShipMethod_ShipBase]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShipMethod_ShipBase]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[ShipMethod] ADD  CONSTRAINT [DF_ShipMethod_ShipBase]  DEFAULT ((0.00)) FOR [ShipBase]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'DF_ShipMethod_ShipBase'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 0.0' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'DF_ShipMethod_ShipBase'

End
GO
/****** Object:  Default [DF_ShipMethod_ShipRate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_ShipMethod_ShipRate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShipMethod_ShipRate]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[ShipMethod] ADD  CONSTRAINT [DF_ShipMethod_ShipRate]  DEFAULT ((0.00)) FOR [ShipRate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'DF_ShipMethod_ShipRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 0.0' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'DF_ShipMethod_ShipRate'

End
GO
/****** Object:  Default [DF_ShipMethod_rowguid]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_ShipMethod_rowguid]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShipMethod_rowguid]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[ShipMethod] ADD  CONSTRAINT [DF_ShipMethod_rowguid]  DEFAULT (newid()) FOR [rowguid]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'DF_ShipMethod_rowguid'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of NEWID()' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'DF_ShipMethod_rowguid'

End
GO
/****** Object:  Default [DF_ShipMethod_ModifiedDate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_ShipMethod_ModifiedDate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShipMethod_ModifiedDate]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[ShipMethod] ADD  CONSTRAINT [DF_ShipMethod_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'DF_ShipMethod_ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of GETDATE()' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'DF_ShipMethod_ModifiedDate'

End
GO
/****** Object:  Default [DF_Vendor_PreferredVendorStatus]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_Vendor_PreferredVendorStatus]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[Vendor]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Vendor_PreferredVendorStatus]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[Vendor] ADD  CONSTRAINT [DF_Vendor_PreferredVendorStatus]  DEFAULT ((1)) FOR [PreferredVendorStatus]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'CONSTRAINT',N'DF_Vendor_PreferredVendorStatus'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 1 (TRUE)' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'CONSTRAINT',@level2name=N'DF_Vendor_PreferredVendorStatus'

End
GO
/****** Object:  Default [DF_Vendor_ActiveFlag]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_Vendor_ActiveFlag]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[Vendor]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Vendor_ActiveFlag]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[Vendor] ADD  CONSTRAINT [DF_Vendor_ActiveFlag]  DEFAULT ((1)) FOR [ActiveFlag]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'CONSTRAINT',N'DF_Vendor_ActiveFlag'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 1 (TRUE)' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'CONSTRAINT',@level2name=N'DF_Vendor_ActiveFlag'

End
GO
/****** Object:  Default [DF_Vendor_ModifiedDate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_Vendor_ModifiedDate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[Vendor]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Vendor_ModifiedDate]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[Vendor] ADD  CONSTRAINT [DF_Vendor_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'CONSTRAINT',N'DF_Vendor_ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of GETDATE()' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'CONSTRAINT',@level2name=N'DF_Vendor_ModifiedDate'

End
GO
/****** Object:  Default [DF_VendorAddress_ModifiedDate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[DF_VendorAddress_ModifiedDate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_VendorAddress_ModifiedDate]') AND type = 'D')
BEGIN
ALTER TABLE [Purchasing].[VendorAddress] ADD  CONSTRAINT [DF_VendorAddress_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'CONSTRAINT',N'DF_VendorAddress_ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of GETDATE()' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'CONSTRAINT',@level2name=N'DF_VendorAddress_ModifiedDate'

End
GO
/****** Object:  Default [DF_Location_CostRate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Production].[DF_Location_CostRate]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Location_CostRate]') AND type = 'D')
BEGIN
ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_CostRate]  DEFAULT ((0.00)) FOR [CostRate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'DF_Location_CostRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 0.0' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'DF_Location_CostRate'

End
GO
/****** Object:  Default [DF_Location_Availability]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Production].[DF_Location_Availability]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Location_Availability]') AND type = 'D')
BEGIN
ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_Availability]  DEFAULT ((0.00)) FOR [Availability]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'DF_Location_Availability'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of 0.00' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'DF_Location_Availability'

End
GO
/****** Object:  Default [DF_Location_ModifiedDate]    Script Date: 05/31/2009 11:54:57 ******/
IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[Production].[DF_Location_ModifiedDate]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
Begin
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Location_ModifiedDate]') AND type = 'D')
BEGIN
ALTER TABLE [Production].[Location] ADD  CONSTRAINT [DF_Location_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
END

IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'DF_Location_ModifiedDate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Default constraint value of GETDATE()' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'DF_Location_ModifiedDate'

End
GO
/****** Object:  Check [CK_ShipMethod_ShipBase]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_ShipMethod_ShipBase]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
ALTER TABLE [Purchasing].[ShipMethod]  WITH CHECK ADD  CONSTRAINT [CK_ShipMethod_ShipBase] CHECK  (([ShipBase]>(0.00)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_ShipMethod_ShipBase]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
ALTER TABLE [Purchasing].[ShipMethod] CHECK CONSTRAINT [CK_ShipMethod_ShipBase]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'CK_ShipMethod_ShipBase'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check constraint [ShipBase] > (0.00)' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'CK_ShipMethod_ShipBase'
GO
/****** Object:  Check [CK_ShipMethod_ShipRate]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_ShipMethod_ShipRate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
ALTER TABLE [Purchasing].[ShipMethod]  WITH CHECK ADD  CONSTRAINT [CK_ShipMethod_ShipRate] CHECK  (([ShipRate]>(0.00)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_ShipMethod_ShipRate]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[ShipMethod]'))
ALTER TABLE [Purchasing].[ShipMethod] CHECK CONSTRAINT [CK_ShipMethod_ShipRate]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'ShipMethod', N'CONSTRAINT',N'CK_ShipMethod_ShipRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check constraint [ShipRate] > (0.00)' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'ShipMethod', @level2type=N'CONSTRAINT',@level2name=N'CK_ShipMethod_ShipRate'
GO
/****** Object:  Check [CK_Vendor_CreditRating]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_Vendor_CreditRating]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[Vendor]'))
ALTER TABLE [Purchasing].[Vendor]  WITH CHECK ADD  CONSTRAINT [CK_Vendor_CreditRating] CHECK  (([CreditRating]>=(1) AND [CreditRating]<=(5)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Purchasing].[CK_Vendor_CreditRating]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[Vendor]'))
ALTER TABLE [Purchasing].[Vendor] CHECK CONSTRAINT [CK_Vendor_CreditRating]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'Vendor', N'CONSTRAINT',N'CK_Vendor_CreditRating'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check constraint [CreditRating] BETWEEN (1) AND (5)' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'Vendor', @level2type=N'CONSTRAINT',@level2name=N'CK_Vendor_CreditRating'
GO
/****** Object:  Check [CK_Location_Availability]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Production].[CK_Location_Availability]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
ALTER TABLE [Production].[Location]  WITH CHECK ADD  CONSTRAINT [CK_Location_Availability] CHECK  (([Availability]>=(0.00)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Production].[CK_Location_Availability]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
ALTER TABLE [Production].[Location] CHECK CONSTRAINT [CK_Location_Availability]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'CK_Location_Availability'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check constraint [Availability] >= (0.00)' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'CK_Location_Availability'
GO
/****** Object:  Check [CK_Location_CostRate]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Production].[CK_Location_CostRate]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
ALTER TABLE [Production].[Location]  WITH CHECK ADD  CONSTRAINT [CK_Location_CostRate] CHECK  (([CostRate]>=(0.00)))
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[Production].[CK_Location_CostRate]') AND parent_object_id = OBJECT_ID(N'[Production].[Location]'))
ALTER TABLE [Production].[Location] CHECK CONSTRAINT [CK_Location_CostRate]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Production', N'TABLE',N'Location', N'CONSTRAINT',N'CK_Location_CostRate'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Check constraint [CostRate] >= (0.00)' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Location', @level2type=N'CONSTRAINT',@level2name=N'CK_Location_CostRate'
GO
/****** Object:  ForeignKey [FK_VendorAddress_Address_AddressID]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_Address_AddressID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress]  WITH CHECK ADD  CONSTRAINT [FK_VendorAddress_Address_AddressID] FOREIGN KEY([AddressID])
REFERENCES [Person].[Address] ([AddressID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_Address_AddressID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress] CHECK CONSTRAINT [FK_VendorAddress_Address_AddressID]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'CONSTRAINT',N'FK_VendorAddress_Address_AddressID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Foreign key constraint referencing Address.AddressID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'CONSTRAINT',@level2name=N'FK_VendorAddress_Address_AddressID'
GO
/****** Object:  ForeignKey [FK_VendorAddress_AddressType_AddressTypeID]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_AddressType_AddressTypeID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress]  WITH CHECK ADD  CONSTRAINT [FK_VendorAddress_AddressType_AddressTypeID] FOREIGN KEY([AddressTypeID])
REFERENCES [Person].[AddressType] ([AddressTypeID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_AddressType_AddressTypeID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress] CHECK CONSTRAINT [FK_VendorAddress_AddressType_AddressTypeID]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'CONSTRAINT',N'FK_VendorAddress_AddressType_AddressTypeID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Foreign key constraint referencing AddressType.AddressTypeID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'CONSTRAINT',@level2name=N'FK_VendorAddress_AddressType_AddressTypeID'
GO
/****** Object:  ForeignKey [FK_VendorAddress_Vendor_VendorID]    Script Date: 05/31/2009 11:54:57 ******/
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_Vendor_VendorID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress]  WITH CHECK ADD  CONSTRAINT [FK_VendorAddress_Vendor_VendorID] FOREIGN KEY([VendorID])
REFERENCES [Purchasing].[Vendor] ([VendorID])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[Purchasing].[FK_VendorAddress_Vendor_VendorID]') AND parent_object_id = OBJECT_ID(N'[Purchasing].[VendorAddress]'))
ALTER TABLE [Purchasing].[VendorAddress] CHECK CONSTRAINT [FK_VendorAddress_Vendor_VendorID]
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'SCHEMA',N'Purchasing', N'TABLE',N'VendorAddress', N'CONSTRAINT',N'FK_VendorAddress_Vendor_VendorID'))
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Foreign key constraint referencing Vendor.VendorID.' , @level0type=N'SCHEMA',@level0name=N'Purchasing', @level1type=N'TABLE',@level1name=N'VendorAddress', @level2type=N'CONSTRAINT',@level2name=N'FK_VendorAddress_Vendor_VendorID'
GO