USE Exercise;
GO
-- 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