The Vegas Tours Souvenir Shop is where Las Vegas bus tours start and end, seven days a week. The shop sells a variety of Vegas souvenirs to customers who take the tour and to those who simply want to purchase souvenirs. Management has been using an Access database to keep track of customers, products, and transactions. You have been given some sample sales data from February 2015. Management has asked you to create some queries to begin the process of analyzing the data that has been collected. 1. A series of SQL statements were made from the tables in the Access database. The SQL script contains CREATE TABLE statements as well as INSERT statements to populate the tables. Download the SQL script, VegasToursScript.Sql, from Blackboard, open and run the query in the Azure database. 2. Create a query based on the tblProduct table that will display the ProductID, ProductDescription, QuantityInStock, Cost, Size, and Color, in that order, for any product with shirt in the ProductDescription field. 3. Sort the results in Descending order by Cost (ORDER BY field DESC). Save the query as qryShirtInventory. 4. Create a query based on the tblProduct table that will display the ProductID, ProductDescription, Category, QuantityInStock, Cost, Size, Color, and a new calculated field named Retail Price, in that order. In the Retail Price field, use the Round function (ROUND(calculation,# of decimal places)) to display the price that the store needs to sell its products. The retail price is two times the cost. Save the query as qryRetailPrice 5. Create a query based on the tblCustomer table that will display the FirstName, LastName, Address, City, State, and ZipCode, in that order. Include customers whose last names begin with letters M through Z. 6. Sort the results in Ascending order by LastName. Save your query as qryMZCustomers. 7. Create a query based on the tblCustomer and tblPurchase tables that will concatenate the members first and last names (separated by a space) followed by the date they made a purchase. (CONCAT(field1,field2,etc) Name the concatenated field Purchase Details. Use a comma to separate the full name and date, in that order. Save your query as qryPurchaseDetails. 8. Create a query based on the tblPurchase and tblPurchaseLine tables that will display the PurchaseID, PurchaseDate, PurchaseLine, ProductID, and Quantity in that order to view all transactions. Sort the records by PurchaseDate. Save your query as qryPurchaseDate 9. Submit the 5 queries (qryShirtInventory, qryRetailPrice, qryMZCustomers, qryPurchaseDetails, qryPurchaseDate), through the Assignment link.

ROP TABLE tblPurchaseLine;

DROP TABLE tblPurchase;

DROP TABLE tblCustomer;

DROP TABLE tblProduct;

/****** Object: Table [dbo].[tblCustomer] Script Date: 3/6/2018 3:09:18 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblCustomer](

[CustomerID] [int] IDENTITY(1,1) NOT NULL,

[FirstName] [nvarchar](20) NULL,

[LastName] [nvarchar](25) NULL,

[Address] [nvarchar](40) NULL,

[City] [nvarchar](25) NULL,

[State] [nvarchar](2) NULL,

[ZipCode] [nvarchar](5) NULL,

[Tour] [bit] NULL,

[mSysRowId] [nvarchar](255) NULL,

CONSTRAINT tblCustomer_PK PRIMARY KEY (CustomerID)

)

GO

/****** Object: Table [dbo].[tblProduct] Script Date: 3/6/2018 3:09:18 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblProduct](

[ProductID] [int] IDENTITY(1,1) NOT NULL,

[ProductDescription] [nvarchar](40) NULL,

[Category] [nvarchar](15) NULL,

[QuantityInStock] [smallint] NULL,

[Cost] [money] NULL,

[Size] [nvarchar](10) NULL,

[Color] [nvarchar](15) NULL,

[mSysRowId] [nvarchar](255) NULL,

CONSTRAINT tblProduct_PK PRIMARY KEY (ProductID)

)

GO

/****** Object: Table [dbo].[tblPurchase] Script Date: 3/6/2018 3:09:18 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblPurchase](

[PurchaseID] [int] IDENTITY(1,1) NOT NULL,

[PurchaseDate] [datetime] NULL,

[CustomerID] [int] NULL,

[mSysRowId] [nvarchar](255) NULL,

CONSTRAINT tblPurchase_PK PRIMARY KEY (PurchaseID),

CONSTRAINT PurchaseCustomer_FK1 FOREIGN KEY (CustomerID) REFERENCES tblCustomer(CustomerID)

)

GO

/****** Object: Table [dbo].[tblPurchaseLine] Script Date: 3/6/2018 3:09:18 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblPurchaseLine](

[PurchaseID] [int] NULL,

[PurchaseLine] [int] IDENTITY(1,1) NOT NULL,

[ProductID] [int] NULL,

[Quantity] [int] NULL,

[mSysRowId] [nvarchar](255) NULL,

CONSTRAINT tblPurchaseLine_PK PRIMARY KEY (PurchaseLine),

CONSTRAINT PurchaseLinePurchase_FK1 FOREIGN KEY (PurchaseID) REFERENCES tblPurchase(PurchaseID),

CONSTRAINT PurchaseLineProduct_FK1 FOREIGN KEY (ProductID) REFERENCES tblProduct(ProductID)

)

GO

SET IDENTITY_INSERT [dbo].[tblCustomer] ON

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (1, N'Trace', N'Debrow', N'3530 S Main St', N'Potomac', N'MD', N'20854', 1, N'AvXzCMNTBz8pYQML84Wx+rd4B8g2KzvkbCZiNK55UZo=-~sK6LR+LkChVqOqqrrq5+Zw==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (2, N'Cynthia', N'Bryant', N'304 Obispo Canyon', N'Arroyo Grande', N'CA', N'93420', 1, N'UWI5YcXdfhCi35+eUqrQOaPtVnhMY+dwAWAMY3sKVZ8=-~jbu/8awyzX2aB6vamz/Qew==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (3, N'John', N'Peters', N'56 Lake Drive', N'Blue Lake', N'CA', N'95525', 1, N'ad7C7+aLxPtmBH0r2Ty8C8ByHhUk9N3bXMGMpgT2j5Y=-~cicNRIjjJYeWdsQ6yax9qg==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (4, N'Jessica', N'Nguyen', N'4003 Ridge Road', N'Dallas', N'TX', N'75217', 1, N'4jCbBw6uYrRU1g81Zm8gcaGp4GdBJJVqkleBglN8wgU=-~z1G95gPQhyOj+6bKORne8w==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (5, N'Greg', N'Richardson', N'1030 Presidio Road', N'Albuquerque', N'NM', N'87114', 0, N'mUrq6H4sxwM1c9mAjPkV9VohPCBWGxSIMxA3vy8clCY=-~WC7hkSO1JR2NyAZ6bej5sw==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (6, N'Jenny', N'Branson', N'3223 El Grande Ln', N'La Mesa', N'CA', N'92010', 1, N'V6b22lbZYnR27hGvwwrmxPPXttelko3HMbmOlHczCks=-~NyhPcNSKpdMRNiHNtasPGg==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (7, N'Sara', N'Trumbull', N'544 E. Westerly St', N'Ann Arbor', N'MI', N'48104', 0, N'n8jPm3V9RQi9v3WcDUboeKpfkeFnqvuO225Bik8jJGg=-~IwY6FrLXQuv/+oEDMjHWJQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (8, N'James', N'Ford', N'6127 Fender Dr', N'Cranbury', N'NJ', N'07815', 1, N'xVw0DtFLKUHZf5qlSgdt/lJyr0onZ4XtScY3kH1SlDY=-~QhvMuJ1NbtZA1Ko+LVqixA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (9, N'Elaine', N'Griffin', N'134 Desert Ln', N'San Luis', N'AZ', N'85350', 1, N'xY+PioVtW9MVlINvDy3FY/C1Dno1o+AIdBz+NCbxyc0=-~we8MfDn59+mJBEx1OeRJYA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (10, N'Harry', N'Preston', N'455 Fredonia Ave', N'Herkimer', N'NY', N'15253', 0, N'BMRU3HUqkeHzqFaSBFWg4/pPssFh07f33iMpha88XbE=-~aNx5BCkZek2OT2kszqAvPw==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (11, N'Erin', N'Thomas', N'9214 Cardinal Ln', N'Fairfax', N'VA', N'23020', 1, N'//y7/sqBANL/bsnhEo4QtP5XMzRSVtwcLphMIUk++wM=-~rfcBE1uX7PjMwhSP8SOQnQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (12, N'Jack', N'Dixon', NULL, NULL, NULL, NULL, 0, N'tbrsKuE7Mcw2AWJOGxxMqED2IPVYIwY2DgB8iU+l7kM=-~eno3vUAMlP14Qd4osLulKQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (13, N'Cheryl', N'Montaigne', N'713 Diablo St', N'Sandiston', N'OH', N'44301', 1, N'6/p+4GsJ6IjUc5tcto+SOkMRi4TNLB6JyKG+IGROyq0=-~qelU8bnaF2VhPvIzbtDl4Q==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (14, N'Mark', N'Mason', N'104 Treasure Ln', N'Brookline', N'MA', N'02445', 0, N'ci/3yvj8FvxJOCKgPzFAzs2MLRCpkICR6KzfMh4BiRs=-~c9in9NXXT53WCRCZ9LZQFA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (15, N'Chris', N'Serway', N'2575 Purdy St', N'Fanwood', N'NJ', N'07023', 1, N'6h+Q2ULutLsfjwoV+bx0CCOBAT+qJN8DPq91/zFD/qA=-~Z8Y7ofpCf2sn5JPXknBhuA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (16, N'Coby', N'Alvarado', N'544-8187 Praesent Rd.', N'Menomonee Falls', N'IA', N'72490', 1, N'/a0KQBIU1nrhgEcG8bRxZHb3Mn3LyvE2bg15V8r97e8=-~5rNULvAKRFP0L9BUmE4dBQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (17, N'Anthony', N'Brooks', N'P.O. Box 999, 424 Pharetra. Street', N'Hammond', N'NY', N'49211', 1, N'2Hyi8l3KS1hBuj3VwIErFAPmhHuwTbK7dXtGADxaqAA=-~OqlV94KS3KB2lmZYIcg+kw==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (18, N'Erich', N'Green', NULL, NULL, NULL, NULL, 1, N'U4JudXycBOuf9o4SvHiY4UtbTTrOUAelLeh8d+/ZTiM=-~SmnUXlvtpR3Daz5v5HiyvA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (19, N'Jennifer', N'Baker', NULL, NULL, NULL, NULL, 0, N'Iat+HEYIw+7trer65MLU6QmJxQRp6phnpg2ULaI4aYM=-~mfgWlO3ZeskYXb5G95aG7w==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (20, N'Sylvia', N'Vasquez', N'8676 Libero Rd.', N'Palo Alto', N'WA', N'82071', 0, N'vdcuMLupg3sNyd4QKJOUanHZaHud4mYfZfpX4LZbyOA=-~IZxr9LcnDvo0dp2Lerq3mQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (21, N'Kiara', N'Schroeder', N'6508 Dolor Street', N'Arlington', N'MI', N'78934', 0, N'vXqeUGaQE1cMH/4Urnut0R+l198P0xtP+32KoYhRZ/I=-~ODJDnsJD1+R7YDa5G7f0aQ==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (22, N'Kenneth', N'Cole', N'Ap #224-7470 Aliquet Av.', N'Hartford', N'AK', N'94076', 1, N'hY2u2x2i4fzsHu+tO4UTRq5I8zTPgsOEIrQKFjJJMkg=-~erqXWKWmk7boy6kUoVyAdw==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (23, N'Margaret', N'Marks', N'Ap #779-9435 Egestas Avenue', N'Warwick', N'IN', N'13968', 1, N'Tr1F2Q4jn7+VhEWuE61hsuHKyk8FIFUVVObQiJ9U8C8=-~N7M1J1JWMZkHJSj6dHTu/A==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (24, N'Calvin', N'White', N'P.O. Box 549, 2220 Eget Av.', N'Claremore', N'OH', N'23889', 1, N'inGIEwmf+gXVkBw8s50NnTiZfF5T2UcldWxpU7FbsTw=-~VjObQhCuBy0UkTfn8HHXSA==')

INSERT [dbo].[tblCustomer] ([CustomerID], [FirstName], [LastName], [Address], [City], [State], [ZipCode], [Tour], [mSysRowId]) VALUES (25, N'Hyacinth', N'Zamora', N'8255 Risus Avenue', N'Statesboro', N'AK', N'15474', 1, N'F5IpkNJbZS0x8uDWBL2kG5wZLQN0UH9h3AdZgQ+m1K0=-~FBC/1lts3I5s50eGp7yE+w==')

SET IDENTITY_INSERT [dbo].[tblCustomer] OFF

SET IDENTITY_INSERT [dbo].[tblProduct] ON

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (1, N'Key chain (dice)', N'Sundries', 40, 4.9200, NULL, NULL, N'Legp1E62133Ve0EVJCIj5LOr/N4jaU7kk/M+rF1vhW8=-~usCrBB3uFP8k0IIZBx2EHA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (2, N'Key chain (Vegas sign)', N'Sundries', 35, 7.0300, NULL, NULL, N'yXtj1/IDWyFiwg4FXO39JRAkXb3foonPNg21oRO2eXc=-~T3KJHnfHQQhkXb1rR3CMgA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (3, N'Mug (dice)', N'Sundries', 50, 3.2300, NULL, NULL, N'o6T9BoRKYh2Ppu/L2c6pmFETiqq/otfGy3e4mqjP3Gs=-~pTmKqwnsIL0M0IUVRmokeA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (4, N'Mug (Vegas sign)', N'Sundries', 30, 6.6100, NULL, NULL, N'Tfe0Klbo55IMVUMW2cd63eulUVUxriHyu2rwNqW8acA=-~3sRvXkhyceC3Y6lCAyrUAA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (5, N'Poker chips', N'Sundries', 20, 11.4700, NULL, NULL, N'u3U1I1KuE3cGg4YPFK2OFfs19MiB7EdO5Zgw0gVPcjw=-~ub3wGw8ME7RxfyfMaAP1hw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (6, N'Poker set', N'Sundries', 40, 22.4400, NULL, NULL, N'kkXvZPW1djtD1TFAvyKivBiKIRYdPLtL5i9vfQl+UXU=-~dTH46BKEIo/On9VJBWkrTw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (7, N'Snow globe', N'Sundries', 50, 14.7900, NULL, NULL, N'/VNZwxa82OxrID1QAciwCI2qnKi4fR/WPZzL7NwJ8LY=-~AdgVljdLi/pwWy++XC+N2w==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (8, N'LS Sweatshirt', N'Clothing', 20, 7.4200, N'S', N'Black', N'4y098SyoyJozlW1nXbzAE3H+4blfKC8jWODtJQ1SEbI=-~wEnq+MjghHak6//yQ8cJrA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (9, N'LS Sweatshirt', N'Clothing', 17, 14.7900, N'S', N'Red', N'I8vtooZ/KOgF5v1OmWOnr7pBlb+XGx+4vT3J9iRGykA=-~kw8RAKH8/51cp6EYX94V+g==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (10, N'LS Sweatshirt', N'Clothing', 16, 11.4700, N'S', N'Silver', N'qA/wr4+Xd1MMOZC+Crs6CBzTYPv/vGknACV9DVn6I9w=-~MNzJ7iL221QcfuMqXZ0a8w==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (11, N'LS Sweatshirt', N'Clothing', 30, 4.9200, N'M', N'Black', N'4/tDRIEgIRGXDDivloNxq0WcPHvvG/lveef31DAVWQ4=-~ZgvzhrvEJOsNhqvd3tTirA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (12, N'LS Sweatshirt', N'Clothing', 15, 12.0300, N'M', N'Red', N'Ee8ArM/TJ2fgl4uLz2QsPL1btdxaGj6bmt1Fs6MSgCA=-~itASxvOOSVzKjS71Ew0UEw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (13, N'LS Sweatshirt', N'Clothing', 18, 4.9200, N'M', N'Silver', N'uLYAoDvF95OLdXkc9D6MNOoIDDm6szyn3Gfjz57aL40=-~C6wmn9M6UKF1kV1dUqdXuw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (14, N'LS Sweatshirt', N'Clothing', 30, 14.7900, N'L', N'Black', N'2o3UQW4JpDt+OHdjj1Oabl0tTm+UB8xXTYK1RAftFx8=-~7T4gQ3R+z5dP82fi0/+VTA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (15, N'LS Sweatshirt', N'Clothing', 15, 9.2300, N'L', N'Red', N'1PgiWVOM8UU01MhZEgzAk8oyYy21O3G93nkZZRbTIlQ=-~IGxonV/PzA8ceu6y81DRjQ==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (16, N'LS Sweatshirt', N'Clothing', 18, 14.7900, N'L', N'Silver', N'tNA07KVC75tpJ5DJKEHymNBO3DSgWWzrgCjHNPJzGRc=-~Uf6w+solgVtF18bIGvXNdw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (17, N'LS Sweatshirt', N'Clothing', 32, 9.2300, N'XL', N'Black', N'SkTVu07XIHgCehi+tNw8j9l8/4pnGqS9fPKymvlq/N4=-~rOie466/V0zaRCBS3ay0yg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (18, N'LS Sweatshirt', N'Clothing', 17, 11.4700, N'XL', N'Red', N'4Xd21PO4KMDKC3qnF6kkdezffRi4HkK6EMW4uma6pMQ=-~J31iTqClCctEPJHTXctSuw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (19, N'LS Sweatshirt', N'Clothing', 18, 14.7900, N'XL', N'Silver', N'uSmr6jOFZgqSdAA/fGkbShiVw0usa18rcFrzt4hcBgA=-~p1pRhL0JGny3Mg0eOyT+Ew==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (20, N'T-shirt', N'Clothing', 50, 12.0300, N'S', N'Black', N'GVuhSu08pR72t2jwYqp4a8F51LMdxzIAEU2eUwbRQFQ=-~tRRiZjd3p0yLEWklw0sfAg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (21, N'T-shirt', N'Clothing', 24, 7.4200, N'S', N'Red', N'nKr32LS4AYvLmTvo9yPrGj/vI/E4x3GtqZ7JhxjJbNA=-~roxoca0Ux+zjJtBXYYg8TQ==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (22, N'T-shirt', N'Clothing', 33, 14.7900, N'S', N'Silver', N'fPaZdAfbmx+QARiYvCGxnyuYNetqObZxKRG9quHp/eM=-~P5p7QgJORoe8O2gBt79tcg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (23, N'T-shirt', N'Clothing', 60, 9.6100, N'M', N'Black', N'gpOHUd7acpJo9IQ5dYqas7Djuj4cob+1AKEAq8cnKk8=-~ij+LhBu2Vq8/gRRQzWjsvg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (24, N'T-shirt', N'Clothing', 54, 11.4700, N'M', N'Red', N'PyfnglxZGv8ReTkc8hy5Ms2sgUtYPoYU03h0ZhjslzU=-~B6EDiSbMszhbshBSoSxcAA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (25, N'T-shirt', N'Clothing', 57, 12.0300, N'M', N'Silver', N'+8F4ujNBNDK5H6s59csX4NxdrwEqPVsrodj5dklcQzY=-~PTQaN6TAVK6RSWTtMaKZHA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (26, N'T-shirt', N'Clothing', 30, 4.9200, N'L', N'Black', N'AK2Zmx5bpmhVcFlaKEFsjfaFNzXEflQR5UvXARj0Q/o=-~jzfTaOcJtL4KjHKWru56LQ==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (27, N'T-shirt', N'Clothing', 40, 4.9200, N'L', N'Red', N'Ryp2px77Dnb2l78GI0HaiRh0NOqW3GmOMSoX4TAXaY0=-~094IA6AWorfD1a9u88t9Nw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (28, N'T-shirt', N'Clothing', 20, 11.4700, N'L', N'Silver', N'7U8/OWz5RX9B4bPOamL94EsWD6c82SM3ICuyFEkeNx0=-~0hRDwh0EASwHlYBfp7CvBw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (29, N'T-shirt', N'Clothing', 15, 11.4700, N'XL', N'Black', N'qQrecm5dXAioazpP2cDPOB0Wliiw8EOidkgZG2gTkXo=-~XSlgCLgXO522YC6JCRfzWg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (30, N'T-shirt', N'Clothing', 30, 9.2300, N'XL', N'Red', N'Kbn3480KtSkH7vSVXPQ1alc0raQyRWsGbWUyHd3y2to=-~12wt69hfOVZp70h5yH/F0Q==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (31, N'T-shirt', N'Clothing', 10, 14.7900, N'XL', N'Silver', N'uJfBSaXIuCjCWhVWdNMh5DzEDWTOVif/I6H+lgKDZ+s=-~5XwSFjBnM6xkEEyNDdRSnA==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (32, N'Bib (dice)', N'Baby', 50, 2.6100, NULL, N'White', N'jsEGZUPzXD2h9CO9f5Lv29GFqJGxB/NH7cwl60/V0mI=-~ECtE1qo+87VvaUPYMLgz/w==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (33, N'Bib (Vegas sign)', N'Baby', 50, 2.7900, NULL, N'White', N'jL6X6sDqFfeB7iP48bFVPtwzH1q5rjO12261Q4n5PjQ=-~QwJewyiKFloL4CO8JJYuLQ==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (34, N'Pacifier', N'Baby', 50, 1.0300, NULL, N'Red', N'nmikUoDCRvo7/hXJeagn/XYj806eqcquUXvIuOAYpNs=-~OaCipDxwbbX3Wk9LrBEszw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (35, N'Pacifier', N'Baby', 50, 1.0300, NULL, N'Black', N'rAL8/YiM7xy4GKapyB9Brn0JSWeIT/ljt+P1Dj97W/c=-~AHtVtBHFnBODgkepuhX7Xg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (36, N'Mug (Vegas sign)', N'Baby', 100, 9.2300, NULL, NULL, N'92F4QjyVOkwaF4ZTXknQg285Grn4CTEp6lIAZj7gKKQ=-~dtiaZELCkqagYqEnMdYf8Q==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (37, N'Onesie (dice)', N'Baby', 94, 6.0300, NULL, NULL, N'hdRRNETHXBlAq9PcwrCGre+wkuCbF/fj7geDMH2LpzQ=-~qGUrKj7h1bNyqI/X1kDpxQ==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (38, N'Onesie (Vegas sign)', N'Baby', 80, 6.0300, NULL, NULL, N'knkxOV+PpF9VmT1bOztgJq5D1pR+qwQgok2nWXce9fI=-~FfR/OwALJIfBKplov6guqw==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (39, N'T-shirt (dice)', N'Baby', 40, 3.4200, NULL, NULL, N'1qeWZgLxWeUrEScIfuAw400oTG0CzPWewYvsB+PO5e8=-~EKokBf2wnJsFB/l/sRqU4g==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (40, N'T-shirt (Vegas sign)', N'Baby', 30, 3.4200, NULL, NULL, N'Pcud3we4KIqu2VrbiJZHeTeN2QbjGImtjQwHj1X1emc=-~5fiypT8sRGT+5PRpaCaPyg==')

INSERT [dbo].[tblProduct] ([ProductID], [ProductDescription], [Category], [QuantityInStock], [Cost], [Size], [Color], [mSysRowId]) VALUES (41, N'Plate, cup, & utensil set', N'Baby', 18, 9.2300, NULL, NULL, N'N/pPXi7xyXEQXbkQ7MDKFMIuuxMwjsOJYKOTuqQjM+4=-~z6o8zXwqe5BN2apjNLFH3g==')

SET IDENTITY_INSERT [dbo].[tblProduct] OFF

SET IDENTITY_INSERT [dbo].[tblPurchase] ON

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (1, CAST(N'2015-02-03 00:00:00.000' AS DateTime), 1, N'p/AvYFrA9uY+vmYAgPNG2qPozL0LLSDYndnaKNVUdf8=-~kJvjZTuTmmhW7yjePjfdzg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (2, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 2, N'g5vjswSkv7FIdFbIvIe6Dfn+9JPIzuz3pSNlHPJVi40=-~3OjeLkamJkLFk14ia8jmlA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (3, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 3, N'nWEA5Z9HfD/li6aH7ApzC1Vc/+NQy/LfxCqj866e374=-~URP7iA2YbIvcWhjE6I4aXA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (4, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 4, N'ofgHz8bJoqc8fPTPcbVixWJi7BOayRgcT5Ch5MVnMqA=-~hIRsprnq97dc35Ww781s7A==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (5, CAST(N'2015-02-10 00:00:00.000' AS DateTime), 5, N'ykhKJiXxzumA/95kqrHcfLwbnWjlQLuKMsvUedB7TJA=-~FXqX25fjfUDzjfX+xYc40Q==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (6, CAST(N'2015-02-11 00:00:00.000' AS DateTime), 6, N'PNZNoD0YfxaK4Ws0x7Kcm7twdKKgAJVwqRW3L1MIW4E=-~FnsKj8BezaXYKc+GRmxFIQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (7, CAST(N'2015-02-11 00:00:00.000' AS DateTime), 6, N'dGXPJKJSJKdGStKMMGEBGHtb+ka8yRcC+ibs3uh4IT0=-~AsKYTJdeKecvR1HihB/8Vg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (8, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 7, N'xLlR4QzRHvjObgUrJ9IB746rdvRx7M7Q1sxVzxb7z90=-~yU8wfoOtJrIoGY3WXaD6Gg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (9, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 8, N'p0m2dQs5NXSSs8Ecrf2x5DDzjIXEj5eTOspX6HhqCgs=-~26bIu8+Gd+4J7hRnZxU+Qw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (10, CAST(N'2015-02-16 00:00:00.000' AS DateTime), 9, N'KPL2VtSfZ9+EggocYDNy7FlHFq9/AuP8fg9Sn+4mQ3c=-~XSpMxQI4lB/zgNcy05sS6A==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (11, CAST(N'2015-02-17 00:00:00.000' AS DateTime), 4, N'oVsz5YvIy1QNSGjCb1Tos/8pg73l4uVgSVpcRAPrlg4=-~+QywAr3iRiyfh/CRL9k73Q==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (12, CAST(N'2015-02-18 00:00:00.000' AS DateTime), 10, N'khrr1c1ejyv8tqM4Qb8aJzNgXg1R6US9T5yKOCTIbhI=-~kA5J3Ddv3Lhll2qJV2LBTg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (13, CAST(N'2015-02-19 00:00:00.000' AS DateTime), 11, N'cjrrlGUiWEV8yQTKbrQxrxrHbS1Z5Y1nF77HefHRjko=-~zyNuMgQ67uCHGn8IUUSjXw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (14, CAST(N'2015-02-19 00:00:00.000' AS DateTime), 12, N'xvKgJaJYGjv9QHTgwJXuOkoJcZJEXDL4MBDRw78azlU=-~z0+4FcxdOQRE5INRLqmFFw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (15, CAST(N'2015-02-21 00:00:00.000' AS DateTime), 13, N'NlQ7WtQrzxqdiggQhQch5lCEFK1JSqtWwuE1EJhMqf4=-~tMUWArTqd7cuDtA4ayBHOA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (16, CAST(N'2015-02-23 00:00:00.000' AS DateTime), 14, N'okVLJnk6B3LiNsE8b1FA1dtmHo4V98CIs68YpzHoemU=-~HX3qPu7hLNYpDLoi1VRG3A==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (17, CAST(N'2015-02-24 00:00:00.000' AS DateTime), 15, N't7Rq45Ld9/YHkz5eBG+s4xIMP7Uqs6Um+1Z3rnnsYHc=-~uw2LKwGvFyFh6UvevIgH6g==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (18, CAST(N'2015-02-25 00:00:00.000' AS DateTime), 9, N'No5fbsNYcEg/TQTmXoAv7lVzvIWq2sVYLwxRqkrpqTs=-~Ug0/9N/N4UDMVsoJ7b/aDA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (20, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 17, N'17WIz55gpEmw11uIj7V18YhD2iVc6oYwlHnytq6kpT0=-~RvGuvD3ib4hd/oDxuNm3WQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (29, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 2, N'CK7U+Hcyy0fKzYjVFwFOiAxznC9AL6aoUdt6V+6By0E=-~ePlpDFfefCiovDb+0wqhwA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (33, CAST(N'2015-02-04 00:00:00.000' AS DateTime), 4, N'1xPgAGKoxkP+PKm+Nq0MrfRsvvpgPtaO8Y80Ns9NB8M=-~Uw3peOWY5OQ0/fQMefFXVQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (41, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 3, N'OKC4BP+Y0KiyCADuL8EIZQICfHjfYq6coRLkrqyeYiU=-~Wm77NtTbOufeYtguBjvNMQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (42, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 18, N'G6ULfdgOBvTgd5O9E2ygs2WSgKJL2PLyAJj/G8QXLOI=-~EgISHXToHoQJ2GTImt3chw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (43, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 23, N'IV6Nuif0fNyk2M0+GsEYRVZrTRhDIFVcH4Ti8Piimbw=-~1VxnkMp3GBN+CShvdDfDNw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (45, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 24, N'jfJ4OTaeOEo5mW969Oyi9HYLg5/0t7/dsyl/280yGRU=-~fy027R+msD0YTViJGljM9Q==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (49, CAST(N'2015-02-26 00:00:00.000' AS DateTime), 15, N'SlL0Ytbk/srrDY3fxVIQkBmKdhltsg+XgQdUJY/h7Z0=-~XpY6pxzrQ3j1czXK2rUjIw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (54, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 18, N'VvzOG8/L5NBrk53vSG29pqJBzP2G0rUfMYfO9LecETQ=-~DSj9hOY84Gf2NIo/g7LuRw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (55, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 4, N'QU3HdnltOP/D16cZ6eM0nS5QFL1CGOTWJliLR4Casgk=-~1N+Hokn81vXsKe2JbqFsYA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (57, CAST(N'2015-02-08 00:00:00.000' AS DateTime), 14, N'dtHLffAof8BAsFhUuAJ/5DKV1r1tVAPjrMyx5MG1FC8=-~LTOBDzwl/gd4W+fsRpuwgg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (60, CAST(N'2015-02-13 00:00:00.000' AS DateTime), 16, N'h7ubCoEDCmqpx866EFgjr/vgADXLtMZpAUfrpTJdScQ=-~yBGoDhhZNZw4bKIIcJJsyA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (65, CAST(N'2015-02-23 00:00:00.000' AS DateTime), 21, N'/eGiX5w7EqZr2NWl6ec5F/sRUtTx00iygCsnPdJ7WjY=-~vhn/WudhOmT1H3N8VT67Eg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (66, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 2, N'reyTrsnqHjC91MWHizRTkQFVcEyRLow2VA+BWRS13iw=-~MjeyVh48BoD2Q1/Hf9CvTw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (68, CAST(N'2015-02-21 00:00:00.000' AS DateTime), 10, N'LuLmpulesy/x82zlSAIna9IN+fAkxSsexBh7X/TRj0E=-~JUoDZ38RFASHLvJBLFaFVg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (74, CAST(N'2015-02-26 00:00:00.000' AS DateTime), 14, N'nJZKVG7PjPcsK0baRKGBZhJr/2fzCBqg0d0F7eV3qXY=-~oGXnc9pe9uZiuQTT8+baWA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (76, CAST(N'2015-02-12 00:00:00.000' AS DateTime), 24, N'OmTMu5q4NnBm1xZY1hLC5cZ8axXjNTRAdNeWvPoHgsM=-~QP0bkPYbNrv2bMEoyV2Mog==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (78, CAST(N'2015-02-02 00:00:00.000' AS DateTime), 21, N'3mWa0j7BSR1ACkzdE7RDtvwvfVoDzRXAt0BZxkiWj0s=-~dDcbmHIvYpp1YbLSpI++zQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (80, CAST(N'2015-02-08 00:00:00.000' AS DateTime), 9, N'A5IUesLnj+XLu4WH+RuIMrhgoYYvaVXO1wPkC9x0r1I=-~P/FQ/fgRRsJWe1n9vKfI9w==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (81, CAST(N'2015-02-10 00:00:00.000' AS DateTime), 12, N'4kqG+73vC7eYXjpuMJ/9SlODI39fdsHirICOuBDmO9k=-~akrVJ1hv442zHCaGEzelbg==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (88, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 9, N'hZSY/PJPBvF6ySnYcNa5M6aDQDxjTPuAoyFJIb0xRw0=-~Jxk1OVw/eZ3DEw1iopdDZQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (89, CAST(N'2015-02-01 00:00:00.000' AS DateTime), 18, N'bS92fqWZRVztH7nuzp53hL+mS3CbBMB1uRzAJBwKpuI=-~fQGopUQrVpmrvjoDhmTPNA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (91, CAST(N'2015-02-07 00:00:00.000' AS DateTime), 25, N'hLtJFNBVB5/IpY+N3nNlJkPQtWFJwKjUxfkepx/MO+g=-~rU5p1uw7SlmhDOzHgNKM9w==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (92, CAST(N'2015-02-18 00:00:00.000' AS DateTime), 6, N'Vka9vspQYu5865AvlqRoCGNVhO5TVhw1/F6jiO8kRxI=-~wk+DHwo0diL8cV2kazGWqA==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (101, CAST(N'2015-02-22 00:00:00.000' AS DateTime), 8, N'UMqGCBpKowq06EhWVTEzYUvqklHtSnQ3J7ED+CiFuGs=-~ykoF8Tn5Da06CtERBcKCkQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (104, CAST(N'2015-02-20 00:00:00.000' AS DateTime), 8, N'KXQ321FZdxf9y/0c658rhhUQmCFhECrniqjc8NpXGjY=-~sghH924oL3NLszDVqDJnJQ==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (106, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 17, N'7HEVmx9+lLj4QeNs+LO6g6+yo1O0ifm8ADqMclCNCds=-~xi/bKovxe7KKf5/LeSoj+Q==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (110, CAST(N'2015-02-14 00:00:00.000' AS DateTime), 23, N'rlNOb9U6pqqyxB1xprdXzgsEDKk8U5fzskPkrXs7wtI=-~c9HLQJzxfMeEeBorR4yZ8A==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (119, CAST(N'2015-02-15 00:00:00.000' AS DateTime), 4, N'1cRq0ZGlVyeDu4Mco32DOA6Wi88xCALWBtYHZqxgRXA=-~XhCCOcSCb2AqwRft47I7lw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (120, CAST(N'2015-02-09 00:00:00.000' AS DateTime), 17, N'rVwm7I4vCQovsqtVdUSC5sJJ2FUIpXdkrFY/hgkKGwY=-~z11oIqia22j/QHWunIks4Q==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (123, CAST(N'2015-02-24 00:00:00.000' AS DateTime), 23, N'UHVzpnE8pFMEBqk9y5d9OpjnrJJtGuKcP+LIRd5HpCU=-~kHwgYsiiCtB/dYu0ZHMhDw==')

INSERT [dbo].[tblPurchase] ([PurchaseID], [PurchaseDate], [CustomerID], [mSysRowId]) VALUES (124, CAST(N'2015-02-05 00:00:00.000' AS DateTime), 19, N'KmlXefP8O2EioEvPS8qz9BYCARb3wbesH7gKkSx7sVI=-~jYsZEjH94uL/U2p8HCHUIQ==')

SET IDENTITY_INSERT [dbo].[tblPurchase] OFF

SET IDENTITY_INSERT [dbo].[tblPurchaseLine] ON