home *** CD-ROM | disk | FTP | other *** search
/ DOS/V Power Report 1997 March / VPR9703A.ISO / MS_DEV / VID / SERVER / ASF / DATA.Z / ADVWORKS.SQL < prev    next >
Text File  |  1996-10-22  |  32KB  |  522 lines
  1. /****** Object:  Stored Procedure advworks.InsertOrder    Script Date: 9/27/96 1:37:05 PM ******/
  2. if exists (select * from sysobjects where id = object_id('advworks.InsertOrder') and sysstat & 0xf = 4)
  3.     drop procedure advworks.InsertOrder
  4. GO
  5.  
  6. /****** Object:  Stored Procedure advworks.SalesByCustomer    Script Date: 9/27/96 1:37:05 PM ******/
  7. if exists (select * from sysobjects where id = object_id('advworks.SalesByCustomer') and sysstat & 0xf = 4)
  8.     drop procedure advworks.SalesByCustomer
  9. GO
  10.  
  11. /****** Object:  Stored Procedure advworks.SalesByEmployee    Script Date: 9/27/96 1:37:05 PM ******/
  12. if exists (select * from sysobjects where id = object_id('advworks.SalesByEmployee') and sysstat & 0xf = 4)
  13.     drop procedure advworks.SalesByEmployee
  14. GO
  15.  
  16. /****** Object:  Stored Procedure advworks.SalesByProduct    Script Date: 9/27/96 1:37:05 PM ******/
  17. if exists (select * from sysobjects where id = object_id('advworks.SalesByProduct') and sysstat & 0xf = 4)
  18.     drop procedure advworks.SalesByProduct
  19. GO
  20.  
  21. if exists (select * from sysobjects where id = object_id('advworks.CampingTopSales') and sysstat & 0xf = 4)
  22.     drop procedure advworks.CampingTopSales
  23. GO
  24.  
  25. if exists (select * from sysobjects where id = object_id('advworks.ClimbingTopSales') and sysstat & 0xf = 4)
  26.     drop procedure advworks.ClimbingTopSales
  27. GO
  28.  
  29. if exists (select * from sysobjects where id = object_id('advworks.ClothingTopSales') and sysstat & 0xf = 4)
  30.     drop procedure advworks.ClothingTopSales
  31. GO
  32.  
  33. /****** Object:  Table advworks.Customers    Script Date: 9/27/96 1:37:05 PM ******/
  34. if exists (select * from sysobjects where id = object_id('advworks.Customers') and sysstat & 0xf = 3)
  35.     drop table advworks.Customers
  36. GO
  37.  
  38. /****** Object:  Table advworks.Employees    Script Date: 9/27/96 1:37:05 PM ******/
  39. if exists (select * from sysobjects where id = object_id('advworks.Employees') and sysstat & 0xf = 3)
  40.     drop table advworks.Employees
  41. GO
  42.  
  43. /****** Object:  Table advworks.Order_Details    Script Date: 9/27/96 1:37:05 PM ******/
  44. if exists (select * from sysobjects where id = object_id('advworks.Order_Details') and sysstat & 0xf = 3)
  45.     drop table advworks.Order_Details
  46. GO
  47.  
  48. /****** Object:  Table advworks.Orders    Script Date: 9/27/96 1:37:05 PM ******/
  49. if exists (select * from sysobjects where id = object_id('advworks.Orders') and sysstat & 0xf = 3)
  50.     drop table advworks.Orders
  51. GO
  52.  
  53. /****** Object:  Table advworks.Payment_Methods    Script Date: 9/27/96 1:37:05 PM ******/
  54. if exists (select * from sysobjects where id = object_id('advworks.Payment_Methods') and sysstat & 0xf = 3)
  55.     drop table advworks.Payment_Methods
  56. GO
  57.  
  58. /****** Object:  Table advworks.Payments    Script Date: 9/27/96 1:37:05 PM ******/
  59. if exists (select * from sysobjects where id = object_id('advworks.Payments') and sysstat & 0xf = 3)
  60.     drop table advworks.Payments
  61. GO
  62.  
  63. /****** Object:  Table advworks.Products    Script Date: 9/27/96 1:37:05 PM ******/
  64. if exists (select * from sysobjects where id = object_id('advworks.Products') and sysstat & 0xf = 3)
  65.     drop table advworks.Products
  66. GO
  67.  
  68. /****** Object:  Table advworks.Shipping_Methods    Script Date: 9/27/96 1:37:05 PM ******/
  69. if exists (select * from sysobjects where id = object_id('advworks.Shipping_Methods') and sysstat & 0xf = 3)
  70.     drop table advworks.Shipping_Methods
  71. GO
  72.  
  73.  
  74. /****** Object:  Table AdvWorks.Customers    Script Date: 9/27/96 1:37:05 PM ******/
  75. CREATE TABLE AdvWorks.Customers (
  76.     CustomerID int IDENTITY (1, 1) NOT NULL ,
  77.     CompanyName varchar (50) NULL ,
  78.     ContactFirstName varchar (30) NULL ,
  79.     ContactLastName varchar (50) NULL ,
  80.     BillingAddress varchar (255) NULL ,
  81.     City varchar (50) NULL ,
  82.     StateOrProvince varchar (20) NULL ,
  83.     PostalCode varchar (20) NULL ,
  84.     Country varchar (50) NULL ,
  85.     ContactTitle varchar (50) NULL ,
  86.     PhoneNumber varchar (30) NULL ,
  87.     FaxNumber varchar (30) NULL ,
  88.     EmailAddress varchar (50) NULL ,
  89.     Notes text NULL ,
  90.     LevelOfExperience varchar (15) NULL ,
  91.     CONSTRAINT aaaaaCustomers_PK PRIMARY KEY  NONCLUSTERED 
  92.     (
  93.         CustomerID
  94.     )
  95. )
  96. GO
  97.  
  98. /****** Object:  Table AdvWorks.Employees    Script Date: 9/27/96 1:37:06 PM ******/
  99. CREATE TABLE AdvWorks.Employees (
  100.     EmployeeID int IDENTITY (1, 1) NOT NULL ,
  101.     FirstName varchar (50) NULL ,
  102.     LastName varchar (50) NULL ,
  103.     Title varchar (50) NULL ,
  104.     Extension varchar (30) NULL ,
  105.     WorkPhone varchar (30) NULL ,
  106.     CONSTRAINT aaaaaEmployees_PK PRIMARY KEY  NONCLUSTERED 
  107.     (
  108.         EmployeeID
  109.     )
  110. )
  111. GO
  112.  
  113. /****** Object:  Table AdvWorks.Order_Details    Script Date: 9/27/96 1:37:06 PM ******/
  114. CREATE TABLE AdvWorks.Order_Details (
  115.     OrderDetailID int IDENTITY (1, 1) NOT NULL ,
  116.     OrderID int NULL ,
  117.     ProductID int NULL ,
  118.     Quantity float NULL ,
  119.     Color varchar (50) NULL ,
  120.     Size varchar (50) NULL ,
  121.     UnitPrice money NULL ,
  122.     Discount float NULL ,
  123.     CONSTRAINT aaaaaOrder_Details_PK PRIMARY KEY  NONCLUSTERED 
  124.     (
  125.         OrderDetailID
  126.     )
  127. )
  128. GO
  129.  
  130. /****** Object:  Table AdvWorks.Orders    Script Date: 9/27/96 1:37:06 PM ******/
  131. CREATE TABLE AdvWorks.Orders (
  132.     OrderID int IDENTITY (1, 1) NOT NULL ,
  133.     CustomerID int NULL ,
  134.     EmployeeID int NULL ,
  135.     OrderDate datetime NULL ,
  136.     PurchaseOrderNumber varchar (30) NULL ,
  137.     ShipContactFirstName varchar (50) NULL ,
  138.     ShipContactLastName varchar (50) NULL ,
  139.     ShipName varchar (50) NULL ,
  140.     ShipAddress varchar (255) NULL ,
  141.     ShipCity varchar (50) NULL ,
  142.     ShipStateOrProvince varchar (50) NULL ,
  143.     ShipPostalCode varchar (20) NULL ,
  144.     ShipCountry varchar (50) NULL ,
  145.     ShipPhoneNumber varchar (30) NULL ,
  146.     ShipDate datetime NULL ,
  147.     ShippingMethodID int NULL ,
  148.     FreightCharge money NULL ,
  149.     SalesTaxRate float NULL ,
  150.     CONSTRAINT aaaaaOrders_PK PRIMARY KEY  NONCLUSTERED 
  151.     (
  152.         OrderID
  153.     )
  154. )
  155. GO
  156.  
  157. /****** Object:  Table AdvWorks.Payment_Methods    Script Date: 9/27/96 1:37:06 PM ******/
  158. CREATE TABLE AdvWorks.Payment_Methods (
  159.     PaymentMethodID int IDENTITY (1, 1) NOT NULL ,
  160.     PaymentMethod varchar (50) NULL ,
  161.     CreditCard int NULL ,
  162.     CONSTRAINT aaaaaPayment_Methods_PK PRIMARY KEY  NONCLUSTERED 
  163.     (
  164.         PaymentMethodID
  165.     )
  166. )
  167. GO
  168.  
  169. /****** Object:  Table AdvWorks.Payments    Script Date: 9/27/96 1:37:06 PM ******/
  170. CREATE TABLE AdvWorks.Payments (
  171.     PaymentID int IDENTITY (1, 1) NOT NULL ,
  172.     OrderID int NULL ,
  173.     PaymentAmount money NULL ,
  174.     PaymentDate datetime NULL ,
  175.     CreditCardNumber varchar (30) NULL ,
  176.     CardholdersName varchar (50) NULL ,
  177.     CreditCardExpDate datetime NULL ,
  178.     CreditCardAuthorizationNumber varchar (30) NULL ,
  179.     PaymentMethodID int NULL ,
  180.     CONSTRAINT aaaaaPayments_PK PRIMARY KEY  NONCLUSTERED 
  181.     (
  182.         PaymentID
  183.     )
  184. )
  185. GO
  186.  
  187. /****** Object:  Table AdvWorks.Products    Script Date: 9/27/96 1:37:07 PM ******/
  188. CREATE TABLE AdvWorks.Products (
  189.     ProductID int IDENTITY (1, 1) NOT NULL ,
  190.     ProductCode varchar (10) NULL ,
  191.     ProductType varchar (20) NULL ,
  192.     ProductIntroductionDate datetime NULL ,
  193.     ProductName varchar (50) NULL ,
  194.     ProductDescription varchar (255) NULL ,
  195.     ProductSize varchar (5) NULL ,
  196.     ProductImageURL varchar (255) NULL ,
  197.     UnitPrice float NULL ,
  198.     OnSale int NULL ,
  199.     CONSTRAINT aaaaaProducts_PK PRIMARY KEY  NONCLUSTERED 
  200.     (
  201.         ProductID
  202.     )
  203. )
  204. GO
  205.  
  206.  
  207.  
  208. /****** Object:  Table AdvWorks.Shipping_Methods    Script Date: 9/27/96 1:37:07 PM ******/
  209. CREATE TABLE AdvWorks.Shipping_Methods (
  210.     ShippingMethodID int IDENTITY (1, 1) NOT NULL ,
  211.     ShippingMethod varchar (20) NULL ,
  212.     CONSTRAINT aaaaaShipping_Methods_PK PRIMARY KEY  NONCLUSTERED 
  213.     (
  214.         ShippingMethodID
  215.     )
  216. )
  217. GO
  218.  
  219.  
  220. /****** Object:  Stored Procedure advworks.InsertOrder    Script Date: 9/27/96 1:37:08 PM ******/
  221. create proc InsertOrder( 
  222. @CustomerID int, 
  223. @EmployeeID int, 
  224. @ShipName varchar,  
  225. @ShipContactFirstName varchar, 
  226. @ShipContactLastName varchar, 
  227. @ShipAddress varchar, 
  228. @ShipCity varchar,  
  229. @ShipStateOrProvince varchar, 
  230. @ShipPostalCode varchar, 
  231. @ShipCountry varchar, 
  232. @ShipPhoneNumber varchar,  
  233. @ShippingMethodID int, 
  234. @FreightCharge money, 
  235. @SalesTaxRate float, 
  236. @OrderID int output )  
  237. as 
  238. INSERT INTO Orders( 
  239. CustomerID, 
  240. EmployeeID, 
  241. OrderDate, 
  242. ShipName,  
  243. ShipContactFirstName, 
  244. ShipContactLastName, 
  245. ShipAddress, 
  246. ShipCity,  
  247. ShipStateOrProvince, 
  248. ShipPostalCode, 
  249. ShipCountry, 
  250. ShipPhoneNumber, 
  251. ShipDate, 
  252. ShippingMethodID, 
  253. FreightCharge, 
  254. SalesTaxRate)
  255. VALUES(
  256. @CustomerID, 
  257. 6, 
  258. getdate(),    
  259. @ShipName, 
  260. @ShipContactFirstName, 
  261. @ShipContactLastName,    
  262. @ShipAddress,    
  263. @ShipCity, 
  264. @ShipStateOrProvince,    
  265. @ShipPostalCode,  
  266. @ShipCountry,   
  267. @ShipPhoneNumber, 
  268. getdate(), 
  269. @ShippingMethodID, 
  270. @FreightCharge, 
  271. @SalesTaxRate  ) 
  272.  
  273. select @OrderID=@@identity  
  274.  
  275. GO
  276.  
  277. /****** Object:  Stored Procedure advworks.SalesByCustomer    Script Date: 9/27/96 1:37:08 PM ******/
  278. create proc SalesByCustomer as 
  279. SELECT 
  280.     Customers.CompanyName,
  281.     Customers.ContactLastName,
  282.     Customers.ContactFirstName,
  283.     Customers.City,
  284.     Customers.StateOrProvince,
  285.     Sum(Order_Details.Quantity) as 'Total Units',
  286.     Sum(Order_Details.UnitPrice*Order_Details.Quantity) as 'Total Sales'
  287. FROM
  288.      Customers Customers,
  289.     Order_Details Order_Details,
  290.     Orders Orders
  291.  
  292. WHERE     
  293.     Orders.CustomerID = Customers.CustomerID AND 
  294.     Order_Details.OrderID = Orders.OrderID
  295. GROUP BY 
  296.     Customers.CompanyName,
  297.     Customers.ContactLastName,
  298.     Customers.ContactFirstName,
  299.     Customers.City,
  300.     Customers.StateOrProvince
  301. GO
  302.  
  303.  
  304. /****** Object:  Stored Procedure advworks.SalesByEmployee    Script Date: 9/27/96 1:37:08 PM ******/
  305.  
  306. create proc SalesByEmployee as 
  307. SELECT Employees.LastName,
  308.     Employees.FirstName,
  309.     Sum(Order_Details.Quantity) as 'Total Units',
  310.     Sum(Order_Details.UnitPrice*Quantity) as 'Total Sales'
  311. FROM Employees Employees,
  312.     Order_Details Order_Details,
  313.     Orders Orders
  314. WHERE Orders.EmployeeID = Employees.EmployeeID AND Order_Details.OrderID = Orders.OrderID
  315. GROUP BY Employees.LastName,
  316.     Employees.FirstName
  317. GO
  318.  
  319.  
  320. /****** Object:  Stored Procedure advworks.SalesByProduct    Script Date: 9/27/96 1:37:08 PM ******/
  321.  
  322. create proc SalesByProduct as  SELECT Products.ProductName,
  323.     Sum(Order_Details.Quantity) as 'Total Units',
  324.     Sum(Order_Details.UnitPrice*Quantity) as 'Total Sales'
  325. FROM Order_Details Order_Details,
  326.     Products Products
  327. WHERE Products.ProductID = Order_Details.ProductID
  328. GROUP BY Products.ProductName
  329. GO
  330.  
  331.  
  332. /****** Object:  Stored Procedure advworks.CampingTopSales    Script Date: 9/27/96 1:37:08 PM ******/
  333.  
  334. Create proc CampingTopSales as
  335. SELECT 
  336.     Products.ProductType, 
  337.     Sum(Order_Details.Quantity) AS SumOfQuantity, 
  338.     Products.ProductCode, 
  339.     Products.ProductName, 
  340.     Products.ProductDescription, 
  341.     Products.ProductSize, 
  342.     Products.ProductImageURL, 
  343.     Products.UnitPrice, 
  344.     Products.OnSale, 
  345.     Products.ProductIntroductionDate
  346. FROM 
  347.     Products, Order_Details 
  348.  
  349. WHERE
  350.     Products.ProductID *= Order_Details.ProductID
  351.  
  352. GROUP BY 
  353.     Products.ProductType, 
  354.     Products.ProductCode, 
  355.     Products.ProductName, 
  356.     Products.ProductDescription, 
  357.     Products.ProductSize, 
  358.     Products.ProductImageURL, 
  359.     Products.UnitPrice, 
  360.     Products.OnSale, 
  361.     Products.ProductIntroductionDate
  362. HAVING 
  363.     Products.ProductType In ('Backpack','Sleeping Bag','Supplies','Tent')
  364. ORDER BY 
  365.     Products.ProductType, 
  366.     Sum(Order_Details.Quantity) DESC , 
  367.     Products.ProductCode
  368.  
  369. go
  370.  
  371. /****** Object:  Stored Procedure advworks.ClimbingTopSales    Script Date: 9/27/96 1:37:08 PM ******/
  372.  
  373. Create proc ClimbingTopSales as
  374. SELECT 
  375.     Products.ProductType, 
  376.     Sum(Order_Details.Quantity) AS SumOfQuantity, 
  377.     Products.ProductCode, 
  378.     Products.ProductName, 
  379.     Products.ProductDescription, 
  380.     Products.ProductSize, 
  381.     Products.ProductImageURL, 
  382.     Products.UnitPrice, 
  383.     Products.OnSale, 
  384.     Products.ProductIntroductionDate
  385. FROM 
  386.     Products, Order_Details 
  387.  
  388. WHERE
  389.     Products.ProductID *= Order_Details.ProductID
  390.  
  391. GROUP BY 
  392.     Products.ProductType, 
  393.     Products.ProductCode, 
  394.     Products.ProductName, 
  395.  
  396.     Products.ProductDescription, 
  397.     Products.ProductSize, 
  398.     Products.ProductImageURL, 
  399.     Products.UnitPrice, 
  400.     Products.OnSale, 
  401.     Products.ProductIntroductionDate
  402. HAVING 
  403.     Products.ProductType In ('Carabiner','Crampon','Harness','Rock Shoes')
  404. ORDER BY 
  405.     Products.ProductType, 
  406.     Sum(Order_Details.Quantity) DESC , 
  407.     Products.ProductCode
  408.  
  409. go
  410.  
  411. /****** Object:  Stored Procedure advworks.ClothingTopSales    Script Date: 9/27/96 1:37:08 PM ******/
  412.  
  413. Create proc ClothingTopSales as
  414. SELECT 
  415.     Products.ProductType, 
  416.     Sum(Order_Details.Quantity) AS SumOfQuantity, 
  417.     Products.ProductCode, 
  418.     Products.ProductName, 
  419.     Products.ProductDescription, 
  420.     Products.ProductSize, 
  421.     Products.ProductImageURL, 
  422.     Products.UnitPrice, 
  423.     Products.OnSale, 
  424.     Products.ProductIntroductionDate
  425. FROM 
  426.     Products, Order_Details 
  427.  
  428. WHERE
  429.     Products.ProductID *= Order_Details.ProductID
  430.  
  431. GROUP BY 
  432.     Products.ProductType, 
  433.     Products.ProductCode, 
  434.     Products.ProductName, 
  435.  
  436.     Products.ProductDescription, 
  437.     Products.ProductSize, 
  438.     Products.ProductImageURL, 
  439.     Products.UnitPrice, 
  440.     Products.OnSale, 
  441.     Products.ProductIntroductionDate
  442. HAVING 
  443.     Products.ProductType In ('Boot','Pants','Parka','Shirt')
  444. ORDER BY 
  445.     Products.ProductType, 
  446.     Sum(Order_Details.Quantity) DESC , 
  447.     Products.ProductCode
  448.  
  449. go
  450.  
  451.  
  452. /*   BEGIN DATA INSERTION */
  453. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW390-12','Sleeping Bag','1996-05-01 00:00:00.000','North Face Sunspot','windproof, water-resistant, even heat distribution, storage sack included, red (re)',NULL,'/advworks/Multimedia/Catalog/Camping/Dsleepingbags25.gif',390.0,0)
  454. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW310-12','Sleeping Bag','1996-01-16 00:00:00.000','Polar Star','ultralight goose-down insulated alpinist''s bag, contour closure with locking zipper, storage sack i',NULL,'/advworks/Multimedia/Catalog/Camping/Dsleepingbags26.gif',310.0,1)
  455. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW200-12','Sleeping Bag','1996-03-03 00:00:00.000','Big Sur','generously cut sleeping bag, goose down with polyester taffeta, cotton storage sack included, blue ',NULL,'/advworks/Multimedia/Catalog/Camping/Dsleepingbags28.gif',200.0,0)
  456. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW210-12','Sleeping Bag','1996-04-23 00:00:00.000','Day Hike','backpacking sleeping bag, goose down with nylon shell, locking zipper, storage sack included, choice of zipper location, blue (bl)',NULL,'/advworks/Multimedia/Catalog/Camping/Dsleepingbags27.gif',210.0,0)
  457. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW098-04','Boot','1996-05-20 00:00:00.000','Everglades','medium-weight, waterproof leather boots, good traction, brown (br)','4-12','/advworks/multimedia/catalog/clothing/dboots05.gif',98.0,0)
  458. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW078-04','Boot','1996-05-16 00:00:00.000','Rockies','lightweight Nubuck leather/nylon, water-resistant boots, polyurethane soles, green/gray (gg) or gre','4-12','/advworks/multimedia/catalog/clothing/dboots07.gif',78.0,0)
  459. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW087-04','Boot','1996-04-27 00:00:00.000','Sierras','Nubuck, water-resistant leather boots, rubber soles, dark brown (db)','4-12','/advworks/multimedia/catalog/clothing/dboots08.gif',87.0,1)
  460. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW074-04','Boot','1996-04-16 00:00:00.000','Dunes','lightweight nylon/suede hiking boots, light green (lg)','4-12','/advworks/multimedia/catalog/clothing/dboots06.gif',98.0,1)
  461. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW425-11','Tent','1996-05-28 00:00:00.000','Starlight','4-person dome tent, roomy, vaulted pole sleeves, black/gray (bg)',NULL,'/advworks/multimedia/catalog/camping/dtents17.gif',425.0,0)
  462. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW535-11','Tent','1996-05-29 00:00:00.000','Galaxy','durable 3-person all-purpose tent, maximum headroom, no-leak floor, beige/purple (bp)',NULL,'/advworks/multimedia/catalog/camping/dtents19.gif',535.0,0)
  463. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW335-11','Tent','1996-03-28 00:00:00.000','Aptos','lightweight 2-person backpacking tent, adjustable vents, canopy loops, green/black (gbk)',NULL,'/advworks/multimedia/catalog/camping/dtents18.gif',335.0,1)
  464. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW190-11','Tent','1996-05-20 00:00:00.000','Scirocco','warm-climate 2-person tent, compact, lightweight, bug protection, black/gray/purple (bgp)',NULL,'/advworks/multimedia/catalog/camping/dtents20.gif',190.0,1)
  465. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW188-06','Parka','1996-06-01 00:00:00.000','Alpine','durable, breathable, ripstop nylon parka, guaranteed to keep you dry, red (re), blue (bl), or black','S-XXL','/advworks/multimedia/catalog/clothing/dparkas01.gif',188.0,0)
  466. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW250-06','Parka','1996-03-23 00:00:00.000','Campos','reinforced, waterproof, 2-layer nylon parka, interior/exterior pockets, blue (bl)','S-XXL','/advworks/multimedia/catalog/clothing/dparkas02.gif',250.0,1)
  467. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW114-06','Parka','1996-05-03 00:00:00.000','Sahara','outer-shell drawstring parka with zippered pockets, green (gn) or blue (bl)','S-XXL','/advworks/multimedia/catalog/clothing/dparkas03.gif',114.0,1)
  468. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW125-06','Parka','1996-04-30 00:00:00.000','Crystal','lightweight, traditional parka with nylon lining, hooded, purple (pu) or blue (bl)','S-XXL','/advworks/multimedia/catalog/clothing/dparkas04.gif',125.0,1)
  469. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW032-01','Pants','1996-05-28 00:00:00.000','Women''s 4-pocket pants','medium-weight cotton, pre-washed, green (gn) or beige (sa)','2-16','/advworks/multimedia/catalog/clothing/dpants13.gif',32.0,0)
  470. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW046-01','Pants','1996-05-28 00:00:00.000','Men''s 8-pocket conversion pants','100% cotton canvas, 34" inseam, gray (gr) or brown (br)','28-46','/advworks/multimedia/catalog/clothing/dpants14.gif',46.0,0)
  471. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW048-01','Pants','1996-04-30 00:00:00.000','Unisex drawstring pants','lined, lightweight nylon, green (gn) or brown (br)','S-XXL','/advworks/multimedia/catalog/clothing/dpants15.gif',48.0,1)
  472. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW055-01','Pants','1996-04-23 00:00:00.000','Unisex hiking pants','heavy-duty, water-resistant nylon, lightweight, green (gn) or beige (sa)','S-XXL','/advworks/multimedia/catalog/clothing/dpants16.gif',55.0,0)
  473. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW032-10','Harness','1996-05-29 00:00:00.000','Black Diamond Bod','multipurpose, padded waist, adjustable droppable leg loops, gear racking, padded waist, adjustable ','XS-XL','/advworks/multimedia/catalog/climbing/dharness41.gif',32.0,0)
  474. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW029-10','Harness','1996-04-23 00:00:00.000','Black Diamond Alpine Bod','lightweight, adjustable, droppable leg loops, black (bk)','XS-XL','/advworks/multimedia/catalog/climbing/dharness42.gif',29.0,1)
  475. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW053-10','Harness','1996-05-26 00:00:00.000','El Capitan','comfort harness, generous padding, full-strength haul loop','XS-XL','/advworks/multimedia/catalog/climbing/dharness43.gif',52.0,1)
  476. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW072-10','Harness','1996-02-12 00:00:00.000','Petzl Mercury','padded waist and leg loops, self-locking buckle, pre-threaded, gear racking, assorted colors','XS-XL','/advworks/multimedia/catalog/climbing/dharness44.gif',72.0,1)
  477. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW099-15','Crampon','1996-07-23 00:00:00.000','Venus','hinged crampons for snow and moderate ice, step-in bindings, one size fits men''s 4-12',NULL,'/advworks/multimedia/catalog/climbing/dcrampon37.gif',99.0,0)
  478. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW109-15','Crampon','1996-11-30 00:00:00.000','Wafflestomper','hiking/trekking nontechnical crampons, hinged frame, straps included, one size fits men''s 5-12',NULL,'/advworks/multimedia/catalog/climbing/dcrampon39.gif',109.0,1)
  479. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW145-15','Crampon','1996-08-22 00:00:00.000','Edgehugger','classic technical ice-climbing crampons, rigid, mono points available, one size fits men''s 5-14',NULL,'/advworks/multimedia/catalog/climbing/dcrampon40.gif',145.0,1)
  480. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW149-15','Crampon','1996-07-31 00:00:00.000','Glory Grip','mixed ice and waterfall-climbing crampons, step-in bindings, rigid, vertically oriented front point','M,L','/advworks/multimedia/catalog/climbing/dcrampons38.gif',149.0,1)
  481. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW013-08','Carabiner','1996-07-23 00:00:00.000','Petzl Spirit','straight',NULL,'/advworks/multimedia/catalog/climbing/dcarabiners01.gif',13.0,1)
  482. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW014-08','Carabiner','1996-06-13 00:00:00.000','Petzl Spirit','straight',NULL,'/advworks/multimedia/catalog/climbing/dcarabiners02.gif',14.0,1)
  483. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW007-08','Carabiner','1996-05-14 00:00:00.000','Black Diamond Quicksilver II','straight',NULL,'/advworks/multimedia/catalog/climbing/dcarabiners03.gif',7.0,1)
  484. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW009-08','Carabiner','1996-08-14 00:00:00.000','Black Diamond Quicksilver II','straight',NULL,'/advworks/multimedia/catalog/climbing/dcarabiners04.gif',9.0,0)
  485. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW150-05','Rock Shoes','1996-09-14 00:00:00.000','Gibraltar','high-performance endurance shoes','4-12','/advworks/multimedia/catalog/climbing/drockshoes45.gif',150.0,1)
  486. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW125-05','Rock Shoes','1996-07-16 00:00:00.000','Plymouth','semi-flexed shoes, basic comfort','4-12','/advworks/multimedia/catalog/climbing/drockshoes46.gif',125.0,1)
  487. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW084-05','Rock Shoes','1996-06-03 00:00:00.000','Morro','all-around, durable shoes with Stealth soles','4-12','/advworks/multimedia/catalog/climbing/drockshoes47.gif',84.0,1)
  488. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW086-06','Rock Shoes','1996-07-13 00:00:00.000','Tuscany','all-around shoes with slipper/shoe design','4-12','/advworks/multimedia/catalog/climbing/drockshoes48.gif',124.0,0)
  489. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW325-13','Backpack','1996-05-14 00:00:00.000','Aces','women''s cut, adjustable waistbelt and stays, floating hipbelt, top-loading, side pockets, blue/blac',NULL,'/advworks/multimedia/catalog/camping/dbackpacks21.gif',325.0,1)
  490. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW140-13','Backpack','1996-03-15 00:00:00.000','University','multipurpose, with padded backpad and hipbelt, side pockets, bound seams, blue (bl)',NULL,'/advworks/multimedia/catalog/camping/dbackpacks22.gif',140.0,1)
  491. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW151-13','Backpack','1996-09-19 00:00:00.000','Pacific','weekender, adjustable hipbelt, side pockets, easy-access wraparound zipper, blue (bl)',NULL,'/advworks/multimedia/catalog/camping/dbackpacks23.gif',151.0,0)
  492. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW175-13','Backpack','1996-10-01 00:00:00.000','Conestoga','anti-sway, shoulder-yoke pack for long trips, aluminum frame, front fanny-pack conversion, lower sleeping bag compartment, heavy duty nylon, red (re)',NULL,'/advworks/multimedia/catalog/camping/dbackpacks24.gif',175.0,0)
  493. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW029-03','Shirt','1996-06-19 00:00:00.000','Women''s woven tee','short-sleeve, breathable henley, 100% cotton knit, blue (bl), beige (sa), or green (gn)','S-XL','/advworks/multimedia/catalog/clothing/dshirts12.gif',29.0,1)
  494. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW045-03','Shirt','1996-08-13 00:00:00.000','Men''s loose-weave polo','100% breathable cotton, blue (bl), white (wh), red (re), or beige (sa)','S-XXL','/advworks/multimedia/catalog/clothing/dshirts10.gif',45.0,1)
  495. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW042-03','Shirt','1996-09-13 00:00:00.000','Men''s button-down','short-sleeve, durable, 100% cotton, button-flap pockets, blue (bl), red (re), or beige (sa)','S-L','/advworks/multimedia/catalog/clothing/dshirts11.gif',42.0,0)
  496. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW075-03','Shirt','1996-09-12 00:00:00.000','Unisex long-sleeve button-down','parachute-style, cotton/nylon blend, multiple pockets, green (gn) or beige (sa)','S-XXL','/advworks/multimedia/catalog/clothing/dshirts09.gif',75.0,0)
  497. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW051-14','Supplies','1996-04-25 00:00:00.000','Wolfgang','multifuel cook stove, white gas or unleaded',NULL,'/advworks/multimedia/catalog/camping/dstoves29.gif',59.0,1)
  498. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW425-14','Supplies','1996-05-30 00:00:00.000','Surelite','cold-starter, 80/20 butane/propane cartridges',NULL,'/advworks/multimedia/catalog/camping/dstoves30.gif',4.0,1)
  499. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW031-14','Supplies','1996-04-22 00:00:00.000','Daytrip First Aid Kit','nylon pouch, comprehensive kit for day or weekend trips',NULL,'/advworks/multimedia/catalog/camping/dfirstaidkit31.gif',31.0,1)
  500. INSERT INTO products (ProductCode,ProductType,ProductIntroductionDate,ProductName,ProductDescription,ProductSize,ProductImageURL,UnitPrice,OnSale) VALUES ('AW475-14','Supplies','1996-08-31 00:00:00.000','Scoutpride','all-purpose cook set, stainless-steel nesting pots of 1, 2, and 3 liters, includes lids and fry pan',NULL,'/advworks/multimedia/catalog/camping/ddinningwear32.gif',44.75,0)
  501. go
  502.  
  503. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Nancy','Davolio','Sales Representative',NULL,'(706) 555-9857')
  504. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Andrew','Fuller','Vice President, Sales',NULL,'(706) 555-9482')
  505. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Janet','Leverling','Sales Representative',NULL,'(706) 555-3412')
  506. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Margaret','Peacock','Sales Manager',NULL,'(706) 555-8122')
  507. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Steven','Buchanan','Sales Representative',NULL,'(706) 555-1189')
  508. INSERT INTO employees (FirstName,LastName,Title,Extension,WorkPhone) VALUES ('Adventure Works','Web Site','Customer generated from Web',NULL,NULL)
  509. go
  510.  
  511. INSERT INTO payment_methods (PaymentMethod,CreditCard) VALUES ('Check',0)
  512. INSERT INTO payment_methods (PaymentMethod,CreditCard) VALUES ('Local Bank Credit Card',1)
  513. INSERT INTO payment_methods (PaymentMethod,CreditCard) VALUES ('Teller Machine Card',1)
  514. INSERT INTO payment_methods (PaymentMethod,CreditCard) VALUES ('Fourth Bank Card',1)
  515. go
  516.  
  517. INSERT INTO shipping_methods (ShippingMethod) VALUES ('Speedy Express')
  518. INSERT INTO shipping_methods (ShippingMethod) VALUES ('Federal Shipping')
  519. INSERT INTO shipping_methods (ShippingMethod) VALUES ('Mail Company')
  520. INSERT INTO shipping_methods (ShippingMethod) VALUES ('Slow Shipping')
  521. go
  522.