-- Department Store Database -- ============================================= -- Database: FunDS1 -- Author: FunctionX -- Date: thursday 20 January 2011 - 16:15 -- ============================================= USE master GO -- Drop the database if it already exists IF EXISTS ( SELECT name FROM sys.databases WHERE name = N'FunD1' ) DROP DATABASE FunDS1; /* ON PRIMARY ( NAME = DataRepository, FILENAME = N'C:\Fun Department Store\FunDS1.mdf') LOG ON ( NAME = DataLog, FILENAME = N'C:\Fun Department Store\FunDS1.ldf') GO */ CREATE DATABASE FunDS1; GO USE FunDS1; GO CREATE SCHEMA Inventory; GO CREATE FUNCTION Inventory.SetDateEntered(@days int) RETURNS Date AS BEGIN RETURN DATEADD(d, @days, SYSDATETIME()); END GO -- ======================================================= -- Database: FunDS -- Table: StoreItems -- Description: This table holds an inventory of all the -- merchandise sold in the store -- ======================================================= CREATE TABLE Inventory.StoreItems ( ItemNumber int unique, DateEntered date, Manufacturer nvarchar(50) null, ItemName nvarchar(80) null, Size nvarchar(32), UnitPrice money, DiscountRate decimal(6, 2) ); GO INSERT INTO Inventory.StoreItems VALUES(217409, Inventory.SetDateEntered(-1), N'Kenneth Cole New York', N'Short Black Skirt', N'8', 55.85, 10), (502688, Inventory.SetDateEntered(-8), N'Tommy Hilfiger', N'Long Sleeve Pinstriped Lining Blazer', N'XS', 75.85, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(582604, Inventory.SetDateEntered(-5), N'Polo Ralph Lauren', N'Classic Fit Pinpoint Shirt', N'16 32/33', 79.50), (470051, Inventory.SetDateEntered(-12), N'Calvin Klein', N'Sleeveless Zipper-Trim Rosette Sheath Dress ', N'10', 126.50); GO INSERT INTO Inventory.StoreItems VALUES(749374, Inventory.SetDateEntered(-10), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'8', 65.85, 20), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-10), N'Adrienne Vittadini', N'Epiphyllum Satin Sandal Pumps', N'6.5M', 225, 75); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(379374, Inventory.SetDateEntered(-14), N'Shiseido', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00), (284001, Inventory.SetDateEntered(-4), N'Anne Klein', N'Pencil Skirt', N'14', 49.00), (881355, Inventory.SetDateEntered(-8), N'Tommy Hilfiger', N'Long Sleeve Pinstriped Lining Blazer', N'S', 75.00), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-32), N'Kors Michael Kors', N'Salinas Cut-Out Pumps', N'6.5', 225.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(248592, N'Petite Tech Stretch Seamed Pencil Skirt', N'4', 100.00); GO INSERT INTO Inventory.StoreItems VALUES(757947, Inventory.SetDateEntered(-62), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'9', 65.85, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, ItemName, UnitPrice, DiscountRate) VALUES(294725, Inventory.SetDateEntered(-5), N'Perfect Tote', 295.00, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(264826, Inventory.SetDateEntered(-5), N'Cole Haan', N'Saddle East/West Leather Hobo Bag', 345.50); GO INSERT INTO Inventory.StoreItems VALUES(684604, Inventory.SetDateEntered(-22), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 60); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(158824, Inventory.SetDateEntered(-22), N'Nautica', N'Classic 5-Pocket Jeans', N'36W - 30L', 49.50), (937947, Inventory.SetDateEntered(-22), N'Nautica', N'Faded 5-Pocket Jeans', N'38W - 32L', 49.50), (552998, Inventory.SetDateEntered(-8), N'Tommy Hilfiger', N'Long Sleeve Pinstriped Lining Blazer', N'L', 78.55), (207974, Inventory.SetDateEntered(-22), N'Nautica', N'Relaxed-Fit 5-Pocket Jeans', N'36W - 34L', 49.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(495007, N'Giorgio Armani', N'Acqua Di Gio After Shave Balm', 49.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice, DiscountRate) VALUES(729741, N'Symphony Designs', N'Wool Pashmina-style Wrap', 16.95, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, ItemName, Size, UnitPrice) VALUES(927940, Inventory.SetDateEntered(-10), N'Petite New Femme Jacket', N'6', 210.00), (508408, Inventory.SetDateEntered(-10), N'Exotic Belt', N'4', 44.85); GO INSERT INTO Inventory.StoreItems VALUES(790279, Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Classic Fit Pinpoint Shirt', N'16 32/33', 82.00, 10), (247958, Inventory.SetDateEntered(-6), N'Kenneth Cole New York', N'Non-Iron Slim-Fit Textured Solid Dress Shirt', N'16 34/35', 45.75, 15), (840091, Inventory.SetDateEntered(-8), N'Tommy Hilfiger', N'Silk Sleeveless Braided Keyhole Neck Top', N'XS', 75.85, 25); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(957492, Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'10', 65.85); GO INSERT INTO Inventory.StoreItems VALUES(557504, Inventory.SetDateEntered(-32), N'Polo Ralph Lauren', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80, 20); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(861663, Inventory.SetDateEntered(-8), N'Tommy Hilfiger', N'Silk Sleeveless Braided Keyhole Neck Top', N'M', 72.95), (384008, Inventory.SetDateEntered(-10), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'9.5', 65.85), (800117, Inventory.SetDateEntered(-32), N'Polo Ralph Lauren', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80); GO INSERT INTO Inventory.StoreItems VALUES(864400, Inventory.SetDateEntered(-36), N'Sweetheart Rose', N'Girls 2-6x Eyelet Dress', N'5', 48.50, 0); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(925749, Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'10.5', 65.85), (120022, Inventory.SetDateEntered(-5), N'Calvin Klein', N'Leather Loafers', N'8.5', 105.95), (412422, Inventory.SetDateEntered(-5), N'Calvin Klein', N'Leather Dress Oxfords', N'10', 99.95), (224120, Inventory.SetDateEntered(-5), N'Johnston & Murphy', N'Deerskin Tassel Loafers', N'9.5W', 105.50), (724020, Inventory.SetDateEntered(-5), N'Calvin Klein', N'Square-Toe Leather Loafers', N'10', 99.85), (942055, Inventory.SetDateEntered(-5), N'Johnston & Murphy', N'Ainsworth Casual Leather Penny Loafers', N'9.5', 125.85), (404022, Inventory.SetDateEntered(-5), N'Cole Haan', N'Perforated Leather Oxfords', N'10.5', 175.50), (204202, Inventory.SetDateEntered(-5), N'Cole Haan', N'Claremont Camp Mocassins', N'12', 95.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice, DiscountRate) VALUES(628346, Inventory.SetDateEntered(-12), N'Lauren By Ralph Lauren', N'Newbury Black Zip-Around Wallet', N'OS', 58.80, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(979120, N'Pleated Neck Dress', N'16', 180.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(707394, N'Kenneth Cole', N'Bar Tab Leather Tab Wallet', 22.55), (972934, N'Ted Baker', N'Grid Silk Tie', 89.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(295300, Inventory.SetDateEntered(-5), N'Little Me', N'Baby Bear Footies With Hat', N'6 Months', 9.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(492957, N'Invicta', N'Pro Diver Two-tone Watch', 58.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(779204, Inventory.SetDateEntered(-44), N'Coach', N'Leather Tote', 325.95), (200704, Inventory.SetDateEntered(-28), N'Giorgio Armani', N'Acqua Di Gio After Shave Balm', 49.50), (971316, Inventory.SetDateEntered(-5), N'Symphony Designs', N'Wool Pashmina-style Wrap', 16.95), (280041, Inventory.SetDateEntered(-48), N'Coach', N'Leather Tote', 328.85); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(297035, Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3T', 18.95); GO INSERT INTO Inventory.StoreItems VALUES(286401, Inventory.SetDateEntered(-22), N'Lauren By Ralph Lauren', N'Braided Leather Belt', N'Medium', 54.25, 10), (927351, Inventory.SetDateEntered(-10), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'9.5', 65.85, 10), (649004, Inventory.SetDateEntered(-32), N'Polo Ralph Lauren', N'Classic Fit Checked Poplin Shirt', N'XL', 88.80, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(709274, Inventory.SetDateEntered(-42), N'Little Me', N'Baby Bear Footies With Hat', N'8 Months', 9.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(790402, N'Petite New Femme Jacket', N'2', 210.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(770240, Inventory.SetDateEntered(-30), N'Eileen Fisher', N'Suede Thin Double-Wrapped Belt', N'Medium', 58.80); GO INSERT INTO Inventory.StoreItems VALUES(952735, Inventory.SetDateEntered(-10), N'Black Brown 1826', N'3-Button Top Coat', N'42R', 495.00, 25); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(974815, Inventory.SetDateEntered(-20), N'Polo Ralph Lauren', N'Wool V-Neck Sweater', N'Small', 98.00), (258422, Inventory.SetDateEntered(-20), N'Calvin Klein', N'2 Plain-Toe Patent Leather Oxfords', N'10', 140.00), (200842, Inventory.SetDateEntered(-10), N'AK Anne Klein', N'Goldtone Mother-of-Pearl Dial Leather Watch', N'One Size', 55.00), (708411, Inventory.SetDateEntered(-10), N'AK Anne Klein', N'Ladies'' White & Gold Ceramic Watch', N'No Size', 150.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(975204, Inventory.SetDateEntered(-10), N'AK Anne Klein', N'Two-Tone Crystal Accented Watch With Silver-Tone Dial', N'One Size', 75.00), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'Michael Kors', N'Mother-of-Pearl Clear Plastic Chronograph Watch', N'One Size', 225.00), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'Michael Kors', N'Ladies'' White & Gold Glitz Chronograph Watch', N'One Size', 225.00), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'Michael Kors', N'Ladies'' Faux-Horn Watch', N'One Size', 180.00); GO INSERT INTO Inventory.StoreItems VALUES(184081, Inventory.SetDateEntered(-40), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'8', 65.85, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(660284, Inventory.SetDateEntered(-2), N'Shiseido', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice, DiscountRate) VALUES(208405, N'Petite Tech Stretch Seamed Pencil Skirt', N'4', 100.00, 10); GO INSERT INTO Inventory.StoreItems VALUES(697224, Inventory.SetDateEntered(-12), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'9', 65.85, 10), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Non-Iron Blue Dress Shirt', N'16 32/33', 79.95, 20), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Blue Dress Shirt', N'15 32-33', 54.95, 10), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Non-Iron Textured White Dress Shirt', N'17.5 32/33', 52.95, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-2), N'Shiseido', N'Zen Perfumed Shower Gel', N'3.3 Oz', 35.00), (FLOOR(RAND() * 1000000), Inventory.SetDateEntered(-12), N'Calvin Klein', N'Organza Ruffle Halter Gown', N'4', 368.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(972947, N'Cole Haan', N'East/West Leather Hobo Bag', 345.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(820284, Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice, DateEntered) VALUES(862040, N'Perfect Luxe Scarf', 45.00, Inventory.SetDateEntered(-5)); GO INSERT INTO Inventory.StoreItems VALUES(297204, N'2010-08-12', N'Mulberribush', N'2-7 Twill Flat-Front Pants', N'2T', 24.50, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice, DateEntered) VALUES(602947, N'Pleated Neck Dress', N'16', 180.00, Inventory.SetDateEntered(-10)); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(792002, Inventory.SetDateEntered(-12), N'Giorgio Armani', N'Acqua Di Gio After Shave Balm', 55.50), (797140, Inventory.SetDateEntered(-12), N'Kenneth Cole', N'Bar Tab Leather Tab Wallet', 22.95); GO INSERT INTO Inventory.StoreItems VALUES(119723, Inventory.SetDateEntered(-8), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(740597, N'Petite New Femme Jacket', N'6', 210.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(628460, Inventory.SetDateEntered(-32), N'Mulberribush', N'2-7 Twill Flat-Front Pants', N'3T', 24.50); GO INSERT INTO Inventory.StoreItems VALUES(864402, Inventory.SetDateEntered(-28), N'Polo Ralph Lauren', N'Classic Fit Multi Stripe Oxford Shirt', N'L', 82.50, 15); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice, DateEntered) VALUES(186824, N'Invicta', N'Pro Diver Two-tone Watch', 58.95, Inventory.SetDateEntered(-5)); GO INSERT INTO Inventory.StoreItems VALUES(628316, Inventory.SetDateEntered(-5), N'Kenneth Cole', N'Simplicity Leather Dress Oxfords', N'10.5', 65.85, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, ItemName, Size, UnitPrice) VALUES(794750, Inventory.SetDateEntered(-8), N'Textured Jacket', N'6', 325.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(826114, Inventory.SetDateEntered(-12), N'Citizen', N'Men''s Eco-Drive Leather Watch', 395.95), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-10), N'Michael Kors', N'Black Polyurethane-Wrapped Chronograph Watch', 195.00), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-6), N'Timex', N'Retro Stainless Steel Green Canvas Band Watch', 95), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-10), N'Michael Kors', N'Men''s Silicone Chronograph Watch', 160), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-6), N'Citizen', N'Men''s Skyhawk A-T Chronograph Watch', 650.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(592733, N'Petite New Femme Jacket', N'2', 210.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(295001, Inventory.SetDateEntered(-2), N'Little Me', N'Baby Bear Footies With Hat', N'6 Months', 9.95); GO INSERT INTO Inventory.StoreItems VALUES(641104, Inventory.SetDateEntered(-84), N'Kenneth Cole Reaction', N'Antiques Wristlet Wallet', N'One Size', 42.50, 0); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(797040, N'Kenneth Cole', N'Bar Tab Leather Tab Wallet', 19.95); GO INSERT INTO Inventory.StoreItems VALUES(860402, Inventory.SetDateEntered(-62), N'Via Spiga', N'Leather Sandals', N'080 M', 198.95, 40), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-44), N'Calvin Klein', N'Jeweled Sleeveles Sheath Dress', N'14', 135.50, 25), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-44), N'Calvin Klein', N'Cap Sleeve Ribbed Sweater Dress', N'S', 145.00, 45); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(790002, Inventory.SetDateEntered(-4), N'Giorgio Armani', N'Acqua Di Gio After Shave Balm', 49.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(709174, Inventory.SetDateEntered(-1), N'Little Me', N'Baby Bear Footies With Hat', N'8 Months', 9.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(592735, N'Petite New Femme Jacket', N'2', 210.00); GO INSERT INTO Inventory.StoreItems VALUES(119720, Inventory.SetDateEntered(-64), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 18.95, 5), (779240, Inventory.SetDateEntered(-25), N'Kenneth Cole Reaction', N'Gotta Know Leather High-Heel Sandals', N'4', 69.55, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(602917, Inventory.SetDateEntered(-16), N'AK Anne Klein', N'Goldtone Dial White Leather Watch', N'Once Size', 55.50), (313559, Inventory.SetDateEntered(-16), N'AK Anne Klein', N'Goldtone Mother-of-Pearl Dial Leather Watch', N'One Size', 55.50), (841818, Inventory.SetDateEntered(-12), N'Citizen', N'Eco-Drive Two-Tone Bracelet Watch', N'One Size', 275.00), (184202, Inventory.SetDateEntered(-12), N'Citizen', N'Men''s Eco-Drive World Perpetual A-T Watch', N'One Size', 495.00), (248031, Inventory.SetDateEntered(-10), N'Seiko', N'Ladies'' Two-Tone Stainless Steel Watch', N'One Size', 295.00), (402029, Inventory.SetDateEntered(-10), N'Seiko', N'Ladies'' Two-Tone Stainless Steel Watch', N'One Size', 395.00), (FLOOR(RAND() * 100000), Inventory.SetDateEntered(-12), N'Calvin Klein', N'Long-Sleeved Turtleneck Sweater Dress', N'L', 140); GO INSERT INTO Inventory.StoreItems VALUES(297030, Inventory.SetDateEntered(-5), N'Sweatheart Rose', N'2-6X Two-For Polo & Pleated Plaid Dress', N'2', 40.00, 10), (770241, Inventory.SetDateEntered(-10), N'Nautica', N'Drop Needle Crew-Neck Sweater', N'4', 35.25, 5); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(286402, N'Andiamo', N'Solid 500 Thread Count Egyptian Cotton Sheet', 44.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, UnitPrice) VALUES(862046, Inventory.SetDateEntered(-12), N'Symphony Designs', N'Wool Pashmina-style Wrap', 16.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(777240, Inventory.SetDateEntered(-8), N'Kenneth Cole Reaction', N'Antiques Wristlet Wallet', N'One Size', 42.75), (582824, Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Sleeveless Dress', N'14', 150.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(797440, N'Kenneth Cole', N'Bar Tab Leather Tab Wallet', 24.95), (790202, N'Giorgio Armani', N'Acqua Di Gio After Shave Balm', 52.50); GO INSERT INTO Inventory.StoreItems VALUES(952935, Inventory.SetDateEntered(-46), N'Black Brown 1826', N'Button Top Coat', N'42R', 495.00, 50), (779242, Inventory.SetDateEntered(-28), N'Nine West', N'Strappy Sandals', N'7 1/2 M', 89.50, 10); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(829411, N'Petite Tropical Wool Perfect Pencil Skirt', N'6', 110.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(200095, N'Citizen', N'Eco-Drive Men''s Titanium Bracelet Watch', 115.00); GO INSERT INTO Inventory.StoreItems VALUES(872047, Inventory.SetDateEntered(-12), N'Nine West', N'Strappy Sandals', N'7 1/2 M', 89.50, 10), (294117, Inventory.SetDateEntered(-8), N'Polo Ralph Lauren', N'Classic Fit Interlock Shirt', N'M', 65.00, 0); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(827114, Inventory.SetDateEntered(-4), N'Joseph Abbound', N'Guys 8-20 Blue & Tan Striped Dress Shirt', N'4', 45.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, Size, UnitPrice) VALUES(860613, N'Narrow V-Neck Top', N'2', 55.50); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice) VALUES(790064, N'Pearl and Ribbon Four-Strand Necklace', 65.00), (227994, N'Perfect Skinny Belt', 30.00); GO INSERT INTO Inventory.StoreItems VALUES(797064, Inventory.SetDateEntered(-86), N'Nine West', N'Strappy Sandals', N'8 M', 89.50, 10), (909120, Inventory.SetDateEntered(-46), N'Mulberribush', N'2-7 Twill Flat-Front Pants', N'3T', 24.50, 5), (600947, Inventory.SetDateEntered(-16), N'AK Anne Klein', N'Goldtone Mother-of-Pearl Dial Leather Watch', N'One Size', 55.50, 0); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice) VALUES(297249, N'Chain Handle Tote', 225.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, Manufacturer, ItemName, UnitPrice) VALUES(852040, N'Symphony Designs', N'Wool Pashmina-style Wrap', 16.95); GO INSERT INTO Inventory.StoreItems(ItemNumber, ItemName, UnitPrice) VALUES(995135, N'Pearl Stretch Bracelet', 40.00); GO INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, ItemName, Size, UnitPrice) VALUES(290030, Inventory.SetDateEntered(-8), N'Ralph Lauren', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3T', 18.95); GO INSERT INTO Inventory.StoreItems VALUES(202835, Inventory.SetDateEntered(-18), N'Bonnie Jean', N'Girls 2-6x Two-For Dress & Coat', N'4T', 50.00, 50), (296030, Inventory.SetDateEntered(-38), N'Sweatheart Rose', N'2-6X Two-For Polo & Pleated Plaid Dress', N'4', 40.00, 15); GO