-- Department Store --
|
|
-- Department Store -- |
USE master
GO
CREATE DATABASE DepartmentStore1;
GO
USE DepartmentStore1;
GO
CREATE SCHEMA Inventory;
GO
CREATE TABLE Inventory.StoreItems
(
ItemNumber int,
Manufacturer nvarchar(50),
Category nvarchar(32),
SubCategory nvarchar(40),
ItemName nvarchar(80),
ItemSize nvarchar(32),
UnitPrice money,
DiscountRate decimal(6, 2)
);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(28495080, N'Juaro Collections', N'Women', N'Coats', N'Classic Trench Coat', N'XL', 225.95, 0.40),
(85539208, N'Adrienne Vittadini', N'Women', N'Shoes', N'Epiphyllum Satin Sandal Pumps', N'6.5M', 225, 0.75),
(74937402, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'8', 65.85, 0.20);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(92082947, N'Collentra Studio', N'Women', N'Shirts', N'Buffalo Check Shirt', N'M', 75.55),
(58260251, N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic Fit Pinpoint Shirt', N'16 32/33', 79.50),
(47005161, N'Calvin Klein', N'Women', N'Dresses', N'Sleeveless Zipper-Trim Rosette Sheath Dress ', N'10', 126.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(60940814, N'Women', N'Suits', N'Black 2-Button Notch-Collar Suit', N'8', 199.90);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(82836482, N'Women', N'Jackets', N'Tropical Wool Two-Button Jacket', N'2', 228.00, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(81307492, N'Calvin Klein', N'Men', N'Shoes', N'Hervey Square-Toe Leather Loafers', N'9.5', 100.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, UnitPrice)
VALUES(92794804, N'Men', N'Jewelry', N'Blue Sandstone Chain Bracelet', 68.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(59744406, N'Women', N'Skirt', N'Polished Cotton Marina Skirt', N'4', 79.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(39381408, N'Women', N'Jackets', N'Tropical Wool Two-Button Jacket', N'6', 228.00, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(77403170, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 55.85);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, ItemSize, UnitPrice)
VALUES(37937414, N'Shiseido', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00),
(28400184, N'Anne Klein', N'Pencil Skirt', N'14', 49.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(21740696, N'Kenneth Cole New York', N'Women', N'Skirts', N'Short Black Skirt', N'8', 55.85, 0.25),
(50268882, N'Tommy Hilfiger', N'Women', N'Coats', N'Long Sleeve Pinstriped Lining Blazer', N'XS', 75.85, 0.60);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, ItemName, ItemSize, UnitPrice)
VALUES(88135582, N'Tommy Hilfiger', N'Women', N'Long Sleeve Pinstriped Lining Blazer', N'S', 75.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(47493968, N'Women', N'Skirts', N'Petite Tech Stretch Seamed Pencil Skirt', N'4', 100.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(75794762, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'9', 65.85, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice, DiscountRate)
VALUES(29472550, N'Perfect Tote', 295.00, 0.10);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(26482625, N'Cole Haan', N'Women', N'Handbags', N'Saddle East/West Leather Hobo Bag', 345.50),
(77920444, N'Coach', N'Women', N'Handbags', N'Leather Tote', 325.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(68460422, N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 0.60);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(15882422, N'Nautica', N'Men', N'Pants', N'Classic 5-Pocket Jeans', N'36W - 30L', 49.50),
(93794722, N'Nautica', N'Men', N'Pants', N'Faded 5-Pocket Jeans', N'38W - 32L', 49.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(26482625, N'Cole Haan', N'Women', N'Handbags', N'Saddle East/West Leather Hobo Bag', 345.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, ItemName, ItemSize, UnitPrice)
VALUES(55293808, N'Tommy Hilfiger', N'Women', N'Long Sleeve Pinstriped Lining Blazer', N'L', 78.55);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(20797422, N'Nautica', N'Men', N'Pants', N'Relaxed-Fit 5-Pocket Jeans', N'36W - 34L', 49.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(49500711, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 49.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice, DiscountRate)
VALUES(72974166, N'Wool Pashmina-style Wrap', 16.95, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(92794010, N'Women', N'Jackets', N'Petite New Femme Jacket', N'6', 210.00),
(50840810, N'Women', N'Belts', N'Exotic Belt', N'4', 44.85);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(79027910, N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic Fit Pinpoint Shirt', N'16 32/33', 82.00, 0.20),
(24795806, N'Kenneth Cole New York', N'Women', N'Dresses', N'Non-Iron Slim-Fit Textured Solid Dress Shirt', N'16 34/35', 45.75, 0.35);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(84009128, N'Tommy Hilfiger', N'Women', N'Silk Sleeveless Braided Keyhole Neck Top', N'XS', 75.85, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(95749281, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'10', 65.85);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(55750429, N'Polo Ralph Lauren', N'Women', N'Shirts', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80, 0.40);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, ItemName, ItemSize, UnitPrice)
VALUES(86166308, N'Tommy Hilfiger', N'Women', N'Silk Sleeveless Braided Keyhole Neck Top', N'M', 72.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(38400816, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'9.5', 65.85),
(80011730, N'Polo Ralph Lauren', N'Women', N'Shirts', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(92574971, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'10.5', 65.85),
(18200225, N'Calvin Klein', N'Men', N'Shoes', N'Leather Loafers', N'8.5', 105.95),
(41824225, N'Calvin Klein', N'Men', N'Shoes', N'Leather Dress Oxfords', N'10', 99.95),
(22418205, N'Johnston & Murphy', N'Men', N'Shoes', N'Deerskin Tassel Loafers', N'9.5W', 105.50),
(72402058, N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers', N'10', 99.85),
(94205559, N'Johnston & Murphy', N'Men', N'Shoes', N'Ainsworth Casual Leather Penny Loafers', N'9.5', 125.85),
(40402250, N'Cole Haan', N'Men', N'Shoes', N'Perforated Leather Oxfords', N'10.5', 175.50),
(20420253, N'Cole Haan', N'Men', N'Shoes', N'Claremont Camp Mocassins', N'12', 95.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice, DiscountRate)
VALUES(62830462, N'Lauren By Ralph Lauren', N'Men', N'Accessories', N'Newbury Black Zip-Around Wallet', 58.80, 0.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(20070428, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 49.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(30403930, N'Women', N'Dresses', N'Pleated Neck Dress', N'16', 180.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(97131605, N'Kenneth Cole', N'Men', N'Accessories', N'Bar Tab Leather Tab Wallet', 22.55),
(49500799, N'Ted Baker', N'Men', N'Accessories', N'Grid Silk Tie', 89.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(49295700, N'Invicta', N'Women', N'Watches', N'Pro Diver Two-tone Watch', 58.95),
(28004148, N'Coach', N'Women', N'Handbads', N'Leather Tote', 328.85);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(29703502, N'Ralph Lauren', N'Girls', N'Shirt', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3T', 18.95);
GO
INSERT INTO Inventory.StoreItems
VALUES(28640622, N'Lauren By Ralph Lauren', N'Women', N'Belts', N'Braided Leather Belt', N'Medium', 54.25, 0.20),
(92735170, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'9.5', 65.85, 0.40),
(64974032, N'Polo Ralph Lauren', N'Women', N'Shirts', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80, 0.60);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(97481520, N'Polo Ralph Lauren', N'Women', N'Sweaters', N'Wool V-Neck Sweater', N'Small', 98.00),
(25842220, N'Calvin Klein', N'Women', N'Shoes', N'2 Plain-Toe Patent Leather Oxfords', N'10', 140.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(20084280, N'AK Anne Klein', N'Women', N'Watches', N'Goldtone Mother-of-Pearl Dial Leather Watch', 55.00),
(70841188, N'AK Anne Klein', N'Women', N'Watches', N'Ladies White & Gold Ceramic Watch', 150.00),
(97520417, N'AK Anne Klein', N'Women', N'Watches', N'Two-Tone Crystal Accented Watch With Silver-Tone Dial', 75.00);
GO
INSERT INTO Inventory.StoreItems
VALUES(18408140, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'8', 65.85, 0.25);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(66028420, N'Shiseido', N'Men', N'Beauty and Grooming', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(20840588, N'Women', N'Skirts', N'Petite Tech Stretch Seamed Pencil Skirt', N'4', 100.00, 0.35);
GO
INSERT INTO Inventory.StoreItems
VALUES(69722402, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'9', 65.85, 0.25),
(72970041, N'CK Calvin Klein', N'Women', N'Shirts', N'Non-Iron Blue Dress Shirt', N'16 32/33', 79.95, 0.35),
(20308003, N'CK Calvin Klein', N'Women', N'Dresses', N'Blue Dress Shirt', N'15 32-33', 54.95, 0.25),
(64696978, N'CK Calvin Klein', N'Women', N'Dresses', N'Non-Iron Textured White Dress Shirt', N'17.5 32/33', 52.95, 0.45);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(20840508, N'Shiseido', N'Men', N'Beauty and Grooming', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, ItemSize, UnitPrice)
VALUES(25706480, N'Calvin Klein', N'Organza Ruffle Halter Gown', N'4', 368.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(97294084, N'Cole Haan', N'Women', N'Handbags', N'East/West Leather Hobo Bag', 345.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(82028418, N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, UnitPrice, DiscountRate)
VALUES(86208040, N'Women', N'Accessories', N'Perfect Luxe Scarf', 45.00, 0.45);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(60294722, N'Women', N'Dresses', N'Pleated Neck Dress', N'16', 180.00, 0.55);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(29720840, N'Boys', N'Pants', N'2-7 Twill Flat-Front Pants', N'2T', 24.50, 0.45);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(79200282, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 55.50),
(79714029, N'Kenneth Cole', N'Men', N'Accessories', N'Bar Tab Leather Tab Wallet', 22.95);
GO
INSERT INTO Inventory.StoreItems
VALUES(17972038, N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 0.05),
(86440228, N'Polo Ralph Lauren', N'Women', N'Shirts', N'Classic Fit Multi Stripe Oxford Shirt', N'L', 82.50, 0.15);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice, DiscountRate)
VALUES(18682400, N'Invicta', N'Women', N'Watches', N'Pro Diver Two-tone Watch', 58.95, 0.50);
GO
INSERT INTO Inventory.StoreItems
VALUES(62831605, N'Kenneth Cole', N'Women', N'Dresses', N'Simplicity Leather Dress Oxfords', N'10.5', 65.85, 0.05);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(79475081, N'Women', N'Jackets', N'Textured Jacket', N'6', 325.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(82611418, N'Citizen', N'Men', N'Watches', N'Men Eco-Drive Leather Watch', 395.95),
(30324300, N'Timex', N'Men', N'Watches', N'Retro Stainless Steel Green Canvas Band Watch', 95),
(61160485, N'Citizen', N'Men', N'Watches', N'Men Skyhawk A-T Chronograph Watch', 650.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(59271133, N'Women', N'Jackets', N'Petite New Femme Jacket', N'2', 210.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(64110484, N'Kenneth Cole Reaction', N'Women', N'Accessories', N'Antiques Wristlet Wallet', 42.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(79700040, N'Kenneth Cole', N'Men', N'Accessories', N'Bar Tab Leather Tab Wallet', 19.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(86040262, N'Women', N'Shoes', N'Leather Sandals', N'080 M', 198.95, 0.40);
GO
INSERT INTO Inventory.StoreItems
VALUES(18824615, N'Calvin Klein', N'Women', N'Dresses', N'Jeweled Sleeveles Sheath Dress', N'14', 135.50, 0.25),
(80000044, N'Calvin Klein', N'Women', N'Dresses', N'Cap Sleeve Ribbed Sweater Dress', N'S', 145.00, 0.45);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(79008024, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 49.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(59273858, N'Women', N'Jackets', N'Petite New Femme Jacket', N'2', 210.00);
GO
INSERT INTO Inventory.StoreItems
VALUES(11972064, N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 0.05),
(77924025, N'Kenneth Cole Reaction', N'Women', N'Shoes', N'Gotta Know Leather High-Heel Sandals', N'4', 69.55, 0.10);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(60291716, N'AK Anne Klein', N'Women', N'Watches', N'Goldtone Dial White Leather Watch', 55.50),
(31355916, N'AK Anne Klein', N'Women', N'Watches', N'Goldtone Mother-of-Pearl Dial Leather Watch', 55.50),
(84181802, N'Citizen', N'Women', N'Watches', N'Eco-Drive Two-Tone Bracelet Watch', 275.00),
(18420202, N'Citizen', N'Men', N'Watches', N'Men Eco-Drive World Perpetual A-T Watch', 495.00),
(24803180, N'Seiko', N'Women', N'Watches', N'Ladies'' Two-Tone Stainless Steel Watch', 295.00),
(40202977, N'Seiko', N'Women', N'Watches', N'Ladies'' Two-Tone Stainless Steel Watch', 395.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(13508022, N'Calvin Klein', N'Women', N'Dresses', N'Long-Sleeved Turtleneck Sweater Dress', N'L', 140);
GO
INSERT INTO Inventory.StoreItems
VALUES(77024180, N'Nautica', N'Women', N'Sweaters', N'Drop Needle Crew-Neck Sweater', N'4', 35.25, 0.05);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(77724082, N'Kenneth Cole Reaction', N'Women', N'Accessories', N'Antiques Wristlet Wallet', 42.75);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(58282420, N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Dress', N'14', 150.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(97446044, N'Kenneth Cole', N'Women', N'Accessories', N'Bar Tab Leather Tab Wallet', 24.95),
(79024642, N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 52.50);
GO
INSERT INTO Inventory.StoreItems
VALUES(77242268, N'Nine West', N'Women', N'Shoes', N'Strappy Sandals', N'7 1/2 M', 89.50, 0.10);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(82941818, N'Women', N'Skirts', N'Petite Tropical Wool Perfect Pencil Skirt', N'6', 110.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(20206095, N'Citizen', N'Men', N'Watches', N'Eco-Drive Men Titanium Bracelet Watch', 115.00);
GO
INSERT INTO Inventory.StoreItems
VALUES(87204712, N'Nine West', N'Women', N'Shoes', N'Strappy Sandals', N'7 1/2 M', 89.50, 10),
(29411708, N'Polo Ralph Lauren', N'Women', N'Shirts', N'Classic Fit Interlock Shirt', N'M', 65.00, NULL);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, ItemName, ItemSize, UnitPrice)
VALUES(86061539, N'Women', N'Narrow V-Neck Top', N'2', 55.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, UnitPrice)
VALUES(79070641, N'Women', N'Jewelery', N'Pearl and Ribbon Four-Strand Necklace', 65.00),
(22799405, N'Women', N'Belts', N'Perfect Skinny Belt', 30.00);
GO
INSERT INTO Inventory.StoreItems
VALUES(79706486, N'Nine West', N'Women', N'Shoes', N'Strappy Sandals', N'8 M', 89.50, 0.10);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(90912046, N'Boys', N'Pants', N'2-7 Twill Flat-Front Pants', N'3T', 24.50, 0.05);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, UnitPrice)
VALUES(60094716, N'AK Anne Klein', N'Women', N'Watches', N'Goldtone Mother-of-Pearl Dial Leather Watch', 55.50);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice)
VALUES(29700249, N'Chain Handle Tote', 225.00),
(85204077, N'Wool Pashmina-style Wrap', 16.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, UnitPrice)
VALUES(99513599, N'Women', N'Jewelery', N'Pearl Stretch Bracelet', 40.00);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice)
VALUES(29500308, N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3T', 18.95);
GO
INSERT INTO Inventory.StoreItems(ItemNumber, Category, SubCategory, ItemName, ItemSize, UnitPrice, DiscountRate)
VALUES(20283518, N'Girls', N'Dresses', N'Girls 2-6x Two-For Dress & Coat', N'4T', 50.00, 0.50),
(29603038, N'Girls', N'Dresses', N'2-6X Two-For Polo & Pleated Plaid Dress', N'4', 40.00, 0.15);
GO
|
|
||
| -- | Copyright © 2012-2013 FunctionX | |
|
|
||