// FunDS - Fun Department Store
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("IF EXISTS ( " +
" SELECT name " +
" FROM sys.databases " +
" WHERE name = N'FunDS1' " +
")" +
"DROP DATABASE FunDS1; " +
"CREATE DATABASE FunDS1;",
cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
MessageBox.Show("A database named FunDS has been created.",
"College Park Auto Repair",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE SCHEMA Inventory;", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE SCHEMA HumanResources;", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE SCHEMA Transactions;", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE FUNCTION Inventory.SetDateEntered(@days int) " +
"RETURNS Date " +
"AS " +
"BEGIN" +
" RETURN DATEADD(d, @days, SYSDATETIME());" +
"END", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.Manufacturers " +
"( " +
" Manufacturer nvarchar(25) not null, " +
" Constraint PK_Manufacturers Primary Key(Manufacturer) " +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.Categories " +
"( " +
" Category nvarchar(25) not null, " +
" Constraint PK_Categories Primary Key(Category) " +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.SubCategories " +
"( " +
" SubCategory nvarchar(25) not null, " +
" Constraint PK_SubCategories Primary Key(SubCategory) " +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE HumanResources.Employees " +
"( " +
" EmployeeNumber nvarchar(10) NOT NULL, " +
" FirstName nvarchar(25) NULL, " +
" LastName nvarchar(25) NULL, " +
" Title nvarchar(50), " +
" HourlySalary money NULL, " +
" Username nvarchar(20), " +
" UserPassword nvarchar(25) default N'Password1', " +
" CONSTRAINT PK_Employees PRIMARY KEY(EmployeeNumber) " +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;")_
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.StoreItems " +
"( " +
" StoreItemID int identity(1, 1), " +
" ItemNumber nvarchar(10) unique, " +
" DateEntered date, " +
" Manufacturer nvarchar(25) null, " +
" Category nvarchar(25), " +
" SubCategory nvarchar(25), " +
" ItemName nvarchar(80) null, " +
" ItemSize nvarchar(32), " +
" DaysInStore int, " +
" UnitPrice money, " +
" DiscountRate decimal(6, 2) default 0.00, " +
" DiscountAmount money default 0.00, " +
" MarkedPrice money default 0.00, " +
" Constraint PK_StoreItems Primary Key(ItemNumber), " +
" Constraint FK_Manufacturers Foreign Key(Manufacturer) References Inventory.Manufacturers(Manufacturer), " +
" Constraint FK_Categories Foreign Key(Category) References Inventory.Categories(Category), " +
" Constraint FK_SubCategories Foreign Key(SubCategory) References Inventory.SubCategories(SubCategory)" +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Transactions.ShoppingSessions " +
"( " +
" ShoppingSessionID int identity(1, 1), " +
" ReceiptNumber int not null, " +
" EmployeeNumber nvarchar(10), " +
" ShoppingDate nvarchar(40), " +
" ShoppingTime nvarchar(20), " +
" SaleTotal money, " +
" Constraint PK_ShoppingSessions Primary Key(ReceiptNumber), " +
" Constraint FK_Clerks Foreign Key(EmployeeNumber) References HumanResources.Employees(EmployeeNumber)" +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.SaleItems " +
"( " +
" SaleItemID int identity(1, 1) not null, " +
" ReceiptNumber int not null, " +
" ItemNumber nvarchar(10), " +
" ItemName nvarchar(80), " +
" ItemSize nvarchar(32), " +
" UnitPrice money, " +
" DiscountRate decimal(6, 2), " +
" DiscountAmount money, " +
" SalePrice money, " +
" CONSTRAINT PK_SaleItems Primary Key(SaleItemID)" +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.SoldItems " +
"( " +
" SoldItemID int identity(1, 1) not null, " +
" ReceiptNumber int, " +
" ItemNumber nvarchar(10), " +
" DateEnteredInStore date, " +
" SaleDate date, " +
" Manufacturer nvarchar(25) null, " +
" Category nvarchar(25), " +
" SubCategory nvarchar(25), " +
" ItemName nvarchar(80), " +
" ItemSize nvarchar(32), " +
" DaysInStore int, " +
" UnitPrice money, " +
" DiscountRate decimal(6, 2), " +
" DiscountAmount money, " +
" SalePrice money, " +
" Constraint PK_SoldItems Primary Key(SoldItemID)" +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("CREATE TABLE Inventory.UnsoldItems " +
"( " +
" UnsoldItemID int identity(1, 1), " +
" ItemNumber nvarchar(10) unique, " +
" DateEnteredInStore date, " +
" DateRemovedFromStore date, " +
" DaysInStore int, " +
" Manufacturer nvarchar(25) null, " +
" Category nvarchar(25), " +
" SubCategory nvarchar(25), " +
" ItemName nvarchar(80) null, " +
" ItemSize nvarchar(32), " +
" UnitPrice money, " +
" Constraint PK_UnsoldItems Primary Key(ItemNumber)" +
");", cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
}
using (SqlConnection cntFunDS = new SqlConnection("Data Source=(local);Database='FunDS1';Integrated Security=True;"))
{
SqlCommand cmdDatabase = new SqlCommand("INSERT INTO HumanResources.Employees " +
"VALUES(N'295374', N'Daniel', N'Hough', N'General Manager', 32.14, N'dhough', default), " +
" (N'927486', N'Hortense', N'McCullough', N'Sales Associate', 16.25, N'hmccullough', default), " +
" (N'473847', N'Patrick', N'Bibang', N'Sales Manager', 24.06, N'pbibang', default), " +
" (N'275594', N'Zanie', N'Hankabah', N'Sales Associate', 18.42, N'zaankabah', default), " +
" (N'702048', N'Justine', N'Namm', N'Webmaster', 22.53, N'jnamm', default), " +
" (N'802749', N'Charlotte', N'Hennessey', N'Sales Associate', 16.48, N'chennessey', default); " +
"INSERT INTO Inventory.Manufacturers(Manufacturer) " +
"VALUES(N'N/A'), " +
" (N'Ralph Lauren'), (N'Polo Ralph Lauren'), (N'Lauren By Ralph Lauren'), " +
" (N'Kenneth Cole'), (N'Kenneth Cole New York'), (N'Kenneth Cole Reaction'), " +
" (N'Calvin Klein'), (N'CK Calvin Klein'), (N'Anne Klein'), (N'AK Anne Klein'), " +
" (N'Cole Haan'), (N'Collentra Studio'), (N'Shiseido'), (N'Jean Stewards'), " +
" (N'Tommy Hilfiger'), (N'Juaro Collections'), (N'Nautica'), (N'Coach'), " +
" (N'Giorgio Armani'), (N'Johnston and Murphy'), (N'Invicta'), (N'Guess'), " +
" (N'Nine West'), (N'Citizen'), (N'Lacoste'), " +
" (N'Clarks'), (N'Timex'), (N'Seiko'); " +
"INSERT INTO Inventory.Categories(Category) " +
"VALUES(N'N/A'), (N'Women'),(N'Men'),(N'Girls'),(N'Boys'),(N'Baby Girls'),(N'Baby Boys'),(N'Others'); " +
"INSERT INTO Inventory.SubCategories(SubCategory) " +
"VALUES(N'N/A'), " +
" (N'Shirts'), (N'Pants'), (N'Dresses'), (N'Skirts'), (N'Blouse'), (N'Sweaters'), " +
" (N'Coats'), (N'Jackets'), (N'Shoes'), (N'Suits'), (N'Handbags'), (N'Wallets'), " +
" (N'Belts'), (N'Ties'), (N'Beauty and Grooming'), (N'Jewelry'), (N'Hats'), " +
" (N'Watches'), (N'Accessories'); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'125156', Inventory.SetDateEntered( 0), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'6', 94.50), " +
" (N'578115', Inventory.SetDateEntered( 0), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'4', 94.50), " +
" (N'215392', Inventory.SetDateEntered( 0), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'0', 115), " +
" (N'351438', Inventory.SetDateEntered( 0), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'2', 115), " +
" (N'115475', Inventory.SetDateEntered( 0), N'Calvin Klein', N'Men', N'Shoes', N'Hervey Square-Toe Leather Loafers', N'9.5', 100), " +
" (N'923184', Inventory.SetDateEntered( 0), N'Calvin Klein', N'Men', N'Shoes', N'Hervey Square-Toe Leather Loafers', N'10', 100), " +
" (N'177014', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3T', 18.95), " +
" (N'262334', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 34.95), " +
" (N'441180', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'3/3T', 34.95), " +
" (N'553177', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2T', 34.95), " +
" (N'720882', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2/2T', 34.95), " +
" (N'818329', Inventory.SetDateEntered(-1), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6X Short-Sleeved Mesh Polo Shirt', N'2/2T', 34.95), " +
" (N'177640', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'M', 145.50), " +
" (N'259530', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'M', 164.50), " +
" (N'292975', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'L', 145.50), " +
" (N'749755', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'S', 145.50), " +
" (N'366202', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'S', 164.50), " +
" (N'661150', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'XS', 145.50), " +
" (N'941593', Inventory.SetDateEntered(-1), N'Kenneth Cole', N'Women', N'Dresses', N'Three-Quarter Sleeved Dress', N'L', 164.50), " +
" (N'386174', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Bow Dress', N'18M', 9.95), " +
" (N'406615', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Bow Dress', N'12M', 9.95), " +
" (N'960303', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Bow Dress', N'24M', 9.95), " +
" (N'184617', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Print Dress', N'12M', 10.00), " +
" (N'581407', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Print Dress', N'18M', 10.00), " +
" (N'831796', Inventory.SetDateEntered(-2), N'AK Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Floral Print Dress', N'24M', 10.00); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'220573', Inventory.SetDateEntered(-2), N'Nautica', N'Baby Girls', N'Baby Girls 12-24 Months Lace Two-Piece Set', N'12M', 40), " +
" (N'442963', Inventory.SetDateEntered(-2), N'Nautica', N'Baby Girls', N'Baby Girls 12-24 Months Lace Two-Piece Set', N'18M', 40), " +
" (N'564615', Inventory.SetDateEntered(-2), N'Nautica', N'Baby Girls', N'Baby Girls 12-24 Months Lace Two-Piece Set', N'24M', 40); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'186184', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'14', 195), " +
" (N'248449', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'6', 195), " +
" (N'305052', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'12', 195), " +
" (N'683006', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'0', 195), " +
" (N'712960', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'4', 195), " +
" (N'748037', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'8', 195), " +
" (N'770288', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'10', 195), " +
" (N'826304', Inventory.SetDateEntered(-2), N'Ralph Lauren', N'Women', N'Dresses', N'Structured Scoopneck Ponte Dress', N'2', 195), " +
" (N'242930', Inventory.SetDateEntered(-3), N'Ralph Lauren', N'Boys', N'Sweaters', N'Boys 2-7 Long-Sleeved Cable Crewneck T-Shirt', N'3/3T', 55), " +
" (N'292068', Inventory.SetDateEntered(-3), N'Ralph Lauren', N'Boys', N'Sweaters', N'Boys 2-7 Long-Sleeved Cable Crewneck T-Shirt', N'6', 55), " +
" (N'848408', Inventory.SetDateEntered(-3), N'Ralph Lauren', N'Boys', N'Sweaters', N'Boys 2-7 Long-Sleeved Cable Crewneck T-Shirt', N'4', 55), " +
" (N'429735', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'30W - 30L', 84.85), " +
" (N'142059', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'34W - 32L', 84.85), " +
" (N'592692', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'38W - 30L', 84.85), " +
" (N'274205', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'33W - 30L', 84.85), " +
" (N'276695', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'36W - 30L', 84.85), " +
" (N'327360', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'30W - 29L', 84.85), " +
" (N'306372', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'35W - 32L', 84.85), " +
" (N'379242', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'38W - 32L', 84.85), " +
" (N'429227', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'36W - 29L', 84.85), " +
" (N'479260', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'33W - 32L', 84.85), " +
" (N'482035', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'35W - 30L', 84.85), " +
" (N'526829', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'32W - 20L', 84.85), " +
" (N'169752', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'40W - 32L', 84.85), " +
" (N'585713', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'34W - 30L', 84.85), " +
" (N'580837', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'34W - 29L', 84.85), " +
" (N'602717', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'32W - 30L', 84.85), " +
" (N'605508', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'36W - 32L', 84.85), " +
" (N'779626', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'40W - 30L', 84.85), " +
" (N'937311', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Pants', N'Classic Straight-Leg Jeans', N'38W - 29L', 84.85), " +
" (N'203081', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'M', 105), " +
" (N'274682', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'L', 105), " +
" (N'441559', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'S', 105), " +
" (N'861474', Inventory.SetDateEntered(-3), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'XL', 105), " +
" (N'252937', Inventory.SetDateEntered(-3), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Casey Cotton Tunic', N'2/2T', 39.95), " +
" (N'636816', Inventory.SetDateEntered(-3), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Casey Cotton Tunic', N'4/4T', 39.95), " +
" (N'405758', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Dresses', N'Girls 2-6X Denim Print Ruffled Dress', N'41035', 34.95), " +
" (N'428741', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Dresses', N'Girls 2-6X Denim Print Ruffled Dress', N'3T', 34.95), " +
" (N'559606', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Dresses', N'Girls 2-6X Denim Print Ruffled Dress', N'3T', 34.95), " +
" (N'868088', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Dresses', N'Girls 2-6X Denim Print Ruffled Dress', N'2T', 34.95), " +
" (N'302418', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Sweaters', N'Girls 2-6X Embellished Cardigan', N'5', 42.85), " +
" (N'527038', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Sweaters', N'Girls 2-6X Embellished Cardigan', N'3T', 42.85), " +
" (N'536381', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Sweaters', N'Girls 2-6X Embellished Cardigan', N'2T', 42.85), " +
" (N'520744', Inventory.SetDateEntered(-3), N'Guess', N'Girls', N'Sweaters', N'Girls 2-6X Embellished Cardigan', N'4', 42.85), " +
" (N'795181', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'36W 32L', 65), " +
" (N'282584', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'42W 30L', 65), " +
" (N'829482', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'36W 29L', 65), " +
" (N'296602', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'35W 32L', 65), " +
" (N'314941', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'33W 30L', 65), " +
" (N'404292', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'34W 29L', 65), " +
" (N'413961', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'40W 32L', 65), " +
" (N'461881', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'38W 29L', 65), " +
" (N'502252', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'32W 30L', 65), " +
" (N'550424', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'34W 30L', 65), " +
" (N'695052', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'40W 30L', 65), " +
" (N'975151', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Mid-Weight Flat-Front Wool Trouser Pants', N'38W 30L', 65), " +
" (N'159420', Inventory.SetDateEntered(-3), N'Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'4', 54), " +
" (N'284961', Inventory.SetDateEntered(-3), N'Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'6', 54), " +
" (N'392859', Inventory.SetDateEntered(-3), N'Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'8', 54), " +
" (N'683079', Inventory.SetDateEntered(-3), N'Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'2', 54), " +
" (N'915383', Inventory.SetDateEntered(-3), N'Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'10', 54); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'197994', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Women', N'Accessories', N'Printed Silk Scarf', 40), " +
" (N'367872', Inventory.SetDateEntered(-3), N'Lauren by Ralph Lauren', N'Women', N'Accessories', N'Printed Silk Scarf', 45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'239240', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'30/30', 45), " +
" (N'364192', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'31/30', 45), " +
" (N'266057', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'34/30', 45), " +
" (N'275587', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'36/32', 45), " +
" (N'343511', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'32/30', 45), " +
" (N'361666', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'38/32', 45), " +
" (N'689771', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'38/30', 45), " +
" (N'723217', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'40/32', 45), " +
" (N'734299', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'33/32', 45), " +
" (N'799757', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'34/32', 45), " +
" (N'859703', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'40/30', 45), " +
" (N'941458', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'33/30', 45), " +
" (N'992129', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Men', N'Pants', N'Straight Leg Jean in Black Wash', N'36/30', 45), " +
" (N'948596', Inventory.SetDateEntered(-3), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt ', N'17 32/34', 47.75), " +
" (N'120428', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'4', 194.95), " +
" (N'274993', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'6', 194.95), " +
" (N'414280', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'2', 194.95), " +
" (N'525438', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'10', 194.95), " +
" (N'542891', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'8', 194.95), " +
" (N'545976', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'12', 194.95), " +
" (N'701288', Inventory.SetDateEntered(-3), N'Calvin Klein', N'Women', N'Skirts', N'Zipper Pencil Skirt', N'0', 194.95), " +
" (N'168724', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Men', N'Sweaters', N'1/4-Zip Pull-Over Fleece', N'S', 114.75), " +
" (N'326795', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Men', N'Sweaters', N'1/4-Zip Pull-Over Fleece', N'L', 114.75), " +
" (N'601834', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Men', N'Sweaters', N'1/4-Zip Pull-Over Fleece', N'M', 114.75), " +
" (N'891682', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Men', N'Sweaters', N'1/4-Zip Pull-Over Fleece', N'XL', 114.75), " +
" (N'158391', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Leggings Set', N'18M', 25), " +
" (N'253733', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Leggings Set', N'12M', 25), " +
" (N'743686', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Leggings Set', N'24M', 25), " +
" (N'367172', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Nautical Dress', N'12M', 19.95), " +
" (N'510262', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Nautical Dress', N'18M', 19.95), " +
" (N'562720', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Nautical Dress', N'9M', 19.95), " +
" (N'750570', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Nautical Dress', N'24M', 19.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'812471', Inventory.SetDateEntered(-4), N'Calvin Klein', N'Women', N'Accessories', N'Charm Print Silk Scarf', 65); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'204065', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'18 32/33', 37.75), " +
" (N'294875', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'16 32/34', 37.75), " +
" (N'352292', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'17 32/33', 37.75), " +
" (N'497005', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'15.5 34/35', 37.75), " +
" (N'497960', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'16.5 36/37', 37.75), " +
" (N'582406', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'16 32/33', 37.75), " +
" (N'837460', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'17 32/34', 37.75), " +
" (N'868407', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'15.5 32/33', 37.75), " +
" (N'927974', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'16.5 34/35', 37.75), " +
" (N'993742', Inventory.SetDateEntered(-4), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Dress Shirt, Urban Satin', N'17 33/34', 37.75), " +
" (N'199897', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'6', 25), " +
" (N'307047', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'6X', 25), " +
" (N'518870', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'3/3T ', 25), " +
" (N'737313', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'4', 25), " +
" (N'866976', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'2/2T ', 25), " +
" (N'961760', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Carpe Diem Striped T-Shirt', N'5', 25), " +
" (N'996773', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Shirts', N'Infants Bow T-Shirt', N'12 Months', 5.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'289367', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Infants Plaid Tunic and Leggings', N'9 Months', 12.9), " +
" (N'865846', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Infants Plaid Tunic and Leggings', N'12 Months', 12.9), " +
" (N'127786', Inventory.SetDateEntered(-4), N'Ralph Lauren', N'Baby Girls', N'Infants Popcorn-Knit Hoody', N'9M', 14); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'506513', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Skirts', N'Infants Tiered Skirt', N'18 Months', 8.15), " +
" (N'640998', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Skirts', N'Infants Tiered Skirt', N'24 Months', 8.15), " +
" (N'641085', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Baby Girls', N'Skirts', N'Infants Tiered Skirt', N'12 Months', 8.15); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'900026', Inventory.SetDateEntered(-4), N'Women', N'Accessories', N'Lace-Stripe Scarf', 35); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'374345', Inventory.SetDateEntered(-4), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Pima Cotton V-Neck Sweater', N'M', 95.95), " +
" (N'639554', Inventory.SetDateEntered(-4), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Pima Cotton V-Neck Sweater', N'XL', 95.95), " +
" (N'753222', Inventory.SetDateEntered(-4), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Pima Cotton V-Neck Sweater', N'S', 95.95), " +
" (N'797798', Inventory.SetDateEntered(-4), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Pima Cotton V-Neck Sweater', N'L', 95.95), " +
" (N'481664', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'Pinstriped Two-Piece Wool Suit', N'40L', 212), " +
" (N'590371', Inventory.SetDateEntered(-4), N'Nautica', N'Men', N'Sweaters', N'Quarter-Zip Cable Sweater', N'S', 24.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'831275', Inventory.SetDateEntered(-4), N'Women', N'Accessories', N'Shimmer Frayed Scarf', 35), " +
" (N'624579', Inventory.SetDateEntered(-4), N'Women', N'Accessories', N'Solid Silk Scarf', 34.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'283614', Inventory.SetDateEntered(-4), N'Nautica', N'Men', N'Sweaters', N'Striped Cardigan', N'XL', 28.85), " +
" (N'875254', Inventory.SetDateEntered(-4), N'Nautica', N'Men', N'Sweaters', N'Striped Cardigan', N'L', 28.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'557828', Inventory.SetDateEntered(-4), N'Coach', N'Women', N'Handbags', N'Sunset Junction Patchwork Convertible Tote Bag', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'452660', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Men', N'Jackets', N'Two-Button Linen Jacket', N'38 Regular', 174.75), " +
" (N'867427', Inventory.SetDateEntered(-4), N'Lauren by Ralph Lauren', N'Men', N'Jackets', N'Two-Button Linen Jacket', N'38R', 174.75), " +
" (N'135445', Inventory.SetDateEntered(-4), N'CK Calvin Klein', N'Men', N'Suits', N'Two-Piece Slim Fit Suit', N'41', 205), " +
" (N'245443', Inventory.SetDateEntered(-4), N'CK Calvin Klein', N'Men', N'Suits', N'Two-Piece Slim Fit Suit', N'42', 205), " +
" (N'599176', Inventory.SetDateEntered(-4), N'CK Calvin Klein', N'Men', N'Suits', N'Two-Piece Slim Fit Suit', N'44', 205); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'769121', Inventory.SetDateEntered(-4), N'Women', N'Accessories', N'Two-Tone Scarf', 44.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'267518', Inventory.SetDateEntered(-5), N'Kenneth Cole New York', N'Men', N'Suits', N'2-Button Solid Wool Suit', N'42 Short', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'753306', Inventory.SetDateEntered(-5), N'Accessories', N'Automatic Umbrella', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'455838', Inventory.SetDateEntered(-5), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Candy Romper', N'024M', 6.75), " +
" (N'523481', Inventory.SetDateEntered(-5), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Candy Romper', N'012M', 6.75), " +
" (N'796795', Inventory.SetDateEntered(-5), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Candy Romper', N'018M', 6.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'283562', Inventory.SetDateEntered(-5), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Down Snowsuit', N'12M', 150), " +
" (N'284371', Inventory.SetDateEntered(-5), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Down Snowsuit', N'9M', 150), " +
" (N'483255', Inventory.SetDateEntered(-5), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Down Snowsuit', N'24M', 150), " +
" (N'656866', Inventory.SetDateEntered(-5), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Down Snowsuit', N'9M', 150), " +
" (N'128078', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Chain Hip Belt', N'3', 65), " +
" (N'145694', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Chain Hip Belt', N'4', 65), " +
" (N'177581', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Chain Hip Belt', N'5', 65), " +
" (N'686380', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Chain Hip Belt', N'1', 65), " +
" (N'987616', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Chain Hip Belt', N'2', 65), " +
" (N'276476', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Cutout-Detail Scalloped Belt', N'Small', 54.45), " +
" (N'515449', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Cutout-Detail Scalloped Belt', N'Large', 54.45), " +
" (N'757452', Inventory.SetDateEntered(-5), N'Collentra Studio', N'Women', N'Belts', N'Cutout-Detail Scalloped Belt', N'Medium', 54.45), " +
" (N'473023', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'6', 165), " +
" (N'475759', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'2', 165), " +
" (N'721905', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'10', 165), " +
" (N'842823', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'8', 165), " +
" (N'957257', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'4', 165), " +
" (N'997115', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Jackets', N'Drape Front Jacket', N'10', 165), " +
" (N'123385', Inventory.SetDateEntered(-5), N'CK Calvin Klein', N'Women', N'Dresses', N'Fitted Tunic Dress', N'Small', 135), " +
" (N'262772', Inventory.SetDateEntered(-5), N'CK Calvin Klein', N'Women', N'Dresses', N'Fitted Tunic Dress', N'Medium', 135), " +
" (N'709826', Inventory.SetDateEntered(-5), N'CK Calvin Klein', N'Women', N'Dresses', N'Fitted Tunic Dress', N'X-Small', 135), " +
" (N'898545', Inventory.SetDateEntered(-5), N'CK Calvin Klein', N'Women', N'Dresses', N'Fitted Tunic Dress', N'Large', 135); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'747333', Inventory.SetDateEntered(-5), N'Accessories', N'GOlf Umbrella', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'169903', Inventory.SetDateEntered(-5), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'Pinstriped Two-Piece Wool Suit', N'40R', 212), " +
" (N'245403', Inventory.SetDateEntered(-5), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'Pinstriped Two-Piece Wool Suit', N'40L', 212); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'991450', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Accessories', N'Plastic Square Sunglasses', 65); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'277542', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Dresses', N'Rumor Blocked Lace Sheath Dress', N'6', 235), " +
" (N'420993', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Dresses', N'Rumor Blocked Lace Sheath Dress', N'2', 235), " +
" (N'519235', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Dresses', N'Rumor Blocked Lace Sheath Dress', N'4', 235), " +
" (N'719324', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Dresses', N'Rumor Blocked Lace Sheath Dress', N'10', 235), " +
" (N'918680', Inventory.SetDateEntered(-5), N'Anne Klein', N'Women', N'Dresses', N'Rumor Blocked Lace Sheath Dress', N'8', 235), " +
" (N'815063', Inventory.SetDateEntered(-5), N'Nautica', N'Women', N'Shirts', N'Short-Sleeved Pima Cotton V-Neck Tee', N'S', 10), " +
" (N'840633', Inventory.SetDateEntered(-5), N'Nautica', N'Women', N'Shirts', N'Short-Sleeved Pima Cotton V-Neck Tee', N'M', 10), " +
" (N'338356', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Belts', N'Stretch Wide Belt', N'Small/Medium', 35), " +
" (N'504277', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Belts', N'Stretch Wide Belt', N'Medium/Large', 35), " +
" (N'609796', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Belts', N'Stretch Wide Belt', N'Large/X-Large', 35), " +
" (N'304329', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Dresses', N'Striped Dress', N'Medium', 265), " +
" (N'554750', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Dresses', N'Striped Dress', N'Small', 265), " +
" (N'598990', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Dresses', N'Striped Dress', N'Large', 265), " +
" (N'989518', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Dresses', N'Striped Dress', N'X-Small', 265), " +
" (N'438405', Inventory.SetDateEntered(-5), N'Kenneth Cole New York', N'Women', N'Jackets', N'Three-Pocket Suit Jacket', N'Medium', 50); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'852451', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Accessories', N'Tortoise Shell Sunglasses', 80); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'473252', Inventory.SetDateEntered(-5), N'Accessories', N'Travel Umbrella', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'126308', Inventory.SetDateEntered(-5), N'Calvin Klein', N'Women', N'Jackets', N'Tropical Wool Two-Button Jacket', N'2', 228); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'629118', Inventory.SetDateEntered(-6), N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 52.5), " +
" (N'762384', Inventory.SetDateEntered(-6), N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 49.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'350920', Inventory.SetDateEntered(-6), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Navy Floral Jumper Set', N'24M', 28.85), " +
" (N'875219', Inventory.SetDateEntered(-6), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Navy Floral Jumper Set', N'18M', 28.85), " +
" (N'877299', Inventory.SetDateEntered(-6), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Navy Floral Jumper Set', N'12M', 28.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'249966', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'44 Short', 100), " +
" (N'259788', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'40 Short', 100), " +
" (N'282562', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'44 Long', 100), " +
" (N'325346', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'42R', 100), " +
" (N'757808', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'36R', 100), " +
" (N'767749', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'46R', 100), " +
" (N'126600', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'42S', 105), " +
" (N'348415', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'44S', 105), " +
" (N'356309', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'40S', 105), " +
" (N'660463', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'36R', 105), " +
" (N'943507', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'42R', 105), " +
" (N'900221', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Men', N'Suits', N'Black Striped 2-Button Suit Jacket', N'44L', 105), " +
" (N'378289', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Dresses', N'Cambrey Sheath Dress', N'6', 225), " +
" (N'786602', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Dresses', N'Cambrey Sheath Dress', N'0', 225), " +
" (N'929280', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Dresses', N'Cambrey Sheath Dress', N'4', 225), " +
" (N'977260', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Dresses', N'Cambrey Sheath Dress', N'2', 225), " +
" (N'330816', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Shoes', N'Claw Buckle-Detail Wedge Sandals', N'2', 69.95), " +
" (N'388729', Inventory.SetDateEntered(-6), N'AK Anne Klein', N'Women', N'Shoes', N'Claw Buckle-Detail Wedge Sandals', N'5', 69.95), " +
" (N'621663', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Women', N'Sweaters', N'Petite Cotton Short Sleeve Crew Cardigan', N'S', 9.95), " +
" (N'781622', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Women', N'Sweaters', N'Petite Cotton Short Sleeve Crew Cardigan', N'L', 9.95), " +
" (N'803816', Inventory.SetDateEntered(-6), N'Calvin Klein', N'Women', N'Sweaters', N'Petite Cotton Short Sleeve Crew Cardigan', N'M', 9.95), " +
" (N'692393', Inventory.SetDateEntered(-6), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Knit Tank Top', N'M', 22.25), " +
" (N'734677', Inventory.SetDateEntered(-6), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Knit Tank Top', N'XS', 22.25), " +
" (N'828500', Inventory.SetDateEntered(-6), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Knit Tank Top', N'S', 22.25), " +
" (N'327027', Inventory.SetDateEntered(-6), N'Anne Klein', N'Women', N'Skirts', N'Petites Striped Skirt', N'XS', 24.45), " +
" (N'488241', Inventory.SetDateEntered(-6), N'Anne Klein', N'Women', N'Skirts', N'Petites Striped Skirt', N'M', 24.45), " +
" (N'623746', Inventory.SetDateEntered(-6), N'Anne Klein', N'Women', N'Skirts', N'Petites Striped Skirt', N'S', 24.45), " +
" (N'721532', Inventory.SetDateEntered(-6), N'Anne Klein', N'Women', N'Skirts', N'Petites Striped Skirt', N'L', 24.45), " +
" (N'158318', Inventory.SetDateEntered(-6), N'Nautica', N'Women', N'Shirts', N'Petites Watercolor Floral V-Neck Top', N'2', 9.5), " +
" (N'163906', Inventory.SetDateEntered(-6), N'Nautica', N'Women', N'Shirts', N'Petites Watercolor Floral V-Neck Top', N'3', 9.5), " +
" (N'226512', Inventory.SetDateEntered(-6), N'Nautica', N'Women', N'Shirts', N'Petites Watercolor Floral V-Neck Top', N'1', 9.5), " +
" (N'683324', Inventory.SetDateEntered(-6), N'Nautica', N'Women', N'Shirts', N'Petites Watercolor Floral V-Neck Top', N'4', 9.5), " +
" (N'921434', Inventory.SetDateEntered(-6), N'Nautica', N'Women', N'Shirts', N'Petites Watercolor Floral V-Neck Top', N'5', 9.5), " +
" (N'401532', Inventory.SetDateEntered(-6), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'Two-Button Glen Plaid Wool Suit', N'42 Short', 298.85), " +
" (N'185327', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Baby Oxford Shirtdress', N'12M', 44.95), " +
" (N'679032', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Baby Oxford Shirtdress', N'18M', 44.95), " +
" (N'773524', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Baby Oxford Shirtdress', N'9M', 44.95), " +
" (N'810187', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Baby Oxford Shirtdress', N'24M', 44.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'432634', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink and Brown Elephant 2-Piece Pajama Set', N'18M', 17.75), " +
" (N'842236', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink and Brown Elephant 2-Piece Pajama Set', N'24M', 17.75), " +
" (N'228820', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink & Grey Plaid Jumper Set', N'12M', 28.85), " +
" (N'553185', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink & Grey Plaid Jumper Set', N'24M', 28.85), " +
" (N'804053', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink & Grey Plaid Jumper Set', N'18M', 28.85), " +
" (N'528749', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink Ballet Shoes 2-Piece Pajama Set', N'24M', 17.25), " +
" (N'645605', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink Ballet Shoes 2-Piece Pajama Set', N'12M', 17.25), " +
" (N'857139', Inventory.SetDateEntered(-7), N'Anne Klein', N'Baby Girls', N'Baby Girls 12-24 Months Pink Ballet Shoes 2-Piece Pajama Set', N'18M', 17.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'428582', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 2-in-1 Graphic T-Shirt', N'6', 28.75), " +
" (N'506467', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 2-in-1 Graphic T-Shirt', N'5', 28.75), " +
" (N'588557', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 2-in-1 Graphic T-Shirt', N'7', 28.75), " +
" (N'850118', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 2-in-1 Graphic T-Shirt', N'4', 28.75), " +
" (N'407726', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'5', 45), " +
" (N'513346', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'3/3T ', 45), " +
" (N'555764', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'2/2T ', 45), " +
" (N'629691', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'7', 45), " +
" (N'647791', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'4', 45), " +
" (N'954521', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Colorblock Polo', N'6', 45), " +
" (N'455993', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Cotton Mesh Polo', N'6', 39.5), " +
" (N'496773', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Cotton Mesh Polo', N'5', 39.5), " +
" (N'819817', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Cotton Mesh Polo', N'4', 39.5), " +
" (N'143470', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Mesh Polo', N'5', 45), " +
" (N'504004', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Mesh Polo', N'4', 45), " +
" (N'598655', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Mesh Polo', N'6', 45), " +
" (N'706425', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Mesh Polo', N'3/3T ', 45), " +
" (N'982996', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Big Pony Mesh Polo', N'2/2T ', 45), " +
" (N'100043', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Blake Oxford Shirt', N'5', 40), " +
" (N'186154', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Blake Oxford Shirt', N'6', 40), " +
" (N'421386', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Blake Oxford Shirt', N'4', 40), " +
" (N'594222', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Blake Oxford Shirt', N'2/2T ', 40), " +
" (N'842051', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Blake Oxford Shirt', N'3/3T ', 40), " +
" (N'316760', Inventory.SetDateEntered(-7), N'Nautica', N'Boys', N'Sweaters', N'Boys 2-7 Cashmere Cable V-neck Sweater', N'6/7', 145), " +
" (N'570810', Inventory.SetDateEntered(-7), N'Nautica', N'Boys', N'Sweaters', N'Boys 2-7 Cashmere Cable V-neck Sweater', N'2T/3T', 145), " +
" (N'886218', Inventory.SetDateEntered(-7), N'Nautica', N'Boys', N'Sweaters', N'Boys 2-7 Cashmere Cable V-neck Sweater', N'4', 145), " +
" (N'473177', Inventory.SetDateEntered(-7), N'Polo Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Layered Sleeve T-Shirt', N'L', 32.5), " +
" (N'817354', Inventory.SetDateEntered(-7), N'Polo Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Layered Sleeve T-Shirt', N'M', 32.5), " +
" (N'886762', Inventory.SetDateEntered(-7), N'Polo Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Layered Sleeve T-Shirt', N'M', 32.5), " +
" (N'298014', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Mesh Polo', N'3/3T', 39.85), " +
" (N'321646', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Shirt', N'3/3T ', 44.95), " +
" (N'439395', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Shirt', N'4', 44.95), " +
" (N'702751', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Shirt', N'2/2T ', 44.95), " +
" (N'841436', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Shirt', N'6', 44.95), " +
" (N'907677', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Long-Sleeved Shirt', N'5', 44.95), " +
" (N'210053', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Short-Sleeved Mesh Polo', N'2/2T ', 34.95), " +
" (N'226140', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Short-Sleeved Mesh Polo', N'3/3T ', 34.95), " +
" (N'418665', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Short-Sleeved Mesh Polo', N'6', 34.95), " +
" (N'454776', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Short-Sleeved Mesh Polo', N'4', 34.95), " +
" (N'492386', Inventory.SetDateEntered(-7), N'Ralph Lauren', N'Boys', N'Shirts', N'Boys 2-7 Short-Sleeved Mesh Polo', N'5', 34.95), " +
" (N'314538', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Boys', N'Suits', N'Boys 2-7 Two-Button Suit', N'14', 175), " +
" (N'203575', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Caribbean Slide Sandals', N'6.5M', 32.5), " +
" (N'461541', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Caribbean Slide Sandals', N'8M', 32.5), " +
" (N'513648', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Caribbean Slide Sandals', N'8.5M', 32.5), " +
" (N'578303', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Caribbean Slide Sandals', N'7.5M', 32.5), " +
" (N'704618', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Caribbean Slide Sandals', N'6M', 32.5), " +
" (N'642642', Inventory.SetDateEntered(-7), N'Calvin Klein', N'Women', N'Shoes', N'Gigi T-Strap Leather Sandals', N'8M', 64.95), " +
" (N'724428', Inventory.SetDateEntered(-7), N'Calvin Klein', N'Women', N'Shoes', N'Gigi T-Strap Leather Sandals', N'8.5M', 64.95), " +
" (N'788789', Inventory.SetDateEntered(-7), N'Calvin Klein', N'Women', N'Shoes', N'Gigi T-Strap Leather Sandals', N'7.5M', 64.95), " +
" (N'357652', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'7 Medium', 124.5), " +
" (N'716921', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'9 Medium', 124.5), " +
" (N'718325', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'8.5 Medium', 124.5), " +
" (N'722877', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'7.5 Medium', 124.5), " +
" (N'922923', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'6.5 Medium', 124.5), " +
" (N'986872', Inventory.SetDateEntered(-7), N'AK Anne Klein', N'Women', N'Shoes', N'Golum Slide Sandals', N'8 Medium', 124.5), " +
" (N'650598', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Beaded Tank Top', N'S', 12.25), " +
" (N'898269', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Beaded Tank Top', N'L', 12.25), " +
" (N'935139', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Beaded Tank Top', N'M', 12.25), " +
" (N'350851', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'6', 9.5), " +
" (N'396726', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'4', 9.5), " +
" (N'567401', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'5', 9.5), " +
" (N'791038', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'1', 9.5), " +
" (N'876893', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'2', 9.5), " +
" (N'886001', Inventory.SetDateEntered(-7), N'Kenneth Cole', N'Women', N'Shirts', N'Petites Sleeveless Shell', N'3', 9.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'160318', Inventory.SetDateEntered(-7), N'Nautica', N'Women', N'Petites Striped Open-Front Shrug', N'L', 28.25), " +
" (N'300518', Inventory.SetDateEntered(-7), N'Nautica', N'Women', N'Petites Striped Open-Front Shrug', N'S', 28.25), " +
" (N'780673', Inventory.SetDateEntered(-7), N'Nautica', N'Women', N'Petites Striped Open-Front Shrug', N'M', 28.25), " +
" (N'953310', Inventory.SetDateEntered(-7), N'Nautica', N'Women', N'Petites Striped Open-Front Shrug', N'XS', 28.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'640280', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Printed Jersey Dress', N'4', 135.95), " +
" (N'489530', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Roll-Sleeve Belted Cotton Henley Dress', N'Medium', 95.95), " +
" (N'610991', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Roll-Sleeve Belted Cotton Henley Dress', N'Medium', 95.95), " +
" (N'794899', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Roll-Sleeve Belted Cotton Henley Dress', N'X-Large', 95.95), " +
" (N'813884', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Roll-Sleeve Belted Cotton Henley Dress', N'Small', 95.95), " +
" (N'853335', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Roll-Sleeve Belted Cotton Henley Dress', N'Large', 95.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'986228', Inventory.SetDateEntered(-7), N'Men', N'Accessories', N'Safari Sunglasses', 124.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'453418', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Suede Sheath Dress', N'Small', 395), " +
" (N'573063', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Suede Sheath Dress', N'Large', 395), " +
" (N'836662', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Suede Sheath Dress', N'Medium', 395), " +
" (N'909005', Inventory.SetDateEntered(-7), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Suede Sheath Dress', N'X-Large', 395), " +
" (N'242783', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'46R', 105), " +
" (N'255998', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'48LR', 105), " +
" (N'294091', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'46L', 105), " +
" (N'359125', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'44L', 105), " +
" (N'425384', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'48L', 105), " +
" (N'478538', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'42R', 105), " +
" (N'513112', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'40L', 105), " +
" (N'611890', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'38S', 105), " +
" (N'653455', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'43R', 105), " +
" (N'776282', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'41R', 105), " +
" (N'781716', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'44R', 105), " +
" (N'880507', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'42L', 105), " +
" (N'916941', Inventory.SetDateEntered(-7), N'Anne Klein', N'Men', N'Jackets', N'Two-Button Zip Pocket Suit Jacket', N'38R', 105), " +
" (N'192882', Inventory.SetDateEntered(-7), N'Juaro Collections', N'Women', N'Belts', N'Two-Tone Belt', N'2', 45), " +
" (N'587732', Inventory.SetDateEntered(-7), N'Juaro Collections', N'Women', N'Belts', N'Two-Tone Belt', N'3', 45), " +
" (N'748810', Inventory.SetDateEntered(-7), N'Juaro Collections', N'Women', N'Belts', N'Two-Tone Belt', N'5', 45), " +
" (N'851249', Inventory.SetDateEntered(-7), N'Juaro Collections', N'Women', N'Belts', N'Two-Tone Belt', N'4', 45), " +
" (N'873099', Inventory.SetDateEntered(-7), N'Juaro Collections', N'Women', N'Belts', N'Two-Tone Belt', N'1', 45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'126638', Inventory.SetDateEntered(-8), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months One-Shoulder Romper', N'18M', 17.75), " +
" (N'506022', Inventory.SetDateEntered(-8), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months One-Shoulder Romper', N'24M', 17.75), " +
" (N'556121', Inventory.SetDateEntered(-8), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months One-Shoulder Romper', N'12M', 17.75), " +
" (N'699297', Inventory.SetDateEntered(-8), N'CK Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Two-Piece Set', N'24M', 28.85), " +
" (N'850858', Inventory.SetDateEntered(-8), N'CK Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Two-Piece Set', N'18M', 28.85), " +
" (N'927813', Inventory.SetDateEntered(-8), N'CK Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Two-Piece Set', N'12M', 28.85), " +
" (N'282013', Inventory.SetDateEntered(-8), N'Calvin Klein', N'Baby Girls', N'Baby Girls Print Tank Dress and Leggings', N'18 Months', 15.75), " +
" (N'416110', Inventory.SetDateEntered(-8), N'Calvin Klein', N'Baby Girls', N'Baby Girls Print Tank Dress and Leggings', N'24 Months', 15.75), " +
" (N'432014', Inventory.SetDateEntered(-8), N'Calvin Klein', N'Baby Girls', N'Baby Girls Print Tank Dress and Leggings', N'12 Months', 15.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'756291', Inventory.SetDateEntered(-8), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'4', 115), " +
" (N'855253', Inventory.SetDateEntered(-8), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'10', 115), " +
" (N'981164', Inventory.SetDateEntered(-8), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'6', 115); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'591933', Inventory.SetDateEntered(-8), N'Men', N'Textured Striped Silk Tie', 69.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'430669', Inventory.SetDateEntered( -9), N'Kenneth Cole New York', N'Women', N'Jewelry', N'Goldtone Beaded Double-Drop Earrings', N'No Size', 26.95), " +
" (N'110936', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Skirts', N'Polished Cotton Marina Skirt', N'4', 79.95), " +
" (N'135439', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'14', 150), " +
" (N'158043', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'4', 150), " +
" (N'333982', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'6', 150), " +
" (N'618142', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'12', 150), " +
" (N'709459', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'8', 150), " +
" (N'861511', Inventory.SetDateEntered( -9), N'Calvin Klein', N'Women', N'Dresses', N'Red Crochet Shift Dress', N'10', 150), " +
" (N'251866', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'M', 71), " +
" (N'605332', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'L', 74), " +
" (N'541013', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'S', 70), " +
" (N'542784', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'XL', 75), " +
" (N'689032', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'L', 72), " +
" (N'931831', Inventory.SetDateEntered( -9), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeve Pique Polo Shirt', N'M', 73), " +
" (N'374208', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Baby Girls', N'Sweaters', N'Baby Girls 12-24 Months Pointelle Cardigan', N'24M', 34.50), " +
" (N'558837', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Baby Girls', N'Sweaters', N'Baby Girls 12-24 Months Pointelle Cardigan', N'18M', 34.50), " +
" (N'697618', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Baby Girls', N'Sweaters', N'Baby Girls 12-24 Months Pointelle Cardigan', N'12M', 34.50), " +
" (N'908652', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Baby Girls', N'Sweaters', N'Baby Girls 12-24 Months Pointelle Cardigan', N'9M', 34.50), " +
" (N'245528', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Jersey Shirt', N'M', 94), " +
" (N'387936', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Jersey Shirt', N'K', 94), " +
" (N'603243', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Jersey Shirt', N'S', 94), " +
" (N'677382', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Jersey Shirt', N'K', 94), " +
" (N'679340', Inventory.SetDateEntered(-10), N'Kenneth Cole Reaction', N'Women', N'Coats', N'Double Breasted Peacoat', N'8', 260); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'347004', Inventory.SetDateEntered(-10), N'Ralph Lauren', N'Girls', N'Shoes', N'Double Buckle Leather Booties', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'396795', Inventory.SetDateEntered(-10), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Tweed Peacoat', N'4', 260); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'195641', Inventory.SetDateEntered(-10), N'Giorgio Armani', N'Men', N'Watches', N'Eco-Drive Stainless-Steel Atomic Chronograph Watch', 694.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'137900', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Faux-Suede Buckle Dress', N'L', 175), " +
" (N'284298', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Faux-Suede Buckle Dress', N'S', 175), " +
" (N'418887', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Faux-Suede Buckle Dress', N'XL', 175), " +
" (N'821333', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Faux-Suede Buckle Dress', N'M', 175), " +
" (N'972117', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Faux-Suede Buckle Dress', N'XS', 175); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'867184', Inventory.SetDateEntered(-10), N'AK Anne Klein', N'Women', N'Shoes', N'Flip-Flop Leather Sandals', 39.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'421589', Inventory.SetDateEntered(-10), N'Guess', N'Girls', N'Girls 2-6X Gingerbread Pajama Set', N'2T', 32.50), " +
" (N'479291', Inventory.SetDateEntered(-10), N'Guess', N'Girls', N'Girls 2-6X Gingerbread Pajama Set', N'3T', 32.50), " +
" (N'741526', Inventory.SetDateEntered(-10), N'Guess', N'Girls', N'Girls 2-6X Gingerbread Pajama Set', N'4T', 32.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, UnitPrice) " +
"VALUES(N'746827', Inventory.SetDateEntered(-10), N'Collentra Studio', N'Women', N'Oyster Long Satin Nightgown', 72.55); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'738746', Inventory.SetDateEntered(-10), N'CK Calvin Klein', N'Men', N'Shirts', N'Plaid Dress Shirt', N'15 32-33', 65.95), " +
" (N'114808', Inventory.SetDateEntered(-10), N'Anne Klein', N'Women', N'Dresses', N'Printed V-Neck Maxi Dress', N'S', 145), " +
" (N'152942', Inventory.SetDateEntered(-10), N'Anne Klein', N'Women', N'Dresses', N'Printed V-Neck Maxi Dress', N'L', 145), " +
" (N'213360', Inventory.SetDateEntered(-10), N'Anne Klein', N'Women', N'Dresses', N'Printed V-Neck Maxi Dress', N'XS', 145), " +
" (N'463706', Inventory.SetDateEntered(-10), N'Anne Klein', N'Women', N'Dresses', N'Printed V-Neck Maxi Dress', N'M', 145); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'272708', Inventory.SetDateEntered(-10), N'Men', N'Rectangle Sunglasses', 38.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'456906', Inventory.SetDateEntered(-10), N'CK Calvin Klein', N'Men', N'Shirts', N'Regular-Fit Striped Dress Shirt', N'16 32 33', 65.5), " +
" (N'667262', Inventory.SetDateEntered(-10), N'CK Calvin Klein', N'Men', N'Shirts', N'Regular-Fit Striped Dress Shirt', N'17 32/33', 65.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'712567', Inventory.SetDateEntered(-10), N'Timex', N'Men', N'Watches', N'Rose Gold & Leather Watch', 295); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'784469', Inventory.SetDateEntered(-10), N'Men', N'Shield Sunglasses', 38.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'258229', Inventory.SetDateEntered(-10), N'Kenneth Cole Reaction', N'Women', N'Dresses', N'Short-Split-Sleeve Belted Blouson', N'S', 95.95), " +
" (N'418034', Inventory.SetDateEntered(-10), N'Kenneth Cole Reaction', N'Women', N'Dresses', N'Short-Split-Sleeve Belted Blouson', N'XS', 95.95), " +
" (N'622272', Inventory.SetDateEntered(-10), N'Kenneth Cole Reaction', N'Women', N'Dresses', N'Short-Split-Sleeve Belted Blouson', N'M', 95.95), " +
" (N'911553', Inventory.SetDateEntered(-10), N'Kenneth Cole Reaction', N'Women', N'Dresses', N'Short-Split-Sleeve Belted Blouson', N'L', 95.95), " +
" (N'722378', Inventory.SetDateEntered(-10), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Side-Knot Xanders Dress', N'10', 150), " +
" (N'112452', Inventory.SetDateEntered(-10), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'14', 188.85), " +
" (N'482765', Inventory.SetDateEntered(-10), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'10', 188.85), " +
" (N'537973', Inventory.SetDateEntered(-10), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'12', 188.85), " +
" (N'608798', Inventory.SetDateEntered(-10), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'4', 188.85), " +
" (N'548239', Inventory.SetDateEntered(-10), N'Calvin Klein', N'Women', N'Shoes', N'Textured Suede Dress Pumps', N'10', 110); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'510040', Inventory.SetDateEntered(-10), N'Cole Haan', N'Women', N'Handbags', N'Victoria Zip-Top Tote Bag', 298), " +
" (N'562061', Inventory.SetDateEntered(-10), N'Cole Haan', N'Women', N'Handbags', N'Victoria Zip-Top Tote Bag', 298); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'156474', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Vintage Polo Shirt', N'XL', 45.50), " +
" (N'297787', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Vintage Polo Shirt', N'M', 45.50), " +
" (N'462377', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Vintage Polo Shirt', N'XXL', 45.50), " +
" (N'745387', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Vintage Polo Shirt', N'S', 45.50), " +
" (N'917203', Inventory.SetDateEntered(-10), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Vintage Polo Shirt', N'L', 45.50), " +
" (N'205793', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'0', 105), " +
" (N'243080', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'8', 105), " +
" (N'483441', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'4', 105), " +
" (N'657367', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'2', 105), " +
" (N'777331', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'10', 105), " +
" (N'860600', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'6', 105), " +
" (N'950637', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Skirts', N'A-Line Midi Skirt', N'12', 105), " +
" (N'198121', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'Aysmmetrical Printed Overlay Skirt', N'XS', 75), " +
" (N'568939', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'Aysmmetrical Printed Overlay Skirt', N'M', 75), " +
" (N'876166', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'Aysmmetrical Printed Overlay Skirt', N'S', 75), " +
" (N'584293', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'Aysmmetrical Printed Overlay Skirt', N'L', 75), " +
" (N'206991', Inventory.SetDateEntered(-11), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Fleece Jacket & Pants Set', N'9M', 54.95), " +
" (N'376095', Inventory.SetDateEntered(-11), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Fleece Jacket & Pants Set', N'12M', 50), " +
" (N'681184', Inventory.SetDateEntered(-11), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Fleece Jacket & Pants Set', N'24M', 54.95), " +
" (N'869607', Inventory.SetDateEntered(-11), N'Ralph Lauren', N'Baby Girls', N'Suits', N'Baby Girls 12-24 Months Fleece Jacket & Pants Set', N'12M', 54.95), " +
" (N'119351', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Shoes', N'Bow Wedge Sandals', N'8M', 34.95), " +
" (N'365592', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Shoes', N'Bow Wedge Sandals', N'6M', 34.95), " +
" (N'395609', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Shoes', N'Bow Wedge Sandals', N'6.5M', 34.95), " +
" (N'787149', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Shoes', N'Bow Wedge Sandals', N'7.5M', 34.95), " +
" (N'819639', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Shoes', N'Bow Wedge Sandals', N'7M', 34.95), " +
" (N'235001', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Printed Sheath Dress', N'10', 95.95), " +
" (N'467287', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Printed Sheath Dress', N'6', 95.95), " +
" (N'586528', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Printed Sheath Dress', N'4', 95.95), " +
" (N'990427', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Printed Sheath Dress', N'8', 95.95), " +
" (N'672414', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'L', 85), " +
" (N'755636', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'XL', 85), " +
" (N'761117', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'M', 85), " +
" (N'987830', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'XXL', 85), " +
" (N'314610', Inventory.SetDateEntered(-11), N'AK Anne Klein', N'Women', N'Dresses', N'Contrast Sleeve Shift Dress', N'L', 115), " +
" (N'379706', Inventory.SetDateEntered(-11), N'AK Anne Klein', N'Women', N'Dresses', N'Contrast Sleeve Shift Dress', N'M', 115), " +
" (N'675265', Inventory.SetDateEntered(-11), N'AK Anne Klein', N'Women', N'Dresses', N'Contrast Sleeve Shift Dress', N'XL', 115), " +
" (N'694453', Inventory.SetDateEntered(-11), N'AK Anne Klein', N'Women', N'Dresses', N'Contrast Sleeve Shift Dress', N'S', 115), " +
" (N'772981', Inventory.SetDateEntered(-11), N'AK Anne Klein', N'Women', N'Dresses', N'Contrast Sleeve Shift Dress', N'XS', 115), " +
" (N'128411', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'4', 145), " +
" (N'163357', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'8', 145), " +
" (N'309813', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'10', 145), " +
" (N'337824', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'2', 145), " +
" (N'522383', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'3', 145), " +
" (N'768308', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'6', 145), " +
" (N'831531', Inventory.SetDateEntered(-11), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Sateen Workshirt Dress', N'5', 145); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'622310', Inventory.SetDateEntered(-11), N'Ralph Lauren', N'Men', N'Beauty and Grooming', N'Light Blue Pour Homme 4.2 oz. Eau de Toilette', 72.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'762805', Inventory.SetDateEntered(-11), N'CK Calvin Klein', N'Men', N'Shirts', N'Non-Iron Dress Shirt', N'17.5 32/33', 79.5), " +
" (N'706052', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Jackets', N'Open-Front Jacket', N'XS', 65), " +
" (N'629617', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Jackets', N'Open-Front Jacket', N'S', 65), " +
" (N'927756', Inventory.SetDateEntered(-11), N'Anne Klein', N'Women', N'Jackets', N'Open-Front Jacket', N'M', 65), " +
" (N'107615', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'L', 29.95), " +
" (N'328249', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'L', 29.95), " +
" (N'630729', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'M', 29.95), " +
" (N'724377', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'S', 29.95), " +
" (N'729705', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'M', 29.95), " +
" (N'837976', Inventory.SetDateEntered(-11), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Knit Polo', N'M', 29.95), " +
" (N'181438', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'15.969696969697', 32.50), " +
" (N'204683', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'15.5 34/35', 32.50), " +
" (N'208408', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16.5 32/33', 47.75), " +
" (N'238673', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'15.5 32/33', 32.50), " +
" (N'251907', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'15 34/35', 32.50), " +
" (N'293520', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'14.5 32/33', 32.50), " +
" (N'353571', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16.5 32/33', 32.50), " +
" (N'401316', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16 34/35', 32.50), " +
" (N'424169', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17 34/35', 32.50), " +
" (N'460846', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 36/37', 32.50), " +
" (N'568858', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 34/35', 32.50), " +
" (N'596937', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17 32/33', 32.50), " +
" (N'680806', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16 32/33', 32.50), " +
" (N'885607', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 32/33', 32.50), " +
" (N'248084', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16.9714285714286', 47.75), " +
" (N'374685', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 34/35', 47.75), " +
" (N'583758', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'18.9714285714286', 47.75), " +
" (N'749574', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16 32/33', 47.75), " +
" (N'804206', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'16.5 34/35', 47.75), " +
" (N'826846', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 36/37', 47.75), " +
" (N'847968', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.969696969697', 47.75), " +
" (N'924957', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'18.972972972973', 47.75), " +
" (N'929483', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.5 32/33', 47.75), " +
" (N'929735', Inventory.SetDateEntered(-11), N'Tommy Hilfiger', N'Men', N'Shirts', N'Texture Oxford Slim Fit Long Sleeve Dress Shirt', N'17.972972972973', 47.75), " +
" (N'293481', Inventory.SetDateEntered(-12), N'Polo Ralph Lauren', N'Men', N'Shirts', N'2-Button Polo', N'M', 25), " +
" (N'615923', Inventory.SetDateEntered(-12), N'Polo Ralph Lauren', N'Men', N'Shirts', N'2-Button Polo', N'L', 25), " +
" (N'667032', Inventory.SetDateEntered(-12), N'Polo Ralph Lauren', N'Men', N'Shirts', N'2-Button Polo', N'XL', 25), " +
" (N'713817', Inventory.SetDateEntered(-12), N'Polo Ralph Lauren', N'Men', N'Shirts', N'2-Button Polo', N'S', 25), " +
" (N'961977', Inventory.SetDateEntered(-12), N'Nautica', N'Men', N'Shoes', N'Air Colton Venetian Loafers', N'8 M', 198.85), " +
" (N'638559', Inventory.SetDateEntered(-12), N'Citizen', N'Men', N'Shoes', N'Air Colton Venetian Loafers', N'10 W', 198.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'646371', Inventory.SetDateEntered(-12), N'Collentra Studio', N'Women', N'Handbags', N'City Chic Handbag', 348), " +
" (N'478135', Inventory.SetDateEntered(-12), N'Lacoste', N'Women', N'Beauty and Grooming', N'Cool Water 4.2 oz Eau De Toilette', 70), " +
" (N'230035', Inventory.SetDateEntered(-12), N'Coach', N'Women', N'Handbags', N'Crystal Snake-Embossed Shoulder Handbag', 125), " +
" (N'955183', Inventory.SetDateEntered(-12), N'AK Anne Klein', N'Women', N'Watches', N'Goldtone Mother-of-Pearl Dial Leather Watch', 55); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'458407', Inventory.SetDateEntered(-12), N'Women', N'Beauty and Grooming', N'Iris Men 1.7 oz. Eau de Toilette', 55.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'145172', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Knit Trim Belted Soft Shell', 95), " +
" (N'961105', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Knit Trim Belted Soft Shell', 120); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'395230', Inventory.SetDateEntered(-12), N'AK Anne Klein', N'Women', N'Watches', N'Ladies Purple Perforated Leather Watch', N'No Size', 55); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'690369', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Beauty and Grooming', N'Light Blue Pour Homme 4.2 oz. Eau de Toilette', 72.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'394729', Inventory.SetDateEntered(-12), N'Women', N'Jewelry', N'Long Pave Pearl Necklace', 88); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'985730', Inventory.SetDateEntered(-12), N'Women', N'Long Pave Pearl Necklace', 88); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'211915', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'L', 195), " +
" (N'611253', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'M', 195), " +
" (N'640958', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'S', 195), " +
" (N'905276', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'XL', 195), " +
" (N'973385', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'XS', 195); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'738651', Inventory.SetDateEntered(-12), N'Men', N'Beauty and Grooming', N'Man Eau De Toilette Natural Spray 2.0 oz.', 60); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'943309', Inventory.SetDateEntered(-12), N'Collentra Studio', N'Women', N'Belts', N'Perfect Skinny Calf Hair Belt', N'M', 44); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'603361', Inventory.SetDateEntered(-12), N'Collentra Studio', N'Women', N'Belts', N'Perfect Skinny Calf Hair Belt', 44); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'275929', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Skirts', N'Petite Crossing Paths Print Skirt', N'6', 120), " +
" (N'345500', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Skirts', N'Petite Crossing Paths Print Skirt', N'12', 120), " +
" (N'389290', Inventory.SetDateEntered(-12), N'Calvin Klein', N'Women', N'Skirts', N'Petite Crossing Paths Print Skirt', N'10', 120); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'848347', Inventory.SetDateEntered(-12), N'Nautica', N'Women', N'Sweaters', N'Petite Evening Stripe Sweater', 88); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'645623', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Women', N'Jackets', N'Petite Moulinee Tweed Femme Jacket', N'2', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'709256', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Beauty and Grooming', N'Polo Blue Vitamin Enriched After Shave Gel', 49.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'483825', Inventory.SetDateEntered(-12), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Printed Jersey Dress', N'6', 135.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'419138', Inventory.SetDateEntered(-12), N'Women', N'Protein RX Shampoo', 18.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'171365', Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Men', N'Ties', N'Silk Solid Tie - Black', 29.95), " +
" (N'226500', Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Men', N'Ties', N'Silk Solid Tie - Navy', 29.95), " +
" (N'974387', Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Men', N'Ties', N'Silk Solid Tie - Purple', 29.95), " +
" (N'426632', Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Men', N'Ties', N'Silk Solid Tie - Red', 29.95), " +
" (N'830225', Inventory.SetDateEntered(-12), N'CK Calvin Klein', N'Men', N'Ties', N'Silk Solid Tie - Silver', 29.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'390660', Inventory.SetDateEntered(-12), N'Women', N'Beauty and Grooming', N'Smooth Sailing Anti-Frizz Cream', 25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'254820', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Shirts', N'Two-Tone Polo Shirt', N'L', 20), " +
" (N'299249', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Shirts', N'Two-Tone Polo Shirt', N'L', 20), " +
" (N'413692', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Shirts', N'Two-Tone Polo Shirt', N'M', 20), " +
" (N'535445', Inventory.SetDateEntered(-12), N'Ralph Lauren', N'Men', N'Shirts', N'Two-Tone Polo Shirt', N'XL', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'739246', Inventory.SetDateEntered(-12), N'Men', N'Beauty and Grooming', N'Vintage 2.5 oz. Eau De Toilette', 60); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'277767', Inventory.SetDateEntered(-13), N'Anne Klein', N'Women', N'Dresses', N'Asymmetric Pleated Dress', N'8', 120), " +
" (N'342151', Inventory.SetDateEntered(-13), N'Anne Klein', N'Women', N'Dresses', N'Asymmetric Pleated Dress', N'6', 120), " +
" (N'346490', Inventory.SetDateEntered(-13), N'Anne Klein', N'Women', N'Dresses', N'Asymmetric Pleated Dress', N'10', 120), " +
" (N'605707', Inventory.SetDateEntered(-13), N'Anne Klein', N'Women', N'Dresses', N'Asymmetric Pleated Dress', N'4', 120), " +
" (N'663699', Inventory.SetDateEntered(-13), N'Kenneth Cole Reaction', N'Women', N'Shoes', N'Bluestreak Embellished Thong Sandals', N'6 1/2 M', 65), " +
" (N'548977', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Dress', N'12', 150), " +
" (N'770027', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Dress', N'14', 150), " +
" (N'783927', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Dress', N'16', 150), " +
" (N'330373', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Dress', N'L', 150), " +
" (N'406883', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Dress', N'S', 150), " +
" (N'800232', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Dress', N'XS', 150), " +
" (N'971689', Inventory.SetDateEntered(-13), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Dress', N'M', 150); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'117046', Inventory.SetDateEntered(-13), N'Tommy Hilfiger', N'Men', N'Beauty and Grooming', N'Code 1.7 oz. Eau de Toilette', 59.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'114632', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'4', 135), " +
" (N'133693', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'6', 135), " +
" (N'193032', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'6', 135), " +
" (N'219520', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'8', 135), " +
" (N'219754', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'10', 135), " +
" (N'266676', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'12', 135), " +
" (N'673488', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'8', 135), " +
" (N'809725', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'10', 135), " +
" (N'829016', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'2', 135), " +
" (N'977395', Inventory.SetDateEntered(-13), N'Calvin Klein', N'Women', N'Coats', N'Double-Breasted Peacoat', N'4', 135); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'970679', Inventory.SetDateEntered(-13), N'Seiko', N'Men', N'Beauty and Grooming', N'Essential After Shave Balm', 36.6), " +
" (N'436098', Inventory.SetDateEntered(-13), N'Ralph Lauren', N'Men', N'Beauty and Grooming', N'Polo 4 oz. Eau de Toilette', 75), " +
" (N'788627', Inventory.SetDateEntered(-13), N'Ralph Lauren', N'Men', N'Beauty and Grooming', N'Polo Blue Vitamin Enriched Alcohol-Free Deodorant', 18.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'467837', Inventory.SetDateEntered(-13), N'Women', N'Beauty and Grooming', N'Protein RX Conditioner', 28.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'222046', Inventory.SetDateEntered(-13), N'Juaro Collections', N'Women', N'Belts', N'Skinny Toggle Belt', N'Small', 75), " +
" (N'398306', Inventory.SetDateEntered(-13), N'Juaro Collections', N'Women', N'Belts', N'Skinny Toggle Belt', N'Large', 75), " +
" (N'420671', Inventory.SetDateEntered(-13), N'Juaro Collections', N'Women', N'Belts', N'Skinny Toggle Belt', N'Medium', 75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'702563', Inventory.SetDateEntered(-13), N'Men', N'Beauty and Grooming', N'Touch For Men 3.3 oz Eau De Toilette Spray', 75), " +
" (N'107005', Inventory.SetDateEntered(-14), N'Women', N'Beauty and Grooming', N'After Sun Daily Mask', 24.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'808625', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Coats', N'Argyle Vest', N'M', 59.95), " +
" (N'945038', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Coats', N'Argyle Vest', N'L', 59.95), " +
" (N'837485', Inventory.SetDateEntered(-14), N'Kenneth Cole Reaction', N'Women', N'Shoes', N'Bluestreak Embellished Thong Sandals', N'7 1/2 M', 65), " +
" (N'300507', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Men', N'Shoes', N'Bomber Jacket Classic Short Boots', N'8', 155.5), " +
" (N'366198', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Men', N'Shoes', N'Bomber Jacket Classic Short Boots', N'10', 155.5), " +
" (N'977312', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Men', N'Shoes', N'Bomber Jacket Classic Short Boots', N'9', 155.5), " +
" (N'135294', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Shirts', N'Buffalo Check Shirt', N'M', 75.55), " +
" (N'180349', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Shirts', N'Buffalo Check Shirt', N'L', 78.55), " +
" (N'439309', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Shirts', N'Buffalo Check Shirt', N'S', 78.55), " +
" (N'876591', Inventory.SetDateEntered(-14), N'Juaro Collections', N'Men', N'Shirts', N'Buffalo Check Shirt', N'XL', 78.55), " +
" (N'434951', Inventory.SetDateEntered(-14), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Sweaterdress', N'M', 345), " +
" (N'639170', Inventory.SetDateEntered(-14), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Sweaterdress', N'M', 345), " +
" (N'198013', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'XL', 92.95), " +
" (N'228793', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'L', 92.95), " +
" (N'410302', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'M', 92.95), " +
" (N'487247', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'S', 92.95), " +
" (N'529569', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'L', 92.95), " +
" (N'540439', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'XL', 92.95), " +
" (N'672966', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'M', 92.95), " +
" (N'906535', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'M', 92.95), " +
" (N'941346', Inventory.SetDateEntered(-14), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Striped Mesh Polo Shirt', N'L', 92.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'326481', Inventory.SetDateEntered(-14), N'Women', N'Accessories', N'Lace-Print Scarf', 110); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'271858', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'8.5', 75), " +
" (N'506711', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'9.5', 75), " +
" (N'585527', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'11', 75), " +
" (N'617994', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'11.5', 75), " +
" (N'622143', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'10.5', 75), " +
" (N'661022', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'10', 75), " +
" (N'739136', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'8', 75), " +
" (N'835939', Inventory.SetDateEntered(-14), N'Cole Haan', N'Men', N'Shoes', N'Navy A/O 2-Eye Leather Boat Shoe', N'9', 75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'560931', Inventory.SetDateEntered(-14), N'Lauren by Ralph Lauren', N'Women', N'Suits', N'Navy Peak-Lapel 1-Button Suits', 134.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'347064', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'8', 395), " +
" (N'583366', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'4', 395), " +
" (N'749786', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'2', 395), " +
" (N'874101', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'10', 395), " +
" (N'876398', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'10', 395), " +
" (N'919481', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'6', 395), " +
" (N'926543', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'6', 395), " +
" (N'942010', Inventory.SetDateEntered(-14), N'AK Anne Klein', N'Women', N'Dresses', N'Ruched Sleeveless Dress', N'4', 395); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'509533', Inventory.SetDateEntered(-14), N'Men', N'Hats', N'Spencer Straw Fedora', 55.55); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'535009', Inventory.SetDateEntered(-14), N'Calvin Klein', N'Women', N'Skirts', N'Taffeta Ball Skirt', N'4', 300), " +
" (N'251814', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'10', 120), " +
" (N'290817', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'4', 120), " +
" (N'363074', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'6', 120), " +
" (N'600915', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'14', 120), " +
" (N'812886', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'8', 120), " +
" (N'838625', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'2', 120), " +
" (N'871453', Inventory.SetDateEntered(-14), N'Anne Klein', N'Women', N'Dresses', N'Textured Belted Dress', N'12', 120); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'638621', Inventory.SetDateEntered(-14), N'Women', N'Handbags', N'Wacoal Bra', N'32DD', 58); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'570063', Inventory.SetDateEntered(-15), N'Nautica', N'Women', N'Coats', N'Belted Wool Coat', N'10', 498.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'513715', Inventory.SetDateEntered(-15), N'Kenneth Cole New York', N'Women', N'Jewelry', N'Blue Crystal and Metal Necklace', 125.95), " +
" (N'798323', Inventory.SetDateEntered(-15), N'Kenneth Cole New York', N'Women', N'Jewelry', N'Blue Crystal and Metal Necklace', 125.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'107496', Inventory.SetDateEntered(-15), N'Women', N'Jewelry', N'Blue Sandstone Chain Bracelet', 68); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'647848', Inventory.SetDateEntered(-15), N'Guess', N'Women', N'Shoes', N'Bolton Scallop Bow Pumps', N'10', 350), " +
" (N'558044', Inventory.SetDateEntered(-15), N'Guess', N'Women', N'Shoes', N'Bolton Scallop Bow Pumps', N'8.5', 350); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'989998', Inventory.SetDateEntered(-15), N'Collentra Studio', N'Women', N'Handbags', N'City Chic Handbag', 348); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'946783', Inventory.SetDateEntered(-15), N'Kenneth Cole Reaction', N'Women', N'Coats', N'Double Breasted Peacoat', N'6', 260), " +
" (N'366154', Inventory.SetDateEntered(-15), N'Coach', N'Girls', N'Dresses', N'Girls 2-6X Cotton Tiered Shirt Dress', N'6X', 44.5), " +
" (N'366270', Inventory.SetDateEntered(-15), N'Coach', N'Girls', N'Dresses', N'Girls 2-6X Cotton Tiered Shirt Dress', N'4', 44.5), " +
" (N'931447', Inventory.SetDateEntered(-15), N'Coach', N'Girls', N'Dresses', N'Girls 2-6X Cotton Tiered Shirt Dress', N'6', 44.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'735312', Inventory.SetDateEntered(-15), N'Cole Haan', N'Women', N'Watches', N'Ladies Black Python-Embossed Watch', 59.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'407931', Inventory.SetDateEntered(-15), N'Calvin Klein', N'Women', N'Shirts', N'Petite Allover Lace Short Sleeve Top', N'M', 128.95), " +
" (N'908540', Inventory.SetDateEntered(-15), N'Nautica', N'Women', N'Jackets', N'Petite Femme Collar Jacket', N'2', 250), " +
" (N'801348', Inventory.SetDateEntered(-15), N'Ralph Lauren', N'Women', N'Skirts', N'Petite Moulinee Tweed A-Line Skirt', N'4', 128); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'776829', Inventory.SetDateEntered(-15), N'Kenneth Cole', N'Women', N'Jackets', N'Petite Tropical Wool Jacket', 230); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'168465', Inventory.SetDateEntered(-16), N'Giorgio Armani', N'Men', N'Shoes', N'Pannell Penny Loafers', N'8', 89.95), " +
" (N'468808', Inventory.SetDateEntered(-16), N'Giorgio Armani', N'Men', N'Shoes', N'Pannell Penny Loafers', N'8.5', 89.95), " +
" (N'377627', Inventory.SetDateEntered(-16), N'Clarks', N'Women', N'Shoes', N'Suede T-Strap Pumps ', N'36', 390), " +
" (N'594251', Inventory.SetDateEntered(-16), N'Clarks', N'Women', N'Shoes', N'Suede T-Strap Pumps ', N'40', 390), " +
" (N'677075', Inventory.SetDateEntered(-16), N'Clarks', N'Women', N'Shoes', N'Suede T-Strap Pumps ', N'37', 390), " +
" (N'943171', Inventory.SetDateEntered(-16), N'Clarks', N'Women', N'Shoes', N'Suede T-Strap Pumps ', N'38', 390), " +
" (N'232250', Inventory.SetDateEntered(-17), N'Guess', N'Women', N'Shoes', N'Astrid Open-Toe Platform Sandals', N'9', 75), " +
" (N'394985', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Sweaterdress', N'L', 345), " +
" (N'565789', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeved Sweaterdress', N'S', 345); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'477550', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Accessories', N'Chunky Rochelle Scarf', 52.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'131020', Inventory.SetDateEntered(-17), N'Juaro Collections', N'Women', N'Coats', N'Classic Trench Coat', N'XL', 225.95), " +
" (N'294696', Inventory.SetDateEntered(-17), N'Juaro Collections', N'Women', N'Coats', N'Classic Trench Coat', N'XS', 225.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'501638', Inventory.SetDateEntered(-17), N'Ralph Lauren', N'Girls', N'Shoes', N'Double Buckle Leather Booties', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'139118', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'11', 70), " +
" (N'192763', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'10', 70), " +
" (N'231415', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'9', 70), " +
" (N'236929', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'10.5', 70), " +
" (N'349007', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'8', 70), " +
" (N'378270', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'11.5', 70), " +
" (N'411890', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'8.5', 70), " +
" (N'503924', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'12', 70), " +
" (N'579407', Inventory.SetDateEntered(-17), N'Guess', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'9.5', 70); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'426643', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Accessories', N'Knit Scarf', 50); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'666095', Inventory.SetDateEntered(-17), N'Kenneth Cole New York', N'Men', N'Shirts', N'Non-Iron Grid Pattern Dress Shirt', N'16 34/35', 59.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'276043', Inventory.SetDateEntered(-17), N'Giorgio Armani', N'Men', N'Shoes', N'Pattison Leather Oxfords', 140), " +
" (N'815850', Inventory.SetDateEntered(-17), N'Giorgio Armani', N'Men', N'Shoes', N'Pattison Leather Oxfords', 140); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'121041', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'8.5', 155), " +
" (N'181526', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'11', 155), " +
" (N'319792', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'10', 155), " +
" (N'325775', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'9.5', 155), " +
" (N'575463', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'10.5', 155), " +
" (N'666220', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'9', 155), " +
" (N'752642', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'12', 155), " +
" (N'861250', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Penn Waterproof Leather Slip-Ons', N'8', 155); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'595262', Inventory.SetDateEntered(-17), N'Women', N'Beauty and Grooming', N'Perfectly Luscious Curls and Conditioner', 24.95), " +
" (N'820398', Inventory.SetDateEntered(-17), N'Women', N'Beauty and Grooming', N'Perfectly Luscious Curls and Shampoo', 24.95), " +
" (N'139581', Inventory.SetDateEntered(-17), N'Women', N'Beauty and Grooming', N'Perfectly Luscious Curls and Wave Activating Spray', 24.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'382497', Inventory.SetDateEntered(-17), N'Nautica', N'Women', N'Sweaters', N'Petite Fine Merino Wool Cardigan', 78); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'777304', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Printed Jersey Dress', N'8', 135.95), " +
" (N'361930', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'10 S', 35), " +
" (N'414919', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'6 M', 35), " +
" (N'415624', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'8 S', 35), " +
" (N'521392', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'8 M', 35), " +
" (N'594744', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'8 M', 35), " +
" (N'693973', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Racket Thong Sandals', N'10 M', 35), " +
" (N'401970', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'38', 145), " +
" (N'409905', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'36', 145), " +
" (N'637641', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'38', 145), " +
" (N'692163', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'40', 145), " +
" (N'871522', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'36', 145), " +
" (N'900189', Inventory.SetDateEntered(-17), N'Polo Ralph Lauren', N'Women', N'Dresses', N'Short-Sleeved Polo Dress', N'38', 145); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'892482', Inventory.SetDateEntered(-17), N'Men', N'Beauty and Grooming', N'Skin Revitalizer Lotion For Men', 34.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'100333', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'227890', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'294345', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'745451', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'780594', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'837570', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'845626', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68), " +
" (N'864808', Inventory.SetDateEntered(-17), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Strapless Drawstring Pocket Dress', 68); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'545127', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Suede Desert Boots', N'9.5', 105.50), " +
" (N'741256', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Suede Desert Boots', N'11', 105.50), " +
" (N'937992', Inventory.SetDateEntered(-17), N'Calvin Klein', N'Men', N'Shoes', N'Suede Desert Boots', N'10.5', 105.50), " +
" (N'584697', Inventory.SetDateEntered(-17), N'Anne Klein', N'Women', N'Shoes', N'Suede Pointy-Toe Kitten Heel Pumps', N'7', 80), " +
" (N'655250', Inventory.SetDateEntered(-17), N'Anne Klein', N'Women', N'Shoes', N'Suede Pointy-Toe Kitten Heel Pumps', N'7.5', 80), " +
" (N'779508', Inventory.SetDateEntered(-17), N'Anne Klein', N'Women', N'Shoes', N'Suede Pointy-Toe Kitten Heel Pumps', N'6.5', 80), " +
" (N'264102', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Trendon Studded Flat Sandals', N'6 M', 32), " +
" (N'308069', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Trendon Studded Flat Sandals', N'7 1/2 M', 32), " +
" (N'758904', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Trendon Studded Flat Sandals', N'7 M', 32); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'847478', Inventory.SetDateEntered(-17), N'Clarks', N'Women', N'Shoes', N'Trendon Studded Flat Sandals', 32); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'341986', Inventory.SetDateEntered(-18), N'Kenneth Cole New York', N'Women', N'Dresses', N'Belted V-Neck Dress', N'10', 119.95), " +
" (N'476698', Inventory.SetDateEntered(-18), N'Kenneth Cole New York', N'Women', N'Dresses', N'Belted V-Neck Dress', N'4', 119.95), " +
" (N'524342', Inventory.SetDateEntered(-18), N'Kenneth Cole New York', N'Women', N'Dresses', N'Belted V-Neck Dress', N'12', 119.95), " +
" (N'786816', Inventory.SetDateEntered(-18), N'Kenneth Cole New York', N'Women', N'Dresses', N'Belted V-Neck Dress', N'6', 119.95), " +
" (N'916600', Inventory.SetDateEntered(-18), N'Kenneth Cole New York', N'Women', N'Dresses', N'Belted V-Neck Dress', N'8', 119.95), " +
" (N'128558', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'4', 44.75), " +
" (N'199471', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'3/3T ', 44.75), " +
" (N'251736', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'6', 44.75), " +
" (N'328561', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'5', 44.75), " +
" (N'651328', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'2/2T ', 44.75), " +
" (N'683863', Inventory.SetDateEntered(-18), N'Ralph Lauren', N'Boys', N'Pants', N'Boys 2-7 New Cargo Pants', N'7', 44.75), " +
" (N'142270', Inventory.SetDateEntered(-18), N'AK Anne Klein', N'Men', N'Shoes', N'Classic Sheepskin Short Boots', N'10', 155.5), " +
" (N'884563', Inventory.SetDateEntered(-18), N'AK Anne Klein', N'Men', N'Shoes', N'Classic Sheepskin Short Boots', N'8', 155.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'749999', Inventory.SetDateEntered(-18), N'Coach', N'Women', N'Handbags', N'Crystal Snake-Embossed Shoulder Handbag', 124.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'336560', Inventory.SetDateEntered(-18), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'7.5', 99.95), " +
" (N'379843', Inventory.SetDateEntered(-18), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'5.5', 99.95), " +
" (N'207380', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Page Pointy-Toe Pumps', N'8', 80), " +
" (N'297342', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Page Pointy-Toe Pumps', N'7', 80), " +
" (N'547666', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Page Pointy-Toe Pumps', N'6', 80), " +
" (N'609238', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Page Pointy-Toe Pumps', N'6.5', 80), " +
" (N'837824', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Page Pointy-Toe Pumps', N'7.5', 80), " +
" (N'950453', Inventory.SetDateEntered(-18), N'AK Anne Klein', N'Women', N'Skirts', N'Pencil Skirt', N'14', 54); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'959905', Inventory.SetDateEntered(-18), N'Women', N'Beauty and Grooming', N'Perfectly Luscious Curl and Curl Shaper Cream', 24.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'260149', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Satin Evening Sandals', N'9.5', 65), " +
" (N'338314', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Satin Evening Sandals', N'8.5', 65), " +
" (N'730147', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Satin Evening Sandals', N'8', 65), " +
" (N'819917', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Satin Evening Sandals', N'6.5', 65), " +
" (N'829585', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Satin Evening Sandals', N'9', 65), " +
" (N'316423', Inventory.SetDateEntered(-18), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Slim-Fit Plaid Dress Shirt', N'17 32-33', 65), " +
" (N'774879', Inventory.SetDateEntered(-18), N'Clarks', N'Women', N'Shoes', N'Strappy Sandals', N'7 1/2 M', 49.95), " +
" (N'364833', Inventory.SetDateEntered(-19), N'Nautica', N'Men', N'Sweaters', N'1/4-Button Mock-Turtleneck Pull-Over', N'XL', 124.95), " +
" (N'490009', Inventory.SetDateEntered(-19), N'Nautica', N'Men', N'Sweaters', N'1/4-Button Mock-Turtleneck Pull-Over', N'M', 124.95), " +
" (N'563560', Inventory.SetDateEntered(-19), N'Nautica', N'Men', N'Sweaters', N'1/4-Button Mock-Turtleneck Pull-Over', N'L', 124.95), " +
" (N'750655', Inventory.SetDateEntered(-19), N'Nautica', N'Men', N'Sweaters', N'1/4-Button Mock-Turtleneck Pull-Over', N'S', 124.95), " +
" (N'365095', Inventory.SetDateEntered(-19), N'AK Anne Klein', N'Men', N'Shoes', N'Classic Sheepskin Short Boots', N'12', 155.5), " +
" (N'275672', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Piqué Polo Dress', N'S', 89.95), " +
" (N'404650', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Piqué Polo Dress', N'XL', 89.95), " +
" (N'817224', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Piqué Polo Dress', N'M', 89.95), " +
" (N'820696', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Piqué Polo Dress', N'L', 89.95), " +
" (N'880923', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cotton Piqué Polo Dress', N'XS', 89.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'527596', Inventory.SetDateEntered(-19), N'Cole Haan', N'Women', N'Handbags', N'Crossbody Handbag', 98.85), " +
" (N'951257', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Handbags', N'Embossed Crossbody Handbag', 148.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'139569', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Lace-Up Sweatshirt Dress', N'L', 110), " +
" (N'837365', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Lace-Up Sweatshirt Dress', N'S', 110), " +
" (N'973961', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Lace-Up Sweatshirt Dress', N'M', 110), " +
" (N'361267', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Matte Jersey Wrap Dress', N'XS', 145), " +
" (N'430295', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Matte Jersey Wrap Dress', N'M', 145), " +
" (N'562586', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Matte Jersey Wrap Dress', N'S', 145), " +
" (N'724204', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Matte Jersey Wrap Dress', N'XL', 145), " +
" (N'926716', Inventory.SetDateEntered(-19), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Matte Jersey Wrap Dress', N'L', 145), " +
" (N'116346', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'8', 99.95), " +
" (N'197705', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'6.5', 99.95), " +
" (N'550071', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'7', 99.95), " +
" (N'686371', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Shoes', N'Neal Kitten-Heel Buckled Pointy-Toe Pumps', N'6', 99.95), " +
" (N'537885', Inventory.SetDateEntered(-19), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'0', 125), " +
" (N'501551', Inventory.SetDateEntered(-19), N'Calvin Klein', N'Women', N'Dresses', N'Sleeveless Halter Dress', N'10', 100), " +
" (N'856566', Inventory.SetDateEntered(-19), N'Calvin Klein', N'Women', N'Dresses', N'Sleeveless Halter Dress', N'8', 100), " +
" (N'862628', Inventory.SetDateEntered(-19), N'Calvin Klein', N'Women', N'Dresses', N'Sleeveless Halter Dress', N'4', 100), " +
" (N'911794', Inventory.SetDateEntered(-19), N'Calvin Klein', N'Women', N'Dresses', N'Sleeveless Halter Dress', N'6', 100); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'379020', Inventory.SetDateEntered(-19), N'Coach', N'Women', N'Handbags', N'Square Shoulder Handbag', 255); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'142594', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'14', 124.95), " +
" (N'177928', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'16', 124.95), " +
" (N'449559', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'12', 124.95), " +
" (N'552158', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'6', 124.95), " +
" (N'569436', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'4', 124.95), " +
" (N'657441', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'10', 124.95), " +
" (N'816900', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Animal-Print Flutter-Sleeve Dress', N'8', 124.95), " +
" (N'179908', Inventory.SetDateEntered(-20), N'Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Polka-Dot Bubble Dress', N'12M', 27.75), " +
" (N'832401', Inventory.SetDateEntered(-20), N'Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Polka-Dot Bubble Dress', N'18M', 27.75), " +
" (N'931290', Inventory.SetDateEntered(-20), N'Anne Klein', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Polka-Dot Bubble Dress', N'24M', 27.75), " +
" (N'154883', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Draped Dress', N'M', 109.90), " +
" (N'266840', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Draped Dress', N'L', 109.90), " +
" (N'661362', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Draped Dress', N'S', 109.90), " +
" (N'767905', Inventory.SetDateEntered(-20), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Cap-Sleeve Draped Dress', N'XS', 109.90), " +
" (N'205964', Inventory.SetDateEntered(-20), N'Clarks', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'8', 64.95), " +
" (N'524285', Inventory.SetDateEntered(-20), N'Clarks', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'9', 64.95), " +
" (N'845237', Inventory.SetDateEntered(-20), N'Clarks', N'Men', N'Shoes', N'Escalade Leather Slip-Ons', N'10.5', 64.95), " +
" (N'416884', Inventory.SetDateEntered(-20), N'Ralph Lauren', N'Girls', N'Sweaters', N'Girls 2-6x Cabled Cotton Sweater', N'5', 49.95), " +
" (N'469741', Inventory.SetDateEntered(-20), N'Cole Haan', N'Men', N'Shoes', N'Leighton Leather Desert Boots', N'12', 155), " +
" (N'992998', Inventory.SetDateEntered(-20), N'Cole Haan', N'Men', N'Shoes', N'Leighton Leather Desert Boots', N'8', 155), " +
" (N'198765', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'12', 125), " +
" (N'380039', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'4', 125), " +
" (N'598480', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'10', 125), " +
" (N'610860', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'2', 125), " +
" (N'813967', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'8', 125), " +
" (N'819911', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Women', N'Dresses', N'Scallop Bodice Dress', N'6', 125), " +
" (N'154722', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'12', 95.95), " +
" (N'197070', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'10', 95.95), " +
" (N'215999', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'11', 95.95), " +
" (N'325013', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'10.5', 95.95), " +
" (N'400968', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'8', 95.95), " +
" (N'468771', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'8.5', 95.95), " +
" (N'960207', Inventory.SetDateEntered(-20), N'Calvin Klein', N'Men', N'Shoes', N'Square-Toe Leather Loafers ', N'9', 95.95), " +
" (N'230193', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'10.5', 95.95), " +
" (N'323925', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'8', 95.95), " +
" (N'473572', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'9', 95.95), " +
" (N'500551', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'10', 95.95), " +
" (N'552384', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'11.5', 95.95), " +
" (N'750361', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'8.5', 95.95), " +
" (N'828851', Inventory.SetDateEntered(-20), N'Johnston and Murphy', N'Men', N'Shoes', N'Woven Venetian Loafers', N'11', 95.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'733687', Inventory.SetDateEntered(-21), N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio Deodorant Stick', 18.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'867554', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Asymmetrical Chiffon Skirt', N'S', 45), " +
" (N'928923', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Asymmetrical Chiffon Skirt', N'XS', 45), " +
" (N'153111', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Boys', N'Shirts', N'Baby Boys 12-24 Months Long-Sleeved Blake Shirt', N'9M', 28), " +
" (N'658046', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Boys', N'Shirts', N'Baby Boys 12-24 Months Long-Sleeved Blake Shirt', N'12M', 28), " +
" (N'418019', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Boys', N'Shirts', N'Baby Boys 12-24 Months Long-Sleeved Blake Shirt', N'24M', 28), " +
" (N'526936', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Boys', N'Shirts', N'Baby Boys 12-24 Months Long-Sleeved Blake Shirt', N'18M', 28); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'589975', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Printed Coveralls', N'24M', 15), " +
" (N'641530', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Printed Coveralls', N'12M', 15), " +
" (N'972184', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Printed Coveralls', N'18M', 15); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'370628', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Rosette and Leopard-Print Dress', N'12M', 47.75), " +
" (N'680826', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Rosette and Leopard-Print Dress', N'18M', 47.75), " +
" (N'861576', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Baby Girls', N'Dresses', N'Baby Girls 12-24 Months Rosette and Leopard-Print Dress', N'24M', 47.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'752047', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Ruffle Top and Shorts Set', N'24M', 44), " +
" (N'808503', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Ruffle Top and Shorts Set', N'18M', 44), " +
" (N'991204', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Ruffle Top and Shorts Set', N'12M', 44), " +
" (N'141328', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Striped Denim Romper', N'24M', 17.75), " +
" (N'561370', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Striped Denim Romper', N'18M', 17.75), " +
" (N'992752', Inventory.SetDateEntered(-21), N'Guess', N'Baby Girls', N'Baby Girls 12-24 Months Striped Denim Romper', N'12M', 17.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'113989', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Summer Tunic and Leggings Set', N'24 Months', 34.45), " +
" (N'488878', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Summer Tunic and Leggings Set', N'9 Months', 34.45), " +
" (N'673005', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Summer Tunic and Leggings Set', N'12 Months', 34.45), " +
" (N'898232', Inventory.SetDateEntered(-21), N'Ralph Lauren', N'Baby Girls', N'Baby Girls 12-24 Months Summer Tunic and Leggings Set', N'18 Months', 34.45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'708676', Inventory.SetDateEntered(-21), N'Juaro Collections', N'Women', N'Coats', N'Classic Trench Coat', N'L', 225.95), " +
" (N'904198', Inventory.SetDateEntered(-21), N'Juaro Collections', N'Women', N'Coats', N'Classic Trench Coat', N'M', 225.95), " +
" (N'405268', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'10', 126.75), " +
" (N'406272', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'6', 126.75), " +
" (N'616565', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'8', 126.75), " +
" (N'807527', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'4', 126.75), " +
" (N'955359', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'2', 126.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'876089', Inventory.SetDateEntered(-21), N'Women', N'Accessories', N'Elbow-Length Silk Charmeuse Gloves', 44.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'186359', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'4', 90), " +
" (N'248559', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'8', 90), " +
" (N'314791', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'6', 90), " +
" (N'438368', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'10', 90), " +
" (N'653615', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'2', 90), " +
" (N'678397', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'12', 90), " +
" (N'778845', Inventory.SetDateEntered(-21), N'Anne Klein', N'Women', N'Skirts', N'Floral Print Ruffled Skirt', N'0', 90); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'650422', Inventory.SetDateEntered(-21), N'Men', N'Beauty and Grooming', N'Ingrown Hair Treatment For Men', 26.75), " +
" (N'628256', Inventory.SetDateEntered(-21), N'Men', N'Beauty and Grooming', N'Invigorating Face Scrub For Men', 25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'794264', Inventory.SetDateEntered(-21), N'Juaro Collections', N'Women', N'Hats', N'Leopard-Print Rain Hat', 174.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'916152', Inventory.SetDateEntered(-21), N'Men', N'Beauty and Grooming', N'Non-Streak Bronzer For Men', 18.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'118941', Inventory.SetDateEntered(-21), N'Nautica', N'Men', N'Shoes', N'Penny Loafers', N'9.5', 150), " +
" (N'235478', Inventory.SetDateEntered(-21), N'Nautica', N'Men', N'Shoes', N'Penny Loafers', N'10.5', 150), " +
" (N'747466', Inventory.SetDateEntered(-21), N'Nautica', N'Men', N'Shoes', N'Penny Loafers', N'10', 150); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'339498', Inventory.SetDateEntered(-21), N'Men', N'Beauty and Grooming', N'Pre Shave Oil For Men', 21.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'333530', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Skirts', N'Ribbed Skirt', N'S', 36.75), " +
" (N'456653', Inventory.SetDateEntered(-21), N'Calvin Klein', N'Women', N'Skirts', N'Ribbed Skirt', N'M', 36.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'900091', Inventory.SetDateEntered(-21), N'Men', N'Root Power Restorative Style Wax For Men', 19.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'409224', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'4', 135.65), " +
" (N'566109', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'8', 135.65), " +
" (N'692082', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'14', 135.65), " +
" (N'833716', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'6', 135.65), " +
" (N'896320', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'8', 135.65), " +
" (N'911761', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Ruched Jersey Dress', N'12', 135.65); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'196220', Inventory.SetDateEntered(-21), N'Men', N'Beauty and Grooming', N'Scruffing Lotion 3.5 For Men', 12.45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'144322', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Stretch Cotton Hooded Dress', N'S', 99.95), " +
" (N'407936', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Stretch Cotton Hooded Dress', N'XL', 99.95), " +
" (N'420648', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Stretch Cotton Hooded Dress', N'XS', 99.95), " +
" (N'560121', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Stretch Cotton Hooded Dress', N'M', 99.95), " +
" (N'760129', Inventory.SetDateEntered(-21), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Stretch Cotton Hooded Dress', N'L', 99.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'860312', Inventory.SetDateEntered(-22), N'Women', N'Accessories', N'Wrist-Length Suede Gloves', N'6.5', 70); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'541112', Inventory.SetDateEntered(-22), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'XL', 75), " +
" (N'927722', Inventory.SetDateEntered(-22), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'S', 75), " +
" (N'937867', Inventory.SetDateEntered(-22), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'L', 75), " +
" (N'976801', Inventory.SetDateEntered(-22), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'M', 75), " +
" (N'209668', Inventory.SetDateEntered(-22), N'Coach', N'Women', N'Dresses', N'Flutter Sleeve Wanda Dress', N'5', 125.85), " +
" (N'342826', Inventory.SetDateEntered(-22), N'Coach', N'Women', N'Dresses', N'Flutter Sleeve Wanda Dress', N'7', 125.85), " +
" (N'545055', Inventory.SetDateEntered(-22), N'Coach', N'Women', N'Dresses', N'Flutter Sleeve Wanda Dress', N'9', 125.85), " +
" (N'818622', Inventory.SetDateEntered(-22), N'Ralph Lauren', N'Girls', N'Skirts', N'Girls 2-6x Pull-On Ruffle Skirt', N'6', 39.85), " +
" (N'561110', Inventory.SetDateEntered(-22), N'Ralph Lauren', N'Girls', N'Skirts', N'Girls 2-6x Pull-On Ruffle Skirt', N'5', 39.85), " +
" (N'137318', Inventory.SetDateEntered(-23), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated A-Line Dress', N'10', 88.85), " +
" (N'359156', Inventory.SetDateEntered(-23), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated A-Line Dress', N'6', 88.85), " +
" (N'417440', Inventory.SetDateEntered(-23), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated A-Line Dress', N'4', 88.85), " +
" (N'557092', Inventory.SetDateEntered(-23), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated A-Line Dress', N'14', 88.85), " +
" (N'641828', Inventory.SetDateEntered(-23), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated A-Line Dress', N'8', 88.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'748311', Inventory.SetDateEntered(-24), N'Men', N'Beauty and Grooming', N'Active Face Wash For Men', 19.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'224397', Inventory.SetDateEntered(-24), N'Lauren by Ralph Lauren', N'Baby Girls', N'Jackets', N'Baby Girls 12-24 Months Denim Jacket', N'24M', 39.95), " +
" (N'346910', Inventory.SetDateEntered(-24), N'Lauren by Ralph Lauren', N'Baby Girls', N'Jackets', N'Baby Girls 12-24 Months Denim Jacket', N'18M', 39.95), " +
" (N'438620', Inventory.SetDateEntered(-24), N'Lauren by Ralph Lauren', N'Baby Girls', N'Jackets', N'Baby Girls 12-24 Months Denim Jacket', N'12M', 39.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'426003', Inventory.SetDateEntered(-24), N'Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Ruffled Tunic Set', N'24', 34.50), " +
" (N'577334', Inventory.SetDateEntered(-24), N'Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Ruffled Tunic Set', N'12', 34.50), " +
" (N'800008', Inventory.SetDateEntered(-24), N'Calvin Klein', N'Baby Girls', N'Baby Girls 12-24 Months Ruffled Tunic Set', N'18', 34.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'399434', Inventory.SetDateEntered(-24), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'14', 126.75), " +
" (N'729070', Inventory.SetDateEntered(-24), N'Calvin Klein', N'Women', N'Dresses', N'Colorblocked V-Neck Dress', N'12', 126.75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'527332', Inventory.SetDateEntered(-24), N'Women', N'Jewelry', N'Cork Link Necklace', 95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'129779', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Floral Printed Miniskirt', N'XS', 37.75), " +
" (N'309332', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Floral Printed Miniskirt', N'S', 37.75), " +
" (N'357925', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Floral Printed Miniskirt', N'M', 37.75), " +
" (N'747934', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Floral Printed Miniskirt', N'L', 37.75), " +
" (N'126741', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Foldover Waist Skirt', N'M', 45), " +
" (N'241731', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Foldover Waist Skirt', N'L', 45), " +
" (N'517862', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Foldover Waist Skirt', N'S', 45), " +
" (N'900414', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Skirts', N'Foldover Waist Skirt', N'XS', 45), " +
" (N'992433', Inventory.SetDateEntered(-24), N'Collentra Studio', N'Women', N'Hats', N'Grosgrain Ribbon Striped Hat - Magenta', N'S/M', 16), " +
" (N'124481', Inventory.SetDateEntered(-24), N'Collentra Studio', N'Women', N'Hats', N'Grosgrain Ribbon Striped Hat - Turquoise', N'S/M', 16); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'401724', Inventory.SetDateEntered(-24), N'Women', N'Jewelry', N'Hinged Wrap Bracelet', 26.75), " +
" (N'245026', Inventory.SetDateEntered(-24), N'Men', N'Beauty and Grooming', N'Multi-Action Face Wash For Men', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'195646', Inventory.SetDateEntered(-24), N'CK Calvin Klein', N'Women', N'Dresses', N'Pleated Floral Dress', N'S', 110), " +
" (N'503003', Inventory.SetDateEntered(-24), N'CK Calvin Klein', N'Women', N'Dresses', N'Pleated Floral Dress', N'M', 110), " +
" (N'861222', Inventory.SetDateEntered(-24), N'CK Calvin Klein', N'Women', N'Dresses', N'Pleated Floral Dress', N'L', 110), " +
" (N'675929', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Dresses', N'Short-Sleeved Banded Dress', N'4', 155), " +
" (N'286615', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Dresses', N'Short-Sleeved Banded Dress', N'6', 155), " +
" (N'444938', Inventory.SetDateEntered(-24), N'Anne Klein', N'Women', N'Dresses', N'Short-Sleeved Banded Dress', N'8', 155), " +
" (N'653895', Inventory.SetDateEntered(-24), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Slim Custom-Fit Mesh Polo', N'X-Large', 95.8); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'403266', Inventory.SetDateEntered(-24), N'Women', N'Jewelry', N'Tiered Snake-Chain Necklace', 75); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'843916', Inventory.SetDateEntered(-25), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'2-Button Wool Suit Jacket', N'40L', 115), " +
" (N'845011', Inventory.SetDateEntered(-25), N'Lauren by Ralph Lauren', N'Men', N'Suits', N'2-Button Wool Suit Jacket', N'46L', 115); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'328363', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Graphic T-Shirt and Pants Set', N'12M', 45), " +
" (N'535687', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Graphic T-Shirt and Pants Set', N'18M', 45), " +
" (N'235033', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Hoodie and Athletic Pants Set', N'18M', 45), " +
" (N'711134', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Hoodie and Athletic Pants Set', N'9M', 45), " +
" (N'778520', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Hoodie and Athletic Pants Set', N'24M', 45), " +
" (N'998530', Inventory.SetDateEntered(-25), N'Ralph Lauren', N'Baby Boys', N'Baby Boys 12-24 Months Hoodie and Athletic Pants Set', N'12M', 45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'299823', Inventory.SetDateEntered(-25), N'Women', N'Leather-Inset Earrings', 55); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'419027', Inventory.SetDateEntered(-25), N'Calvin Klein', N'Men', N'Ties', N'Paisley Silk Tie - Lavender', 29.95), " +
" (N'869950', Inventory.SetDateEntered(-25), N'Calvin Klein', N'Men', N'Ties', N'Paisley Silk Tie - Navy', 29.95), " +
" (N'847673', Inventory.SetDateEntered(-25), N'Calvin Klein', N'Men', N'Ties', N'Paisley Silk Tie - Red', 29.95), " +
" (N'505816', Inventory.SetDateEntered(-25), N'Calvin Klein', N'Men', N'Ties', N'Paisley Silk Tie - Yellow', 29.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'272694', Inventory.SetDateEntered(-25), N'Women', N'Shoes', N'Perfect Suede Pumps', N'5.5', 158), " +
" (N'589398', Inventory.SetDateEntered(-25), N'Women', N'Shoes', N'Perfect Suede Pumps', N'6.5', 158), " +
" (N'831085', Inventory.SetDateEntered(-25), N'Women', N'Shoes', N'Perfect Suede Pumps', N'7', 158), " +
" (N'901931', Inventory.SetDateEntered(-25), N'Women', N'Shoes', N'Perfect Suede Pumps', N'5', 158), " +
" (N'976585', Inventory.SetDateEntered(-25), N'Women', N'Shoes', N'Perfect Suede Pumps', N'6', 158); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'287159', Inventory.SetDateEntered(-25), N'AK Anne Klein', N'Women', N'Skirts', N'Stitched Skirt', N'4', 102.45), " +
" (N'325178', Inventory.SetDateEntered(-25), N'AK Anne Klein', N'Women', N'Skirts', N'Stitched Skirt', N'0', 102.45), " +
" (N'619570', Inventory.SetDateEntered(-25), N'AK Anne Klein', N'Women', N'Skirts', N'Stitched Skirt', N'6', 102.45), " +
" (N'694880', Inventory.SetDateEntered(-25), N'AK Anne Klein', N'Women', N'Skirts', N'Stitched Skirt', N'8', 102.45), " +
" (N'860846', Inventory.SetDateEntered(-25), N'AK Anne Klein', N'Women', N'Skirts', N'Stitched Skirt', N'2', 102.45); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'283041', Inventory.SetDateEntered(-25), N'Women', N'Skirts', N'Long and Lean Ponte Pencil Skirt', 6, 79.95), " +
" (N'602042', Inventory.SetDateEntered(-25), N'Women', N'Skirts', N'Long and Lean Ponte Pencil Skirt', 8, 79.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'467558', Inventory.SetDateEntered(-25), N'Collentra Studio', N'Women', N'Belts', N'Double-Layer Belt', N'Large', 38.85), " +
" (N'305587', Inventory.SetDateEntered(-25), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'12', 95.95), " +
" (N'131790', Inventory.SetDateEntered(-25), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'14', 95.95), " +
" (N'426780', Inventory.SetDateEntered(-25), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'16', 95.95), " +
" (N'434968', Inventory.SetDateEntered(-25), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'10', 95.95), " +
" (N'518471', Inventory.SetDateEntered(-25), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'8', 95.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'707914', Inventory.SetDateEntered(-26), N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 55.5), " +
" (N'803174', Inventory.SetDateEntered(-26), N'Giorgio Armani', N'Men', N'Beauty and Grooming', N'Acqua Di Gio After Shave Balm', 49.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'655572', Inventory.SetDateEntered(-26), N'Lacoste', N'Men', N'Shoes', N'Costa Mid Sneakers', N'11', 74.95), " +
" (N'913864', Inventory.SetDateEntered(-26), N'Lacoste', N'Men', N'Shoes', N'Costa Mid Sneakers', N'10', 74.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'292495', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Men', N'Beauty and Grooming', N'Eternity for Men Fragrance Collection', 85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'139721', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'8', 158), " +
" (N'164956', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'10', 158), " +
" (N'358290', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'11', 158), " +
" (N'578896', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'7.5', 158), " +
" (N'679920', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'8.5', 158), " +
" (N'705094', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'9', 158), " +
" (N'837286', Inventory.SetDateEntered(-26), N'Women', N'Shoes', N'Perfect Suede Pumps', N'9.5', 158); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'255869', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'31W - 30L', 74.95), " +
" (N'284986', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'34W - 30L', 74.95), " +
" (N'406029', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'34W - 34L', 74.95), " +
" (N'460614', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'30W - 30L', 74.95), " +
" (N'523283', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'34W - 32L', 74.95), " +
" (N'648868', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'32W - 30L', 74.95), " +
" (N'704113', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'32W - 32L', 74.95), " +
" (N'882470', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'33W - 30L', 74.95), " +
" (N'891081', Inventory.SetDateEntered(-26), N'Polo Ralph Lauren', N'Men', N'Pants', N'Preston Flat-Front Vintage Chinos', N'34W - 29L', 74.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'480246', Inventory.SetDateEntered(-26), N'Women', N'Accessories', N'Solid Luxe Scarf', 48); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'106660', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'14', 94.5), " +
" (N'275056', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'8', 94.5), " +
" (N'275475', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'16', 94.5), " +
" (N'605733', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'0', 94.5), " +
" (N'705726', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'12', 94.5), " +
" (N'832782', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'10', 94.5), " +
" (N'998321', Inventory.SetDateEntered(-26), N'Calvin Klein', N'Women', N'Jackets', N'Stretch One Button Jacket', N'2', 94.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'764505', Inventory.SetDateEntered(-27), N'Women', N'Jewelry', N'Jet Lace Long Chain Necklace', 88); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'990272', Inventory.SetDateEntered(-27), N'Lauren by Ralph Lauren', N'Women', N'Handbags', N'Newbury Leather Framed Clutch Handbag', 159.95), " +
" (N'423520', Inventory.SetDateEntered(-27), N'Lauren by Ralph Lauren', N'Women', N'Handbags', N'Newbury Leather Slim Continental Wallet', 128); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'109917', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'12', 129.95), " +
" (N'183996', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'8', 129.95), " +
" (N'198055', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'14', 129.95), " +
" (N'419857', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'10', 129.95), " +
" (N'438890', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'2', 129.95), " +
" (N'906315', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'6', 129.95), " +
" (N'914600', Inventory.SetDateEntered(-27), N'Calvin Klein', N'Women', N'Dresses', N'Three-Quarter-Sleeve Belted Animal-Print Shirtdress', N'4', 129.95), " +
" (N'837421', Inventory.SetDateEntered(-28), N'Collentra Studio', N'Women', N'Belts', N'Double-Layer Belt', N'Small', 38.85), " +
" (N'531042', Inventory.SetDateEntered(-28), N'Guess', N'Women', N'Shoes', N'Fiddle Wedge Sandals', N'8.5 M', 84.5), " +
" (N'820945', Inventory.SetDateEntered(-28), N'Guess', N'Women', N'Shoes', N'Fiddle Wedge Sandals', N'9.5 W', 84.5), " +
" (N'640965', Inventory.SetDateEntered(-29), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Shimmer Dress', N'14', 150), " +
" (N'239679', Inventory.SetDateEntered(-29), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Shimmer Dress', N'6', 150), " +
" (N'328577', Inventory.SetDateEntered(-29), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Shimmer Dress', N'10', 150), " +
" (N'677203', Inventory.SetDateEntered(-29), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Shimmer Dress', N'14', 150), " +
" (N'841520', Inventory.SetDateEntered(-29), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Shimmer Dress', N'4', 150), " +
" (N'975290', Inventory.SetDateEntered(-29), N'Collentra Studio', N'Women', N'Belts', N'Double-Layer Belt', N'Medium', 38.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'371845', Inventory.SetDateEntered(-30), N'Collentra Studio', N'Men', N'Pants', N'Faded 5-Pocket Jeans', N'36W - 30L', 49.50), " +
" (N'677119', Inventory.SetDateEntered(-30), N'Collentra Studio', N'Men', N'Pants', N'Faded 5-Pocket Jeans', N'38W - 32L', 49.50), " +
" (N'251603', Inventory.SetDateEntered(-30), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Oxford Long-Sleeved Shirtdress', N'5', 45.85), " +
" (N'355164', Inventory.SetDateEntered(-30), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Oxford Long-Sleeved Shirtdress', N'6', 45.85), " +
" (N'852231', Inventory.SetDateEntered(-30), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Oxford Long-Sleeved Shirtdress', N'2/2T ', 45.85), " +
" (N'883004', Inventory.SetDateEntered(-30), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Oxford Long-Sleeved Shirtdress', N'3/3T ', 45.85), " +
" (N'917140', Inventory.SetDateEntered(-30), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Oxford Long-Sleeved Shirtdress', N'4', 45.85), " +
" (N'424558', Inventory.SetDateEntered(-30), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'12', 115), " +
" (N'601661', Inventory.SetDateEntered(-30), N'Anne Klein', N'Women', N'Skirts', N'Neon Bandage Skirt', N'8', 115), " +
" (N'762566', Inventory.SetDateEntered(-30), N'Collentra Studio', N'Men', N'Pants', N'Relaxed-Fit 5-Pocket Jeans', N'36W - 34L', 49.50), " +
" (N'562525', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'S', 105), " +
" (N'571213', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'L', 105), " +
" (N'599752', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'M', 105), " +
" (N'914127', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Long-Sleeved Cotton Jersey Polo Shirt', N'XL', 105), " +
" (N'406757', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Mesh Polo Shirt', N'M', 98), " +
" (N'471320', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Mesh Polo Shirt', N'M', 98), " +
" (N'511831', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Mesh Polo Shirt', N'S', 98), " +
" (N'649288', Inventory.SetDateEntered(-31), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Custom-Fit Short-Sleeved Cotton Mesh Polo Shirt', N'L', 98), " +
" (N'295999', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Little Nautical Dress', N'4', 28), " +
" (N'359555', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Little Oxford Long-Sleeved Shirt', N'2/2T ', 39.95), " +
" (N'781488', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Shirts', N'Girls 2-6x Little Oxford Long-Sleeved Shirt', N'6', 39.95), " +
" (N'784800', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Little Oxford Long-Sleeved Shirt', N'4', 39.95), " +
" (N'798197', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Little Oxford Long-Sleeved Shirt', N'5', 39.95), " +
" (N'966101', Inventory.SetDateEntered(-31), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Little Oxford Long-Sleeved Shirt', N'3/3T ', 39.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'419480', Inventory.SetDateEntered(-31), N'Women', N'Skirts', N'Leather Skirt', N'M', 395), " +
" (N'729536', Inventory.SetDateEntered(-31), N'Women', N'Skirts', N'Leather Skirt', N'S', 395); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'167787', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'40X30', 74.85), " +
" (N'299440', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'38X30', 74.85), " +
" (N'307336', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'40X32', 74.85), " +
" (N'408678', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'36X30', 74.85), " +
" (N'446003', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'38X34', 74.85), " +
" (N'517604', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'30X30', 74.85), " +
" (N'793551', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'34X30', 74.85), " +
" (N'964614', Inventory.SetDateEntered(-31), N'Lauren by Ralph Lauren', N'Men', N'Pants', N'Love Train Wash Straight-Leg Jeans', N'38X32', 74.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'316384', Inventory.SetDateEntered(-31), N'Men', N'Printed Silk Neat Tie', 69.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'316093', Inventory.SetDateEntered(-32), N'Nautica', N'Men', N'Sweaters', N'Sleeveless V-Neck Cotton Sweater', N'M', 35), " +
" (N'845983', Inventory.SetDateEntered(-32), N'Calvin Klein', N'Men', N'Jackets', N'Slim Fit Jacket', N'44 Long', 294.95), " +
" (N'881870', Inventory.SetDateEntered(-32), N'Calvin Klein', N'Men', N'Jackets', N'Slim Fit Jacket', N'48 Long', 294.95), " +
" (N'439194', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'16.5 36/37', 36.75), " +
" (N'470246', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'16.5 32/33', 36.75), " +
" (N'534836', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'16 34/35', 36.75), " +
" (N'757576', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'14.5 32/33', 36.75), " +
" (N'809734', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'15 32/33', 36.75), " +
" (N'900918', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'15 34/35', 36.75), " +
" (N'130990', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17 32/33', 36.75), " +
" (N'250708', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17 36/37', 36.75), " +
" (N'259285', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'18 34/35', 36.75), " +
" (N'391344', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17.5 34/35', 36.75), " +
" (N'632068', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17.5 36/37', 36.75), " +
" (N'662398', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17 34/35', 36.75), " +
" (N'983721', Inventory.SetDateEntered(-33), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'17.5 32/33', 36.75), " +
" (N'407010', Inventory.SetDateEntered(-34), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'6', 95.95), " +
" (N'588755', Inventory.SetDateEntered(-34), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'2', 95.95), " +
" (N'157308', Inventory.SetDateEntered(-35), N'Anne Klein', N'Women', N'Jackets', N'Long Sleeve Button Front', N'4', 95.95), " +
" (N'192504', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'40L', 245), " +
" (N'298986', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'36R', 245), " +
" (N'336346', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'36L', 245), " +
" (N'569976', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'38S', 245), " +
" (N'689459', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'38R', 245), " +
" (N'235577', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'44L', 245), " +
" (N'286069', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'40S', 245), " +
" (N'393283', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'44R', 245), " +
" (N'501775', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'42S', 245), " +
" (N'579136', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'42L', 245), " +
" (N'664219', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'44S', 245), " +
" (N'828767', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'42R', 245), " +
" (N'849809', Inventory.SetDateEntered(-35), N'Calvin Klein', N'Men', N'Jackets', N'Slim-Fit Pinstriped Suit Jacket', N'42L', 245), " +
" (N'290699', Inventory.SetDateEntered(-35), N'Ralph Lauren', N'Women', N'Shoes', N'Whip Snake Print Perfect Pumps', N'6.5', 198), " +
" (N'379367', Inventory.SetDateEntered(-36), N'Calvin Klein', N'Men', N'Shoes', N'Hervey Square-Toe Leather Loafers', N'11', 100), " +
" (N'589691', Inventory.SetDateEntered(-36), N'Calvin Klein', N'Men', N'Shoes', N'Hervey Square-Toe Leather Loafers', N'10.5', 100); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'938475', Inventory.SetDateEntered(-36), N'Women', N'Jackets', N'Crepe Lulu Jacket', 2, 155.00), " +
" (N'706408', Inventory.SetDateEntered(-36), N'Women', N'Jackets', N'Crepe Lulu Jacket', 4, 155.00), " +
" (N'959370', Inventory.SetDateEntered(-36), N'Women', N'Jackets', N'Tweed Frayed Jacket', 6, 195.95), " +
" (N'203859', Inventory.SetDateEntered(-36), N'Women', N'Jackets', N'Tweed Frayed Jacket', 7, 195.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'713729', Inventory.SetDateEntered(-40), N'Giorgio Armani', N'Men', N'Shoes', N'Acqua Di Gio After Shave Balm', 49.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'565660', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Men', N'Jackets', N'Cotton Seersucker Suit Jacket', N'43R', 294.95), " +
" (N'657992', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Men', N'Jackets', N'Cotton Seersucker Suit Jacket', N'40L', 294.95), " +
" (N'925726', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Men', N'Jackets', N'Cotton Seersucker Suit Jacket', N'38S', 294.95), " +
" (N'236299', Inventory.SetDateEntered(-40), N'Calvin Klein', N'Women', N'Jackets', N'Linen Moto Jacket', N'S', 74.85), " +
" (N'265718', Inventory.SetDateEntered(-40), N'Calvin Klein', N'Women', N'Jackets', N'Linen Moto Jacket', N'L', 74.85), " +
" (N'267678', Inventory.SetDateEntered(-40), N'Calvin Klein', N'Women', N'Jackets', N'Linen Moto Jacket', N'XS', 74.85), " +
" (N'544867', Inventory.SetDateEntered(-40), N'Calvin Klein', N'Women', N'Jackets', N'Linen Moto Jacket', N'XL', 74.85), " +
" (N'729561', Inventory.SetDateEntered(-40), N'Calvin Klein', N'Women', N'Jackets', N'Linen Moto Jacket', N'M', 74.85), " +
" (N'101029', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Women', N'Jackets', N'Reversible Printed Bolero Jacket', N'M', 185), " +
" (N'338224', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Women', N'Jackets', N'Reversible Printed Bolero Jacket', N'XS', 185), " +
" (N'396363', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Women', N'Jackets', N'Reversible Printed Bolero Jacket', N'L', 185), " +
" (N'867128', Inventory.SetDateEntered(-40), N'Kenneth Cole Reaction', N'Women', N'Jackets', N'Reversible Printed Bolero Jacket', N'S', 185), " +
" (N'807723', Inventory.SetDateEntered(-40), N'Nautica', N'Men', N'Sweaters', N'Wool Crewneck Sweater', N'XL', 22.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'519183', Inventory.SetDateEntered(-41), N'Men', N'Age Rescue Face Lotion For Men', 34.50), " +
" (N'647855', Inventory.SetDateEntered(-41), N'Women', N'Feather Print Silk Scarf', 64.85); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'379114', Inventory.SetDateEntered(-41), N'Calvin Klein', N'Men', N'Suits', N'Navy Solid Suit', N'36 Regular', 790), " +
" (N'558618', Inventory.SetDateEntered(-41), N'Tommy Hilfiger', N'Men', N'Sweaters', N'Ocean Avenue V-Neck Sweater', N'L', 58.85), " +
" (N'615786', Inventory.SetDateEntered(-41), N'Tommy Hilfiger', N'Men', N'Sweaters', N'Ocean Avenue V-Neck Sweater', N'M', 58.85), " +
" (N'766782', Inventory.SetDateEntered(-41), N'Tommy Hilfiger', N'Men', N'Sweaters', N'Ocean Avenue V-Neck Sweater', N'XL', 58.85), " +
" (N'917635', Inventory.SetDateEntered(-41), N'Tommy Hilfiger', N'Men', N'Sweaters', N'Ocean Avenue V-Neck Sweater', N'S', 58.85), " +
" (N'114289', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'4', 325), " +
" (N'148287', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'6', 325), " +
" (N'863902', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'0', 325), " +
" (N'906797', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'8', 325), " +
" (N'941787', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'12', 325), " +
" (N'943062', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'10', 325), " +
" (N'979825', Inventory.SetDateEntered(-41), N'Kenneth Cole', N'Women', N'Jackets', N'Three-Quarter Sleeve Jacket', N'2', 325), " +
" (N'158078', Inventory.SetDateEntered(-42), N'Anne Klein', N'Women', N'Skirts', N'Lace Overlay Skirt', N'8', 68.85), " +
" (N'287388', Inventory.SetDateEntered(-42), N'Anne Klein', N'Women', N'Skirts', N'Lace Overlay Skirt', N'4', 68.85), " +
" (N'874505', Inventory.SetDateEntered(-42), N'Anne Klein', N'Women', N'Skirts', N'Lace Overlay Skirt', N'6', 68.85), " +
" (N'174596', Inventory.SetDateEntered(-42), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Cotton Shawl Pullover', N'L', 135), " +
" (N'508133', Inventory.SetDateEntered(-42), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Cotton Shawl Pullover', N'S', 135), " +
" (N'514898', Inventory.SetDateEntered(-42), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Cotton Shawl Pullover', N'M', 135), " +
" (N'684712', Inventory.SetDateEntered(-42), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Cotton Shawl Pullover', N'XL', 135), " +
" (N'934645', Inventory.SetDateEntered(-42), N'Polo Ralph Lauren', N'Men', N'Sweaters', N'Long-Sleeved Cotton Shawl Pullover', N'XXL', 135); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, ItemName, UnitPrice) " +
"VALUES(N'486181', Inventory.SetDateEntered(-42), N'Women', N'Women Floppy Hat ', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'118181', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'10.5', 95.95), " +
" (N'139992', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'11.5', 95.95), " +
" (N'516517', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'9.5', 95.95), " +
" (N'614274', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'8.5', 95.95), " +
" (N'699363', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'11', 95.95), " +
" (N'789650', Inventory.SetDateEntered(-44), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'8', 95.95), " +
" (N'388663', Inventory.SetDateEntered(-45), N'Lauren by Ralph Lauren', N'Women', N'Belts', N'Braided Leather Belt', N'Medium', 54.25), " +
" (N'888334', Inventory.SetDateEntered(-45), N'Lauren by Ralph Lauren', N'Women', N'Belts', N'Braided Leather Belt', N'Large', 54.25), " +
" (N'211771', Inventory.SetDateEntered(-45), N'Ralph Lauren', N'Women', N'Dresses', N'Petite Knit Tweed Short Sleeve Dress', N'12', 159.5), " +
" (N'509208', Inventory.SetDateEntered(-45), N'Ralph Lauren', N'Women', N'Dresses', N'Petite Knit Tweed Short Sleeve Dress', N'6', 159.5), " +
" (N'744621', Inventory.SetDateEntered(-45), N'Ralph Lauren', N'Women', N'Dresses', N'Petite Knit Tweed Short Sleeve Dress', N'10', 159.5), " +
" (N'189150', Inventory.SetDateEntered(-47), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'L', 195), " +
" (N'184876', Inventory.SetDateEntered(-47), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'XS', 195), " +
" (N'297627', Inventory.SetDateEntered(-47), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'M', 195), " +
" (N'300131', Inventory.SetDateEntered(-48), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Mesh Polo Shirt', N'X-Large', 86.50), " +
" (N'732695', Inventory.SetDateEntered(-48), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Mesh Polo Shirt', N'Small', 86.50), " +
" (N'863909', Inventory.SetDateEntered(-48), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Mesh Polo Shirt', N'Medium', 86.50), " +
" (N'175162', Inventory.SetDateEntered(-48), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'High-Low Colorblocked Skirt', N'L', 74.95), " +
" (N'570278', Inventory.SetDateEntered(-48), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'High-Low Colorblocked Skirt', N'XS', 74.95), " +
" (N'574956', Inventory.SetDateEntered(-48), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'High-Low Colorblocked Skirt', N'M', 74.95), " +
" (N'961347', Inventory.SetDateEntered(-48), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'High-Low Colorblocked Skirt', N'S', 74.95), " +
" (N'631015', Inventory.SetDateEntered(-49), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'S', 195), " +
" (N'959431', Inventory.SetDateEntered(-49), N'Calvin Klein', N'Women', N'Coats', N'Long-Sleeved Trench Coat', N'XL', 195), " +
" (N'484103', Inventory.SetDateEntered(-49), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'10', 95.95), " +
" (N'679524', Inventory.SetDateEntered(-49), N'Johnston and Murphy', N'Men', N'Shoes', N'Tassel Loafers', N'9', 95.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'873194', Inventory.SetDateEntered(-50), N'Johnston and Murphy', N'Men', N'Watches', N'Boyfriend Square Bracelet Watch', 325), " +
" (N'442236', Inventory.SetDateEntered(-50), N'Johnston and Murphy', N'Men', N'Watches', N'Boyfriend Square Strap Watch', 250); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'362554', Inventory.SetDateEntered(-50), N'Lacoste', N'Men', N'Sweaters', N'Cotton V-neck Striped Sweater', N'X-Large', 68.85), " +
" (N'447334', Inventory.SetDateEntered(-50), N'Lacoste', N'Men', N'Sweaters', N'Cotton V-neck Striped Sweater', N'Large', 68.85), " +
" (N'612464', Inventory.SetDateEntered(-50), N'Lacoste', N'Men', N'Sweaters', N'Cotton V-neck Striped Sweater', N'Medium', 68.85), " +
" (N'663507', Inventory.SetDateEntered(-50), N'Lacoste', N'Men', N'Sweaters', N'Cotton V-neck Striped Sweater', N'Small', 68.85), " +
" (N'680374', Inventory.SetDateEntered(-50), N'Lacoste', N'Men', N'Sweaters', N'Cotton V-neck Striped Sweater', N'XX-Large', 68.85), " +
" (N'200258', Inventory.SetDateEntered(-50), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Cotton Polo Shirt', N'L', 20), " +
" (N'516601', Inventory.SetDateEntered(-50), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Cotton Polo Shirt', N'L', 20), " +
" (N'609914', Inventory.SetDateEntered(-50), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Cotton Polo Shirt', N'M', 20), " +
" (N'849230', Inventory.SetDateEntered(-50), N'Lauren by Ralph Lauren', N'Men', N'Shirts', N'Short-Sleeved Cotton Polo Shirt', N'XL', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, ItemName, UnitPrice) " +
"VALUES(N'204693', Inventory.SetDateEntered(-50), N'Wood-Handle Auto Umbrella', 20); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'665325', Inventory.SetDateEntered(-51), N'Polo Ralph Lauren', N'Men', N'Pants', N'5-Pocket Vintage Chinos ', N'38W - 34L', 74.50), " +
" (N'766689', Inventory.SetDateEntered(-51), N'Polo Ralph Lauren', N'Men', N'Pants', N'5-Pocket Vintage Chinos ', N'38W - 32L', 74.50), " +
" (N'997448', Inventory.SetDateEntered(-51), N'Polo Ralph Lauren', N'Men', N'Pants', N'5-Pocket Vintage Chinos ', N'40W - 32L', 74.50), " +
" (N'186223', Inventory.SetDateEntered(-51), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Long-Sleeved Polo', N'L', 88.85), " +
" (N'382614', Inventory.SetDateEntered(-51), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Long-Sleeved Polo', N'XL', 88.85), " +
" (N'771535', Inventory.SetDateEntered(-51), N'Collentra Studio', N'Women', N'Hats', N'Straw Wraparound Hat - Black', N'S', 15), " +
" (N'149696', Inventory.SetDateEntered(-51), N'Collentra Studio', N'Women', N'Hats', N'Straw Wraparound Hat - Red', N'S', 15), " +
" (N'331381', Inventory.SetDateEntered(-51), N'Collentra Studio', N'Women', N'Hats', N'Straw Wraparound Hat - White', N'S', 15); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'673905', Inventory.SetDateEntered(-51), N'Calvin Klein', N'Women', N'Accessories', N'Metal Aviator Sunglasses', 80); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'179384', Inventory.SetDateEntered(-52), N'Women', N'Skirts', N'Floral Persuasion Print Skirt', 6, 88.25), " +
" (N'820348', Inventory.SetDateEntered(-52), N'Women', N'Skirts', N'Floral Persuasion Print Skirt', 8, 88.25); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'247742', Inventory.SetDateEntered(-53), N'Kenneth Cole New York', N'Women', N'Coats', N'Hooded Wool Peacoat', N'10', 265.85), " +
" (N'112055', Inventory.SetDateEntered(-55), N'Anne Klein', N'Women', N'Dresses', N'Eyelet Shirtdress', N'10', 214.85), " +
" (N'580400', Inventory.SetDateEntered(-55), N'Anne Klein', N'Women', N'Dresses', N'Eyelet Shirtdress', N'6', 214.85), " +
" (N'443516', Inventory.SetDateEntered(-58), N'AK Anne Klein', N'Women', N'Skirts', N'Seamless Textured Pencil Skirt', N'L', 65.95), " +
" (N'830487', Inventory.SetDateEntered(-58), N'AK Anne Klein', N'Women', N'Skirts', N'Seamless Textured Pencil Skirt', N'S', 65.95), " +
" (N'384925', Inventory.SetDateEntered(-59), N'Kenneth Cole Reaction', N'Men', N'Shirts', N'Slim Fit Mercer Tonal Stripe', N'16 32/33', 36.75), " +
" (N'945214', Inventory.SetDateEntered(-60), N'Collentra Studio', N'Women', N'Belts', N'Hammered Buckle Belt', N'2', 35), " +
" (N'979040', Inventory.SetDateEntered(-60), N'Collentra Studio', N'Women', N'Belts', N'Hammered Buckle Belt', N'4', 35), " +
" (N'477444', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'11M', 75), " +
" (N'635069', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'11.5M', 75), " +
" (N'770415', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'8M', 75), " +
" (N'900478', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'10.5M', 75), " +
" (N'980605', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'9.5M', 75), " +
" (N'992851', Inventory.SetDateEntered(-61), N'Guess', N'Men', N'Shoes', N'Carver Driver Shoes', N'10M', 75), " +
" (N'501886', Inventory.SetDateEntered(-61), N'Collentra Studio', N'Women', N'Belts', N'Hammered Buckle Belt', N'3', 35), " +
" (N'668434', Inventory.SetDateEntered(-61), N'Collentra Studio', N'Women', N'Belts', N'Hammered Buckle Belt', N'1', 35); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'234539', Inventory.SetDateEntered(-62), N'Lacoste', N'Men', N'Beauty and Grooming', N'L.12.12 Fragrance Collection for Men', 64.5), " +
" (N'909700', Inventory.SetDateEntered(-62), N'Cole Haan', N'Men', N'Watches', N'Mens Two-Tone Solar Dress Watch', 255.5); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'247488', Inventory.SetDateEntered(-64), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'XL', 85), " +
" (N'426715', Inventory.SetDateEntered(-64), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'S', 85), " +
" (N'469288', Inventory.SetDateEntered(-64), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'L', 85), " +
" (N'477573', Inventory.SetDateEntered(-64), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Mesh Polo', N'M', 85), " +
" (N'751249', Inventory.SetDateEntered(-65), N'Kenneth Cole Reaction', N'Women', N'Shoes', N'Satin T-Strap Shoes', N'8', 69.95), " +
" (N'348132', Inventory.SetDateEntered(-65), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'36R', 245), " +
" (N'429520', Inventory.SetDateEntered(-65), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'44R', 245), " +
" (N'450985', Inventory.SetDateEntered(-65), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'40L', 245), " +
" (N'111824', Inventory.SetDateEntered(-70), N'Calvin Klein', N'Women', N'Belts', N'Reversible Leather Belt', N'Medium', 35), " +
" (N'272204', Inventory.SetDateEntered(-70), N'Calvin Klein', N'Women', N'Belts', N'Reversible Leather Belt', N'Large', 35), " +
" (N'339630', Inventory.SetDateEntered(-70), N'Calvin Klein', N'Women', N'Belts', N'Reversible Leather Belt', N'Large', 35), " +
" (N'698191', Inventory.SetDateEntered(-70), N'Calvin Klein', N'Women', N'Belts', N'Reversible Leather Belt', N'X-Large', 35), " +
" (N'198802', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'0', 235), " +
" (N'346072', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'14', 235), " +
" (N'409570', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'4', 235), " +
" (N'441825', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'8', 235), " +
" (N'473715', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'6', 235), " +
" (N'539449', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'12', 235), " +
" (N'714075', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'2', 235), " +
" (N'945453', Inventory.SetDateEntered(-71), N'AK Anne Klein', N'Women', N'Skirts', N'Pleated Orphist Skirt', N'10', 235), " +
" (N'404120', Inventory.SetDateEntered(-71), N'Clarks', N'Women', N'Shoes', N'Savoy Leather Thong Sandals', N'8.5', 78.85), " +
" (N'526344', Inventory.SetDateEntered(-71), N'Clarks', N'Women', N'Shoes', N'Savoy Leather Thong Sandals', N'6.5', 78.85), " +
" (N'738893', Inventory.SetDateEntered(-71), N'Clarks', N'Women', N'Shoes', N'Savoy Leather Thong Sandals', N'7', 78.85), " +
" (N'783016', Inventory.SetDateEntered(-71), N'Clarks', N'Women', N'Shoes', N'Savoy Leather Thong Sandals', N'7.5', 78.85), " +
" (N'843711', Inventory.SetDateEntered(-74), N'Anne Klein', N'Women', N'Dresses', N'Ivy Color-Blocked Sweater Dress', N'XS', 195.95), " +
" (N'884084', Inventory.SetDateEntered(-74), N'Anne Klein', N'Women', N'Dresses', N'Ivy Color-Blocked Sweater Dress', N'S', 195.95), " +
" (N'303471', Inventory.SetDateEntered(-74), N'Anne Klein', N'Women', N'Dresses', N'Ivy Color-Blocked Sweater Dress', N'M', 195.95), " +
" (N'972441', Inventory.SetDateEntered(-74), N'Anne Klein', N'Women', N'Dresses', N'Ivy Color-Blocked Sweater Dress', N'L', 195.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'419628', Inventory.SetDateEntered(-74), N'Cole Haan', N'Women', N'Handbags', N'Zip-Top Tote Bag', 298), " +
" (N'768031', Inventory.SetDateEntered(-74), N'Cole Haan', N'Women', N'Handbags', N'Zip-Top Tote Handbag', 298); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'115389', Inventory.SetDateEntered(-74), N'Kenneth Cole Reaction', N'Women', N'Coats', N'Black 2-Button Notch-Collar Suit', N'8', 199.9); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'760085', Inventory.SetDateEntered(-74), N'Johnston and Murphy', N'Women', N'Watches', N'Boyfriend Bracelet Watch', 325.95), " +
" (N'990064', Inventory.SetDateEntered(-74), N'Timex', N'Women', N'Watches', N'Boyfriend Bracelet Watch', 325.95), " +
" (N'559610', Inventory.SetDateEntered(-74), N'Kenneth Cole', N'Women', N'Accessories', N'Tulle Blooms Luxe Scarf', 59.95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'800979', Inventory.SetDateEntered(-78), N'Calvin Klein', N'Women', N'Coats', N'Double Breasted Stand-Up Collar Coat', N'14', 230), " +
" (N'908259', Inventory.SetDateEntered(-78), N'Calvin Klein', N'Women', N'Coats', N'Double Breasted Stand-Up Collar Coat', N'8', 230), " +
" (N'323886', Inventory.SetDateEntered(-78), N'CK Calvin Klein', N'Women', N'Jackets', N'Tweed Power Jacket', N'6', 248), " +
" (N'887537', Inventory.SetDateEntered(-78), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'38S', 245), " +
" (N'399871', Inventory.SetDateEntered(-78), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'44L', 245), " +
" (N'439110', Inventory.SetDateEntered(-79), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'M', 95), " +
" (N'531039', Inventory.SetDateEntered(-79), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'S', 95), " +
" (N'580984', Inventory.SetDateEntered(-82), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'L', 95), " +
" (N'178032', Inventory.SetDateEntered(-83), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Short-Sleeved Ruched Dress', N'4', 39.95), " +
" (N'186973', Inventory.SetDateEntered(-83), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Short-Sleeved Ruched Dress', N'6', 39.95), " +
" (N'326636', Inventory.SetDateEntered(-83), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Short-Sleeved Ruched Dress', N'3/3T ', 39.95), " +
" (N'328939', Inventory.SetDateEntered(-83), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Short-Sleeved Ruched Dress', N'5', 39.95), " +
" (N'831753', Inventory.SetDateEntered(-83), N'Ralph Lauren', N'Girls', N'Dresses', N'Girls 2-6x Short-Sleeved Ruched Dress', N'2/2T ', 39.95), " +
" (N'680552', Inventory.SetDateEntered(-88), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'L', 95), " +
" (N'813739', Inventory.SetDateEntered(-88), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'XL', 95); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'384857', Inventory.SetDateEntered(-92), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Boatneck Linen Dress', N'S', 165), " +
" (N'747185', Inventory.SetDateEntered(-92), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Boatneck Linen Dress', N'M', 165), " +
" (N'768787', Inventory.SetDateEntered(-92), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Boatneck Linen Dress', N'XS', 165), " +
" (N'781506', Inventory.SetDateEntered(-92), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Boatneck Linen Dress', N'L', 165), " +
" (N'803277', Inventory.SetDateEntered(-92), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'Boatneck Linen Dress', N'XL', 165), " +
" (N'604394', Inventory.SetDateEntered(-94), N'Clarks', N'Women', N'Shoes', N'Shilo Pumps', N'8.5', 325), " +
" (N'522315', Inventory.SetDateEntered(-94), N'Clarks', N'Women', N'Shoes', N'Shilo Pumps', N'7.5', 325), " +
" (N'402412', Inventory.SetDateEntered(-94), N'Calvin Klein', N'Women', N'Shoes', N'April Strappy Stiletto Sandals', N'6', 99.95), " +
" (N'989941', Inventory.SetDateEntered(-94), N'Calvin Klein', N'Women', N'Shoes', N'April Strappy Stiletto Sandals', N'8', 99.95), " +
" (N'932427', Inventory.SetDateEntered(-95), N'Lauren by Ralph Lauren', N'Women', N'Skirts', N'Jem Skirt', N'S', 115); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'358885', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Mini Wilson Leather Shopper Handbag', 298), " +
" (N'405311', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Mini Wilson Leather Shopper Handbag', 298), " +
" (N'911286', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Mini Wilson Leather Shopper Handbag', 298), " +
" (N'969227', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Mini Wilson Leather Shopper Handbag', 298), " +
" (N'513067', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Nylon Tote Handbag', 198), " +
" (N'528797', Inventory.SetDateEntered(-98), N'Cole Haan', N'Women', N'Handbags', N'Nylon Tote Handbag', 198); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'254770', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'0', 148.85), " +
" (N'692215', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'2', 148.85), " +
" (N'202539', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'14', 148.85), " +
" (N'254803', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'10', 148.85), " +
" (N'255895', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'12', 148.85), " +
" (N'259124', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'8', 148.85), " +
" (N'624142', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'4', 148.85), " +
" (N'992864', Inventory.SetDateEntered(-104), N'Lauren by Ralph Lauren', N'Women', N'Dresses', N'One Shoulder Draped Evening Dress', N'6', 148.85), " +
" (N'639546', Inventory.SetDateEntered(-110), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'6', 188.85), " +
" (N'983143', Inventory.SetDateEntered(-110), N'Ralph Lauren', N'Women', N'Dresses', N'Sleeveless Pleated Lace A-Line', N'8', 188.85), " +
" (N'185283', Inventory.SetDateEntered(-112), N'Ralph Lauren', N'Baby Boys', N'Jackets', N'Baby Boys 12-24 Months Richmond Bomber Jacket', N'18M', 64); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'380462', Inventory.SetDateEntered(-112), N'Ralph Lauren', N'Baby Boys', N'Jackets', N'Baby Boys 12-24 Months Richmond Bomber Jacket', 64); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'393780', Inventory.SetDateEntered(-112), N'Ralph Lauren', N'Baby Boys', N'Jackets', N'Baby Boys 12-24 Months Richmond Bomber Jacket', N'24M', 64), " +
" (N'959535', Inventory.SetDateEntered(-112), N'Ralph Lauren', N'Baby Boys', N'Jackets', N'Baby Boys 12-24 Months Richmond Bomber Jacket', N'9M', 64); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, ItemSize, UnitPrice) " +
"VALUES(N'280076', Inventory.SetDateEntered(-112), N'Juaro Collections', N'Women', N'Hats', N'Newport Bow Hat', N'', 25), " +
" (N'152896', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'S', 75), " +
" (N'342899', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'M', 75), " +
" (N'540567', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'L', 75), " +
" (N'605653', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'L', 75), " +
" (N'885700', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'M', 75), " +
" (N'912196', Inventory.SetDateEntered(-113), N'Polo Ralph Lauren', N'Men', N'Shirts', N'Classic-Fit Short-Sleeved Cotton Interlock Polo Shirt', N'M', 75), " +
" (N'144169', Inventory.SetDateEntered(-115), N'Ralph Lauren', N'Girls', N'Skirts', N'Girls 2-6x Pull-On Ruffle Skirt', N'2/2T ', 39.85), " +
" (N'241375', Inventory.SetDateEntered(-115), N'Ralph Lauren', N'Girls', N'Skirts', N'Girls 2-6x Pull-On Ruffle Skirt', N'3/3T ', 39.85), " +
" (N'279032', Inventory.SetDateEntered(-115), N'Ralph Lauren', N'Girls', N'Skirts', N'Girls 2-6x Pull-On Ruffle Skirt', N'4', 39.85), " +
" (N'352550', Inventory.SetDateEntered(-118), N'Nautica', N'Men', N'Sweaters', N'Long-Sleeved V-Neck Cardigan', N'M', 44.85), " +
" (N'199749', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'44S', 245), " +
" (N'238405', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'42S', 245), " +
" (N'289297', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'48R', 245), " +
" (N'618333', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'42L', 245), " +
" (N'710856', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'48L', 245), " +
" (N'766147', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'36S', 245), " +
" (N'787880', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'42R', 245), " +
" (N'873083', Inventory.SetDateEntered(-121), N'Calvin Klein', N'Men', N'Jackets', N'Wool Slim-Fit Suit Jacket', N'40S', 245), " +
" (N'116969', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'XS', 95), " +
" (N'152729', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'S', 95), " +
" (N'248495', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'XL', 95), " +
" (N'251576', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'L', 95), " +
" (N'398442', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'M', 95), " +
" (N'800297', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'XS', 95), " +
" (N'820564', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'M', 95), " +
" (N'896229', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'L', 95), " +
" (N'906068', Inventory.SetDateEntered(-124), N'Calvin Klein', N'Women', N'Jackets', N'Anorat Jacket', N'M', 95), " +
" (N'136843', Inventory.SetDateEntered(-124), N'AK Anne Klein', N'Women', N'Watches', N'Ladies White Ceramic Crystal Bezel Watch', N'No Size', 195); " +
"INSERT INTO Inventory.StoreItems(ItemNumber, DateEntered, Manufacturer, Category, SubCategory, ItemName, UnitPrice) " +
"VALUES(N'491437', Inventory.SetDateEntered(-124), N'Lauren by Ralph Lauren', N'Women', N'Handbags', N'Leather Mini Shoulder Handbag', 298);",
cntFunDS);
cntFunDS.Open();
cmdDatabase.ExecuteNonQuery();
MessageBox.Show("The tables have been created and the record have been added to them.",
"College Park Auto Repair",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}