text: -- ----------------------------------------------------------------------------
  -- Table AdventureWorksLT.Address
  -- ----------------------------------------------------------------------------
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (9, N'8713 Yosemite Ct.', NULL, N'Bothell', N'Washington', N'United States', N'98011', N'268af621-76d7-4c78-9441-144fd139821a', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (11, N'1318 Lasalle Street', NULL, N'Bothell', N'Washington', N'United States', N'98011', N'981b3303-aca2-49c7-9a96-fb670785b269', CAST(N'2007-04-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (25, N'9178 Jumping St.', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'c8df3bd9-48f0-4654-a8dd-14a67a84d3c6', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (28, N'9228 Via Del Sol', NULL, N'Phoenix', N'Arizona', N'United States', N'85004', N'12ae5ee1-fc3e-468b-9b92-3b970b169774', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (32, N'26910 Indela Road', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H5', N'84a95f62-3ae8-4e7e-bbd5-5a6f00cd982d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (185, N'2681 Eagle Peak', NULL, N'Bellevue', N'Washington', N'United States', N'98004', N'7bccf442-2268-46cc-8472-14c44c14e98c', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (297, N'7943 Walnut Ave', NULL, N'Renton', N'Washington', N'United States', N'98055', N'52410da4-2778-4b1d-a599-95746625ce6d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (445, N'6388 Lake City Way', NULL, N'Burnaby', N'British Columbia', N'Canada', N'V5A 3A6', N'53572f25-9133-4a8b-a065-102ff35416ee', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (446, N'52560 Free Street', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'801a1dfc-5125-486b-aa84-ccbd2ec57ca4', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (447, N'22580 Free Street', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'88cee379-dbb8-433b-b84e-a35e09435500', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (448, N'2575 Bloor Street East', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V6', N'2df6d0ad-0926-4f34-a450-9b1083150cbf', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (449, N'Station E', NULL, N'Chalk Riber', N'Ontario', N'Canada', N'K0J 1J0', N'8b5a7729-cb75-4303-a607-7f9793b4d94f', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (450, N'575 Rue St Amable', NULL, N'Quebec', N'Quebec', N'Canada', N'G1R', N'5f3c345a-6475-41d5-b17b-db8d27733bb1', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (451, N'2512-4th Ave Sw', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'49644f1e-6f90-46d9-8dbb-9db15f0ef7ec', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (452, N'55 Lakeshore Blvd East', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V6', N'a358652f-0e00-49e6-b6b0-de1099c43506', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (453, N'6333 Cote Vertu', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'355681f2-4d9d-4522-bfa0-105be64394d8', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (454, N'3255 Front Street West', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V6', N'ef4dc57d-8b8b-4074-b5f0-acbef65dbec1', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (455, N'2550 Signet Drive', NULL, N'Weston', N'Ontario', N'Canada', N'M9V 4W3', N'43d582cf-e95f-4861-ba60-2dc7121410a6', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (456, N'6777 Kingsway', NULL, N'Burnaby', N'British Columbia', N'Canada', N'V5H 3Z7', N'2f3b383e-08a5-407d-ab1b-a1390e87a888', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (457, N'5250-505 Burning St', NULL, N'Vancouver', N'British Columbia', N'Canada', N'V7L 4J4', N'93f02c61-783d-4f04-8a57-416f25817aba', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (458, N'600 Slater Street', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1S2', N'49f4ee42-e20b-4e66-b43c-a28e9fc63ca0', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (459, N'25575 The Queensway', NULL, N'Etobicoke', N'Ontario', N'Canada', N'M9W 3P3', N'616235ea-dc36-4c39-bf91-ffe12bb676e0', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (460, N'2521 McPherson Street', NULL, N'Markham', N'Ontario', N'Canada', N'L3S 3K2', N'7d6f03ac-5d55-422e-850e-b8743fac81b2', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (461, N'2560 Bay Street', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'726819a8-1b02-4efd-aeb9-3fd801d9f153', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (462, N'630 University Avenue', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'27d5bdad-647d-4a56-859a-bc6a82af7dcd', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (463, N'992 St Clair Ave East', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'd6ed51fa-6dd1-460c-99e0-64ba90f035ae', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (464, N'99, Rue Saint-pierre', NULL, N'Pnot-Rouge', N'Quebec', N'Canada', N'J1E 2T7', N'c4a1ee36-8149-46b7-a313-a63010987a8e', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (465, N'25245 Rue Sherbrooke Ouest', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H5', N'10ee8c14-2792-4f02-b83d-92511d20470f', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (466, N'655-4th Ave S.W.', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'09c5f0ba-7128-4455-832d-0df587248a5a', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (467, N'25900-700-9th Ave S.W.', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'13560188-ce4a-470d-9913-49903047d459', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (468, N'Po Box 83270', NULL, N'Vancouver', N'British Columbia', N'Canada', N'V7L 4J4', N'c00a5dff-b134-4900-9561-e67eeb425f9f', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (469, N'400-25155 West Pender St', NULL, N'Vancouver', N'British Columbia', N'Canada', N'V7L 4J4', N'b81768f9-3b05-43dc-8dde-85ffca00d4de', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (470, N'2511 Baker Road', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'6e934d97-69b9-4fcf-9e4e-56bf94e52986', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (471, N'770 Notre Datme Quest Bureau 800', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'5eda011d-31d1-4dfb-a78c-397b6335f85b', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (472, N'250551 Shellbridge Way', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'1a6a1a7b-e208-473d-a8f4-14a89d06fad2', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (473, N'595 Burning Street', NULL, N'Vancouver', N'British Columbia', N'Canada', N'V7L 4J4', N'0ec83a85-137e-4cf3-b13d-3926277698b2', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (474, N'252345 8810th Avenue', NULL, N'Surrey', N'British Columbia', N'Canada', N'V3T 4W3', N'447ca097-077d-4980-a431-8fafad156ced', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (475, N'2512-410th Avenue S.W.', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'ec6c99b9-61e2-4400-8180-208f5a6c7eff', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (476, N'258 King Street East', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'90c770a5-a474-43d1-9a67-0f5de336f9dc', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (477, N'6th Floor Ferguson Block', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'39f3b067-2263-4591-abf9-d5210da4f783', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (478, N'2545 King Street West', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V7', N'2817a0b7-8985-4527-bb7b-b75f55f4d8de', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (479, N'2550 Middlefield Road', NULL, N'Scarborough', N'Ontario', N'Canada', N'M1V 4M2', N'e60801bf-cfb3-4606-a738-8aa0eb587afb', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (480, N'25 First Canadian Place', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'07a009b2-1421-4597-ab85-22bce3c82b2c', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (481, N'65 Gamelin Street', NULL, N'Hull', N'Quebec', N'Canada', N'8Y', N'f35e73ba-678f-4a0f-80bc-6385a7a6cb24', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (482, N'2500 University Avenue', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'197a1735-e89e-4f15-a5f7-feb98b369094', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (483, N'955 Green Valley Crescent', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1S1', N'c6b743c3-f830-43e4-ba58-dd36fc451d14', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (484, N'2510 Crew Court', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H8', N'1f41edc1-7144-4d6b-9cbd-4318c2358fa1', CAST(N'2008-06-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (485, N'9900-6400 Boul, Taschereau', NULL, N'Brossard', N'Quebec', N'Canada', N'J4Z 1R4', N'7c46d2fc-e31e-402f-a093-4cf18f7f6e54', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (486, N'600 Boul. Rene-levesque Ouest', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'112049e4-64d5-4305-9545-933e89b74f6e', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (487, N'9259 - 1110th Avenue Sw', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'275ac976-0d23-4d97-9f58-bb186d1cc089', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (488, N'45259 Canada Way', NULL, N'Burnaby', N'British Columbia', N'Canada', N'V5G 4S4', N'6d2d6846-3f17-474e-8d31-ad3a59c0ceb0', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (489, N'9960 King Street E.', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'eb632e56-4299-4714-9e91-224319bdcb62', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (490, N'9979 Bayview Drive', NULL, N'Barrie', N'Ontario', N'Canada', N'L4N', N'85d72a98-f631-457c-8fff-04faec508f5d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (491, N'20225 Lansing Ave', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'a9b5a261-2463-4489-9951-eacfa29a8231', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (492, N'99954 Boul. Laurier, Local 060, Place', NULL, N'Sainte-Foy', N'Quebec', N'Canada', N'G1W', N'541cde7c-3f3a-435f-a7b5-f30055dfbc68', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (493, N'6th Floor 5250 Main Street', NULL, N'Winnipeg', N'Manitoba', N'Canada', N'R3', N'ac0e73d8-ff0a-42bd-8502-e19ebac7343f', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (494, N'Box 99354 300 Union Street', NULL, N'Saint John', N'Brunswick', N'Canada', N'E2P 1E3', N'21ff77a8-39dc-44d8-917c-fdd645dbf9eb', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (495, N'Suite 800 2530 Slater Street', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1T7', N'c6633ad5-006d-4967-b97e-7919dd48a700', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (496, N'Suite 500 995 W. 11th Avenue', NULL, N'Mississauga', N'Ontario', N'Canada', N'L5A 1H6', N'496c1ad3-2925-4322-8811-890ab6107f67', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (497, N'#9900 2700 Production Way', NULL, N'Burnaby', N'British Columbia', N'Canada', N'V5A 4X1', N'aa651b28-0a51-4084-8444-a70cc71bce65', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (498, N'25537 Hillside Avenue', NULL, N'Victoria', N'British Columbia', N'Canada', N'V8V', N'385c24e0-e20c-40c9-bac9-95d70d5b6900', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (499, N'Suite 2502 410 Albert Street', NULL, N'Waterloo', N'Ontario', N'Canada', N'N2V', N'44099b0e-03f3-447c-83bf-be4baa010a83', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (500, N'5700 Explorer Drive', NULL, N'Mississauga', N'Ontario', N'Canada', N'L4W 5J3', N'f6fed7fa-39d9-4a60-a1f5-1622489e55fd', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (501, N'965 De La Gauchetiere West', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H8', N'acb9c033-18c6-4f02-975e-9c5226b96b72', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (502, N'No. 25400 10665 Jasper Avenue', NULL, N'Edmonton', N'Alberta', N'Canada', N'T5', N'51180ca2-6614-46a5-b89c-ef7b0421c847', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (503, N'P.O. Box 44000', NULL, N'Winnipeg', N'Manitoba', N'Canada', N'R3', N'c4f3e274-13e1-4a99-8fd3-2c7d3d1ee5a1', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (504, N'Suite 99320 255 - 510th Avenue S.W.', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'cff7437f-6830-4797-875b-d9a54ea38975', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (505, N'6400, 888 - 3rd Avenue', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'a6eff2b6-3b11-47ef-ab7e-701e5041c71c', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (506, N'255117 - 101 Avenue', NULL, N'Surrey', N'British Columbia', N'Canada', N'V3T 4W3', N'22895b47-6086-4550-b437-a75dbedfe1d9', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (507, N'975 Princess Street', NULL, N'Kingston', N'Ontario', N'Canada', N'7L', N'd7849f5f-c042-4fce-8f6b-ba5cd8708e10', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (508, N'2900 - 25055 Dunning Street', NULL, N'Vancouver', N'British Columbia', N'Canada', N'V7L 4J4', N'4ee0334f-027c-4036-880f-6e9104e21533', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (509, N'Suite 25800 3401 - 10810th Avenue', NULL, N'Surrey', N'British Columbia', N'Canada', N'V3T 4W3', N'28c52717-7117-41b6-a5c7-fda60d566163', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (510, N'750 Philip Street', NULL, N'Waterloo', N'Ontario', N'Canada', N'N2V', N'f2b96299-187a-4e52-96de-fe9d1c8ab33f', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (511, N'Bureau 9900 825, Avenue Querbes', NULL, N'Outremont', N'Quebec', N'Canada', N'H1Y 2G5', N'ef10cf20-a540-4d5c-befd-1b48b7d48402', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (512, N'700 Bureau Road', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'963f514b-7752-46e8-9742-1fd40a68ea33', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (513, N'253711 Mayfield Place, Unit 150', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'c418c2f4-6b32-4404-aab1-e0bec3958c11', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (514, N'63 West Beaver Creek', NULL, N'Richmond Hill', N'Ontario', N'Canada', N'L4E 3M5', N'ad60dba9-3b01-47e9-bb5e-df94d0579f14', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (515, N'9900 Ronson Drive', NULL, N'Etobicoke', N'Ontario', N'Canada', N'M9W 3P3', N'42242712-6dd2-423f-9b89-c953454e3b09', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (516, N'251 Indell Lane', NULL, N'Brampton', N'Ontario', N'Canada', N'L6W 2T7', N'a1f36994-b5b3-4646-87ea-692a513395ea', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (517, N'2573 Dufferin Street', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'97605c5c-8309-44f2-9a98-c5a5709497ff', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (518, N'995 Crescent', NULL, N'Richmond Hill', N'Ontario', N'Canada', N'L4E 3M5', N'0b49022d-8b49-4cf6-b0a3-46231cd48441', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (519, N'2500-622 5th Ave Sw', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'13754965-6a09-4343-968c-8699c27fdfaa', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (520, N'6700 Boul Taschereau', NULL, N'Brossard', N'Quebec', N'Canada', N'J4Z 1C5', N'b730eaff-5828-4c8c-86c1-9137f50fca48', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (521, N'55 Standish Court', NULL, N'Mississauga', N'Ontario', N'Canada', N'L5B 3V4', N'97c329e2-fa67-4478-aa7b-78a8deecf7ca', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (522, N'43251 Viking Way, Unit 130', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'842bcbe5-9da5-42d5-a4bb-4197db5b69c7', CAST(N'2007-02-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (523, N'46990 Viking Way', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'85c88cd6-682c-4358-9f8c-5a24f4ccfd98', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (524, N'9693 Louis H Lafontaine', NULL, N'Ville De''anjou', N'Quebec', N'Canada', N'J1G 2R3', N'acc21bd9-fb1b-4764-941b-2fb98aa4eb27', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (525, N'69251 Creditview Road', NULL, N'Mississauga', N'Ontario', N'Canada', N'L5B 3V4', N'2ca11975-213a-46fb-a0be-2529003074cc', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (526, N'251420a 170th Street', NULL, N'Edmonton', N'Alberta', N'Canada', N'T5', N'476d80ae-69a0-480d-9df3-8fd0c1095a21', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (527, N'252851 Rowan Place', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'11eaee50-8a14-4b81-951e-86701b6f60c0', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (528, N'5990 Avebury Road', NULL, N'Mississauga', N'Ontario', N'Canada', N'L5B 3V4', N'd9928ccc-fc35-435a-8a0f-6887813e0e06', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (529, N'254480 River Rd', NULL, N'Richmond', N'British Columbia', N'Canada', N'V6B 3P7', N'034076fd-cd0e-4ead-864e-8ce7f47d6612', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (530, N'Suite #9902', NULL, N'North York', N'Ontario', N'Canada', N'M4C 4K6', N'fe36e0c8-ad8a-4d2c-bc53-5d69be5a9ce7', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (531, N'5th Floor, 79 Place D''armes', NULL, N'Kingston', N'Ontario', N'Canada', N'7L', N'f6fb5f79-c5fa-4a7c-8d75-6e9243360308', CAST(N'2006-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (532, N'#500-75 O''Connor Street', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1S2', N'1b58b9bc-a691-4927-bf17-569e4be822f3', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (533, N'4400 March Road', NULL, N'Kanata', N'Ontario', N'Canada', N'K2L 1H5', N'43484cd9-ad5b-41f4-a9cc-ddfbac4b5aa5', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (534, N'Depot 80', NULL, N'Sillery', N'Quebec', N'Canada', N'G1T', N'3178440d-5c3a-48f2-af6b-0a607774e265', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (535, N'250 Kingsbridge Garden Circle', NULL, N'Mississauga', N'Ontario', N'Canada', N'L5B 3V4', N'9771494e-9053-40f2-84a5-e0d108deefed', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (536, N'No. 2000-25080 Beaver Hall Hill', NULL, N'Quebec', N'Quebec', N'Canada', N'G1R', N'0c38c439-4562-4e37-8f23-aff2c9005c38', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (537, N'No. 25800-130 King Street West', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'c2bcdaec-366c-489c-bf43-8cc2881179f3', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (538, N'25 Danger Street West', N'Floor 7', N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'10b2404c-f0af-409c-af5d-0218beb03d0d', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (539, N'6th Floor, 25st Canadian Place', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V5', N'd51784c0-cc77-48c2-8fa6-75405f3e35b9', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (540, N'254 Colonnade Road', NULL, N'Nepean', N'Ontario', N'Canada', N'K2J 2W5', N'1c97f465-f2af-4d34-be8c-7afdad119425', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (541, N'25981 College Street', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H5', N'af56d631-eb1c-4716-a89b-88bc4ae04b93', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (542, N'5 place Ville-Marie', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H7', N'b242b256-254b-4624-b3af-bf0058bb0b7b', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (543, N'6030 Conroy Road', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1S3', N'aa8f3ecb-c454-448b-b774-ff9cdf01e629', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (544, N'30025 Wayburne Drive, Suite 275', NULL, N'Burnaby', N'British Columbia', N'Canada', N'V5G 4W1', N'4c65a591-c6b0-43d8-8faf-f4b1cb9953e1', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (545, N'999 West Georgia St.', NULL, N'Vancouver', N'Ontario', N'Canada', N'V5T 1Y9', N'9d35f3c2-966e-4b3b-8d29-0e6ab8def01b', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (546, N'250333 Southport Road, S.W.', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'11d29e3f-d9b2-4e24-ac01-eeba72da4ddf', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (547, N'7000 Victoria Park Avenue', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V4', N'28125ec3-fdc2-45d8-93b3-cd7db2113424', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (548, N'63 Free St.', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V4', N'5649c5d8-1798-4622-95bf-dc7e581284a0', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (549, N'609 Evans Avenue', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V4', N'dcf9c9b5-a7b6-4383-9480-1f84130b5f8b', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (550, N'2520 Flanders Road', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V4', N'a1d478e6-76da-445f-a924-0b5dee3c7cbb', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (551, N'32605 West 252 Mile Road, Suite 250', NULL, N'Aurora', N'Ontario', N'Canada', N'L4G 7N6', N'e7567a62-3acf-4f0b-b202-e28b92de689a', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (552, N'25730, boul. St-R?is', NULL, N'Dorval', N'Quebec', N'Canada', N'H9P 1H1', N'6832a3bd-56ec-42fe-8b4c-6bfd09f89eb4', CAST(N'2008-06-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (553, N'253131 Lake Frasier Drive, Office No. 2', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'ef7b5bd3-3a04-4a09-a0d2-02b98e3333dc', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (554, N'9984 Wellington Street', NULL, N'Ottawa', N'Ontario', N'Canada', N'K4B 1S2', N'6e0797c9-fd43-418f-a5fe-8683292b95fe', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (555, N'9950 Ferrand Drive, 9th Floor', NULL, N'Toronto', N'Ontario', N'Canada', N'M4B 1V4', N'32890831-931e-44ad-801b-41b1ad862eca', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (556, N'990th Floor 700 De La GauchetiSre Ou', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H3', N'87846d7c-ab01-41c6-a4cc-fad06d74d11b', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (557, N'660 Saint-Jacques, Bureau 400', NULL, N'Montreal', N'Quebec', N'Canada', N'H1Y 2H8', N'dce88c1f-8bfe-4306-ba02-50446466c5e5', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (558, N'67255 - 8th Street N.E., Suite 350', NULL, N'Calgary', N'Alberta', N'Canada', N'T2P 2G8', N'da596abb-b3af-48ec-a082-9e94cd870a5f', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (559, N'12345 Sterling Avenue', NULL, N'Irving', N'Texas', N'United States', N'75061', N'0d39391c-a319-486b-ac9e-5863795d6675', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (560, N'800 Interchange Blvd.', N'Suite 2501', N'Austin', N'Texas', N'United States', N'78701', N'5790365c-da3c-43bc-93d3-99104c038b71', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (561, N'90025 Sterling St', NULL, N'Irving', N'Texas', N'United States', N'75061', N'c1ca3287-f642-44da-bba1-8ab47e1907dd', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (562, N'2505 Gateway Drive', NULL, N'North Sioux City', N'South Dakota', N'United States', N'57049', N'57a5e455-526c-402a-bc5d-ee613bf58372', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (563, N'74400 France Avenue South', NULL, N'Edina', N'Minnesota', N'United States', N'55436', N'a1841d05-cabd-4453-96e4-9b1e95ca2bc2', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (564, N'509 Nafta Boulevard', NULL, N'Laredo', N'Texas', N'United States', N'78040', N'f9a8a87a-152f-4204-b5d2-dbcb8da1c13b', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (565, N'25149 Howard Dr', NULL, N'West Chicago', N'Illinois', N'United States', N'60185', N'f4915606-499d-477d-8309-e8f92e9d8fe3', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (566, N'63 W Monroe', NULL, N'Chicago', N'Illinois', N'United States', N'60610', N'61113716-53e4-4faa-a5a2-247b03f0f9c6', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (567, N'Corporate Office', NULL, N'Garland', N'Texas', N'United States', N'75040', N'10cc0938-b0af-42e0-9176-564321c68787', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (568, N'25269 N. Wood Dale Rd', NULL, N'Wood Dale', N'Illinois', N'United States', N'60191', N'e863927d-49fb-47ab-9ca6-a5f36d082b66', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (569, N'Sapp Road West', NULL, N'Round Rock', N'Texas', N'United States', N'78664', N'b7ea2783-866e-4ad9-945c-914b674ad2cd', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (570, N'52500 Liberty Way', NULL, N'Fort Worth', N'Texas', N'United States', N'76102', N'f5a1147f-761f-4577-bb48-bbef73b4a27f', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (571, N'25550 Executive Dr', NULL, N'Elgin', N'Illinois', N'United States', N'60120', N'8caf52b2-d3e2-4a5f-a704-874768007f38', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (572, N'P.O. Box 6256916', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'206e0ff7-e120-4845-acb4-a4443ebf6429', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (573, N'25269 Wood Dale Rd.', NULL, N'Wood Dale', N'Illinois', N'United States', N'60191', N'e4c1153e-6c1a-45df-addb-80fac429fa3f', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (574, N'Po Box 8259024', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'9794b438-2e91-4699-85df-5fcf98210ac1', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (575, N'42500 W 76th St', NULL, N'Chicago', N'Illinois', N'United States', N'60610', N'cd335652-0913-40ea-9ae0-323066fc04f0', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (576, N'4255 East Lies Road', NULL, N'Carol Stream', N'Illinois', N'United States', N'60188', N'c1a9793e-50b5-431c-82dd-8b36acc9ac4e', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (577, N'2500 North Stemmons Freeway', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'c91ed16c-4407-4eed-a241-c8327e5e50c2', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (578, N'220 Mercy Drive', NULL, N'Garland', N'Texas', N'United States', N'75040', N'791e9c8d-6c3a-4cfd-9f0a-c4a99424c268', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (579, N'25 N State St', NULL, N'Chicago', N'Illinois', N'United States', N'60610', N'02d95901-41c1-4479-a04f-9ffb5a2675e3', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (580, N'2509 W. Frankford', NULL, N'Carrollton', N'Texas', N'United States', N'75006', N'a0dbc338-cf0e-4962-9fbf-63220aeca66e', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (581, N'Po Box 8035996', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'cc8321ba-c938-4765-8175-9126d432957f', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (582, N'5700 Legacy Dr', NULL, N'Plano', N'Texas', N'United States', N'75074', N'08ebf5a9-2171-433e-85b8-56fff949d041', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (583, N'625 W Jackson Blvd. Unit 2502', NULL, N'Chicago', N'Illinois', N'United States', N'60610', N'a35c7ac7-5ae8-43d9-92e7-180d78a9a7b8', CAST(N'2007-03-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (584, N'250880 Baur Blvd', NULL, N'Saint Louis', N'Missouri', N'United States', N'63103', N'ed1ee7da-5087-4e7a-b019-7782742bc451', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (585, N'Noah Lane', NULL, N'Chicago', N'Illinois', N'United States', N'60610', N'e9408fbb-1c28-4923-9d85-2dfadb3b4b6b', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (586, N'6030 Robinson Road', NULL, N'Jefferson City', N'Missouri', N'United States', N'65101', N'35b2fb0c-60ea-48f2-814a-f6813242858e', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (587, N'25500 Old Spanish Trail', NULL, N'Houston', N'Texas', N'United States', N'77003', N'9a71e3c4-caea-4c5c-a146-5b85a513d82f', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (588, N'99828 Routh Street, Suite 825', NULL, N'Dallas', N'Texas', N'United States', N'75201', N'180f5a76-930d-4b70-9d70-7aa3e49bb71e', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (589, N'One Dancing, Rr No. 25', N'Box 8033', N'Round Rock', N'Texas', N'United States', N'78664', N'a514f151-6b2d-452c-a983-d68aed9e112e', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (590, N'9995 West Central Entrance', NULL, N'Duluth', N'Minnesota', N'United States', N'55802', N'86553e06-3bf8-4c21-8e40-ae95309c4b3e', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (591, N'48255 I-10 E. @ Eastpoint Blvd.', NULL, N'Baytown', N'Texas', N'United States', N'77520', N'8d604ca1-2f01-46c1-9041-39915144b446', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (592, N'9903 Highway 6 South', NULL, N'Houston', N'Texas', N'United States', N'77003', N'ce585616-c47c-4bd4-8d71-1755b6417770', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (593, N'2345 North Freeway', NULL, N'Houston', N'Texas', N'United States', N'77003', N'74e5959f-4c5f-4bda-abcf-429762e1670d', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (594, N'123 W. Lake Ave.', NULL, N'Peoria', N'Illinois', N'United States', N'61606', N'c9f2b21e-3edb-4315-aa03-8adde7d8a598', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (595, N'660 Lindbergh', NULL, N'Saint Louis', N'Missouri', N'United States', N'63103', N'012d17ba-c426-40c2-a9fd-85093e2ceb8a', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (596, N'72540 Blanco Rd.', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'5ec50e4c-3026-4bd5-9a15-00776ad22eec', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (597, N'99450 Highway 59 North', NULL, N'Humble', N'Texas', N'United States', N'77338', N'3bd8466e-2a52-4661-8460-50736409ee8a', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (598, N'455 256th St.', NULL, N'Moline', N'Illinois', N'United States', N'61265', N'fbedd917-c269-4e36-a791-58b35f34b107', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (599, N'70 N.W. Plaza', NULL, N'Saint Ann', N'Missouri', N'United States', N'63074', N'4735a716-33c4-4366-bcc0-410bceef3e2c', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (600, N'25095 W. Florissant', NULL, N'Ferguson', N'Missouri', N'United States', N'63135', N'1a51283c-12bb-462e-a1b8-a0039c18e6d8', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (601, N'6996 South Lindbergh', NULL, N'Saint Louis', N'Missouri', N'United States', N'63103', N'a8f4d544-a137-4775-b6c9-7c85a12a4ddc', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (602, N'6425 Nw Loop 410', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'6241806c-c9cc-46aa-a91f-b663c7e0c8bb', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (603, N'9500b E. Central Texas Expressway', NULL, N'Killeen', N'Texas', N'United States', N'76541', N'0e6e9e86-a637-4fd5-a945-ac342bfd715b', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (604, N'1200 First Ave.', NULL, N'Joliet', N'Illinois', N'United States', N'60433', N'79972b72-7d84-4a33-ae27-44a5efaef39d', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (605, N'7760 N. Pan Am Expwy', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'6c3da38c-887d-410c-b022-8f2bf2db3339', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (606, N'99433 S. Greenbay Rd.', NULL, N'Racine', N'Wisconsin', N'United States', N'53182', N'48f98b9b-cf62-4a87-95e8-44da6aac6f97', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (607, N'25220 Airline Road', NULL, N'Corpus Christi', N'Texas', N'United States', N'78404', N'6e7fe435-895a-4e65-913b-2ad21cf4ce6d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (608, N'25306 Harvey Rd.', NULL, N'College Station', N'Texas', N'United States', N'77840', N'49d7554e-852f-4d68-81b5-44c7a615f117', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (609, N'3900 S. 997th St.', NULL, N'Milwaukee', N'Wisconsin', N'United States', N'53202', N'7394624a-5ca8-4adc-923c-235d971514b8', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (610, N'44025 W. Empire', NULL, N'Denby', N'South Dakota', N'United States', N'57716', N'8afb400f-1fe5-460d-bc56-4a7bf801b41b', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (611, N'23025 S.W. Military Rd.', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'76ed2669-d8a8-4468-943d-7319a9b18fe3', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (612, N'Ring Plaza', NULL, N'Norridge', N'Illinois', N'United States', N'60706', N'60ab96a4-26f6-439c-9f32-238bd16b293f', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (613, N'Lakeline Mall', NULL, N'Cedar Park', N'Texas', N'United States', N'78613', N'd26f02d6-326a-4088-b9ee-d441dfdfa1df', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (614, N'Town East Center', NULL, N'Mesquite', N'Texas', N'United States', N'75149', N'7ba1af96-5a8e-4259-835c-da67db296a5e', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (615, N'Fountains On The Lake', NULL, N'Stafford', N'Texas', N'United States', N'77477', N'bc2d6156-bcf7-47f7-a409-31122653f701', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (616, N'Southwest Outlet', NULL, N'Hillsboro', N'Texas', N'United States', N'76645', N'47f987f7-44ff-4372-aaf5-4cc7b7f64216', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (617, N'Johnson Creek', NULL, N'Johnson Creek', N'Wisconsin', N'United States', N'53038', N'aca53503-0920-446d-9c54-b83d7949d019', CAST(N'2007-06-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (618, N'Blue Ridge Mall', NULL, N'Kansas City', N'Missouri', N'United States', N'64106', N'8612fbad-3ce1-435b-be0b-5a48ddbd2b62', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (619, N'First Colony Mall', NULL, N'Sugar Land', N'Texas', N'United States', N'77478', N'da205e92-2867-48a9-bf18-4558a31272ae', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (620, N'Horizon Outlet', NULL, N'Woodbury', N'Minnesota', N'United States', N'55125', N'70080b27-59bd-4ba1-84d2-68204b304d70', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (621, N'Tanger Factory', NULL, N'Branch', N'Minnesota', N'United States', N'55056', N'75d18db1-c9ef-4dad-bbd2-697ff73faf6c', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (622, N'Management Mall', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'e82d1276-e19a-4fad-90f5-7e19af94ea64', CAST(N'2006-03-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (623, N'Ohms Road', NULL, N'Houston', N'Texas', N'United States', N'77003', N'd4688e5c-2d2d-4925-b58a-356c117728d8', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (624, N'Factory Merchants', NULL, N'Branson', N'Missouri', N'United States', N'65616', N'dc707744-912b-4e7a-945a-1b959168dc94', CAST(N'2007-02-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (625, N'Cedar Creek Stores', NULL, N'Mosinee', N'Wisconsin', N'United States', N'54455', N'2e6e124e-bb43-4d40-8515-82dda7994bd4', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (626, N'Lone Star Factory', NULL, N'La Marque', N'Texas', N'United States', N'77568', N'5f33b654-e091-4b2f-b5bd-ac5ac6d47ee6', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (627, N'Sports Stores @ Tuscola', NULL, N'Tuscola', N'Illinois', N'United States', N'61953', N'808efdc0-ea1b-437d-88c0-a3b6a8864b7f', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (628, N'City Center', NULL, N'Minneapolis', N'Minnesota', N'United States', N'55402', N'b80975d1-ab6e-42f1-b328-5db1d445e2c9', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (629, N'St. Louis Marketplace', NULL, N'Saint Louis', N'Missouri', N'United States', N'63103', N'163fde0a-2148-44bc-9fc1-a7390650127c', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (630, N'Lincoln Square', NULL, N'Arlington', N'Texas', N'United States', N'76010', N'734de48f-7f95-4386-986e-f8ab86c194a0', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (631, N'Kansas City Factory Outlet', NULL, N'Odessa', N'Missouri', N'United States', N'64076', N'bcd46b97-395d-4eef-a712-245ba629621f', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (632, N'Fiesta Trail Shopping Center', NULL, N'San Antonio', N'Texas', N'United States', N'78204', N'f79532d7-38e9-42ec-8ea4-c9d7e1c13c12', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (633, N'Medford Outlet Center', NULL, N'Medford', N'Minnesota', N'United States', N'55049', N'7cda3069-3b49-4205-b853-40744d7d875f', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (634, N'Ward Parkway Center', NULL, N'Kansas City', N'Missouri', N'United States', N'64106', N'3f2aa425-7d02-461a-a9c4-222ae41e3fe5', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (635, N'93-2501, Blackfriars Road,', NULL, N'London', N'England', N'United Kingdom', N'SE1 8HL', N'00e75f99-488c-462d-a0bc-ac3c08a9db77', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (636, N'Science Park South, Birchwood', N'Stanford House', N'Warrington', N'England', N'United Kingdom', N'WA3 7BH', N'c0fc2d5b-88e7-4b60-8447-bb3522bd79e5', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (637, N'Phoenix Way, Cirencester', NULL, N'Gloucestershire', N'England', N'United Kingdom', N'GL7 1RY', N'10a3d496-881e-4042-bbd0-5802cf73a872', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (638, N'255 Irving Street', NULL, N'London', N'England', N'United Kingdom', N'C2H 7AU', N'd8a77424-94ae-43ab-a011-1a9ebb3852e7', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (639, N'Garamonde Drive, Wymbush', N'PO Box 4023', N'Milton Keynes', N'England', N'United Kingdom', N'MK8 8ZD', N'8f34cedd-fb6e-4814-b509-9965a31bc2e5', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (640, N'251 The Metro Center', NULL, N'Wokingham', N'England', N'United Kingdom', N'RG41 1QW', N'0e4ac5bb-be0d-4a96-a58e-064daec08e1a', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (641, N'Bradford', NULL, N'W. York', N'England', N'United Kingdom', N'BD1 4SJ', N'f7b99541-1ce1-4ab6-ae0d-548e8ff4abcd', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (642, N'Galashiels', NULL, N'Liverpool', N'England', N'United Kingdom', N'L4 4HB', N'3593cdf3-38ec-4847-ad42-157220e68f32', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (643, N'Banbury', NULL, N'Oxon', N'England', N'United Kingdom', N'OX16 8RS', N'99ff4c64-b405-4ac1-85ed-49e4e60ef87f', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (644, N'Bradford', N'Raven House, Kingsgate', N'W. York', N'England', N'United Kingdom', N'BD1 4SJ', N'65684e2e-d39c-4ef7-80d8-86c2f576c3c2', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (645, N'Garamonde Drive, Wymbush', N'P.O. Box 803', N'Milton Keynes', N'England', N'United Kingdom', N'MK8 8ZD', N'6ef999e7-5510-4b02-b89e-ddcf51ae3864', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (646, N'Butterfield Hse, 7-251 Chapel St', NULL, N'Lancaster', N'England', N'United Kingdom', N'LA1 1LN', N'bce1f4b3-a9c0-413e-ac8d-4c07a960e26c', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (647, N'Wade Road', NULL, N'Basingstoke Hants', N'England', N'United Kingdom', N'RG24 8PL', N'578c2529-f11c-4bf3-8084-6b505461e1cc', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (648, N'586 Fulham Road,', NULL, N'London', N'England', N'United Kingdom', N'SW6 SBY', N'0da65673-2a35-4e6a-a607-a6cc2d134ea8', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (649, N'Knaves Beech Ind.', NULL, N'High Wycombe', N'England', N'United Kingdom', N'HP10 9QY', N'11fcff74-5c80-4b37-a842-45c765d96029', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (650, N'Elmhurst Road, Goring', NULL, N'Reading', N'England', N'United Kingdom', N'RG7 5H7', N'e4c0c239-182f-45b7-a6bb-b7e142ff0657', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (651, N'New Millhouse, 2583 Milton Park', NULL, N'Abingdon', N'England', N'United Kingdom', N'OX14 4SE', N'e844b847-b0b3-491d-a4f1-0b78f56e4424', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (652, N'Wymbush', NULL, N'Milton Keynes', N'England', N'United Kingdom', N'MK8 8DF', N'54e20963-b0e9-41cf-ab7e-d50459a3325c', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (653, N'Burgess Hill', N'Edward Way', N'West Sussex', N'England', N'United Kingdom', N'RH15 9UD', N'38cc8647-b4bb-4669-b21d-c7497e76478d', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (654, N'308-3250 Casting Road', NULL, N'York', N'England', N'United Kingdom', N'Y024 1GF', N'9d67c322-8698-440a-8f3e-5e1e30edbd0d', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (655, N'Wharfdale Road', NULL, N'Berkshire', N'England', N'United Kingdom', N'RG11 5TP', N'd0e03fcb-116e-4ad2-8b17-5c2f9fd3e8b0', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (656, N'7 Pioneer Business Park', NULL, N'York', N'England', N'United Kingdom', N'Y03 4TN', N'48865e15-033a-40ff-8327-18723d4a8846', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (657, N'Unit 99a Battery Retail Pk', NULL, N'Birmingham', N'England', N'United Kingdom', N'B29 6SL', N'371a70e0-5802-4df9-bb28-5b6bdf202283', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (658, N'Ellesfield Ave', NULL, N'Bracknell', N'England', N'United Kingdom', N'RG12 8TB', N'bc28152f-8005-4c0e-98ff-51bf77a4a667', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (659, N'Warrington Ldc Unit 25/2', NULL, N'Woolston', N'England', N'United Kingdom', N'WA1 4SY', N'f44a7d0d-9bc5-427e-b3ae-f638dd5804b0', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (660, N'6 The Farm, Liberty Road', NULL, N'Maidenhead', N'England', N'United Kingdom', N'SL67RJ', N'e22d616b-ea06-48e9-a00f-b1c4bb02f595', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (661, N'725a The Arches', NULL, N'Berks', N'England', N'United Kingdom', N'SL4 1RH', N'38f5f598-e9bb-499c-b90d-088b2cd1b5bd', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (662, N'Paramount House', NULL, N'London', N'England', N'United Kingdom', N'W1N 9FA', N'e50d1077-d135-41cc-a0b1-c53395f94541', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (663, N'2524 Barlby Road', NULL, N'London', N'England', N'United Kingdom', N'W10 6BL', N'd8e96eba-258c-4f6c-83bb-4ccb2235bbf7', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (664, N'99-3 Forest Works', NULL, N'London', N'England', N'United Kingdom', N'E17 6JF', N'eb46af5a-ec2b-41ff-914e-ddae8ec1f476', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (665, N'46-44 Albemarle Street', NULL, N'London', N'England', N'United Kingdom', N'W1X3SE', N'1b01b172-96ce-4601-ad19-f545dcdfd62f', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (666, N'399 Clearing Green', NULL, N'London', N'England', N'United Kingdom', N'EC1R 0DU', N'bab4b0a1-055a-4581-a93f-e00c65c54fb6', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (667, N'997b Tradescant Road', NULL, N'London', N'England', N'United Kingdom', N'SW8 1XD', N'0a318015-4fbe-479a-b2da-eee21df430af', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (668, N'2574 Milton Park', NULL, N'Oxford', N'England', N'United Kingdom', N'OX14 4SE', N'62d0c689-cf44-4ab3-9c3e-6142f4e0101c', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (669, N'Internet House, 3399 Science Park', NULL, N'Cambridge', N'England', N'United Kingdom', N'CB4 4BZ', N'56baec2a-5cc5-4a90-bef9-ee57e82f2e69', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (670, N'7 Garden House Cloisters, 8 Batters', NULL, N'London', N'England', N'United Kingdom', N'SW8 4BG', N'333daff8-f22f-488c-928c-e6eccf65452b', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (671, N'25 Hartfield Road, Wimbledon', NULL, N'London', N'England', N'United Kingdom', N'SW19 3RU', N'00fd96bc-6ee6-4d2c-a88c-07bc1cae6efe', CAST(N'2008-02-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (672, N'99 Dean Street, Soho', NULL, N'London', N'England', N'United Kingdom', N'W1V 5RN', N'ecebd4b1-11c3-4681-a6da-2f73148fb63e', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (673, N'Park House-4th Floor, 2516 Park St.', NULL, N'London', N'England', N'United Kingdom', N'W1Y 3RA', N'2506679e-041b-4d52-b9a9-07a0d5e88eea', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (674, N'67 Vincent Square, Victoria', NULL, N'London', N'England', N'United Kingdom', N'SW1P 2NU', N'1a398c1b-2085-4f6d-a6eb-56493855c5d1', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (756, N'855 East Main Avenue', NULL, N'Zeeland', N'Michigan', N'United States', N'49464', N'7cc420b7-b43c-4e40-98ed-6c10cec91c54', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (774, N'9920 North Telegraph Rd.', NULL, N'Pontiac', N'Michigan', N'United States', N'48342', N'7bc77b2e-ed84-443a-bd50-f67718dea95d', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (775, N'46460 West Oaks Drive', NULL, N'Novi', N'Michigan', N'United States', N'48375', N'd0614a62-08e0-4f83-ac72-51f58170b653', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (776, N'997000 Telegraph Rd.', NULL, N'Southfield', N'Michigan', N'United States', N'48034', N'f0159341-8cdb-4587-bc74-95ffb9e7d662', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (785, N'399700 John R. Rd.', NULL, N'Madison Heights', N'Michigan', N'United States', N'48071', N'7b234147-cd95-45e8-a1d5-711fe6a33dac', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (786, N'6789 Warren Road', NULL, N'Westland', N'Michigan', N'United States', N'48185', N'90b0cf86-70e1-45d8-b6fd-0e1804a734c2', CAST(N'2006-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (788, N'2533 Eureka Rd.', NULL, N'Southgate', N'Michigan', N'United States', N'48195', N'7ef698fa-908e-42bb-8a2d-c62f5106323a', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (789, N'250000 Eight Mile Road', NULL, N'Detroit', N'Michigan', N'United States', N'48226', N'66255753-b1b9-49c0-ab1d-1de8217d5142', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (794, N'998 Forest Road', NULL, N'Saginaw', N'Michigan', N'United States', N'48601', N'01094c1b-2d79-402d-8106-9e80fbd57dc8', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (795, N'99800 Tittabawasee Rd.', NULL, N'Saginaw', N'Michigan', N'United States', N'48601', N'34d6d2d5-feec-40b8-97b5-cceb89164305', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (797, N'678 Eastman Ave.', NULL, N'Midland', N'Michigan', N'United States', N'48640', N'986de66f-74e6-4830-a2ad-9212efb77b76', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (801, N'Horizon Outlet Center', NULL, N'Holland', N'Michigan', N'United States', N'49423', N'dc15ba52-b66c-4c5f-bdaf-1713e8c54b46', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (806, N'Horizon Outlet Center', NULL, N'Monroe', N'Michigan', N'United States', N'98272', N'a986c31b-4b63-4925-aafd-b95260d5d586', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (810, N'Redford Plaza', NULL, N'Redford', N'Michigan', N'United States', N'48239', N'43e988f4-b82d-4424-a59f-43dd81f9016b', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (825, N'Port Huron', NULL, N'Port Huron', N'Michigan', N'United States', N'48060', N'a1cadf47-c018-40cc-8381-6cc940de46c8', CAST(N'2005-10-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (826, N'Kensington Valley Shops', NULL, N'Howell', N'Michigan', N'United States', N'48843', N'c2d04d48-ef2b-4349-877b-ea6df9895079', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (832, N'2251 Elliot Avenue', NULL, N'Seattle', N'Washington', N'United States', N'98104', N'6d6a8e1a-ffd8-4d2d-a70d-88467049a880', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (833, N'3207 S Grady Way', NULL, N'Renton', N'Washington', N'United States', N'98055', N'4e670a74-8ace-44c8-91ed-76cba7190bc2', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (834, N'99300 223rd Southeast', NULL, N'Bothell', N'Washington', N'United States', N'98011', N'd505aea8-b89a-41ed-90a9-44d4179eff77', CAST(N'2007-04-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (835, N'259826 Russell Rd. South', NULL, N'Kent', N'Washington', N'United States', N'98031', N'5d3832b3-72dd-4a9b-a596-8293d4037c18', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (836, N'35525-9th Street Sw', NULL, N'Puyallup', N'Washington', N'United States', N'98371', N'77232d41-48bb-4c8d-8323-5581753e9531', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (837, N'640 South 994th St. W.', NULL, N'Billings', N'Montana', N'United States', N'59101', N'4e75ad15-557e-4c4d-9aeb-68a9718b412a', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (838, N'25300 Biddle Road', NULL, N'Medford', N'Oregon', N'United States', N'97504', N'349cbab0-e4e3-40b2-ac50-3ea087110f8b', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (839, N'Gateway', NULL, N'Portland', N'Oregon', N'United States', N'97205', N'3a56b180-70cd-42fe-a19c-f62b5037aa3a', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (840, N'Great Northwestern', NULL, N'North Bend', N'Washington', N'United States', N'98045', N'1ef6e60f-3582-4298-a7ad-195be59ba7b7', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (841, N'Washington Square', NULL, N'Portland', N'Oregon', N'United States', N'97205', N'7b5ae329-fb7c-4a2c-b33c-827920acacdc', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (842, N'258101 Nw Evergreen Parkway', NULL, N'Beaverton', N'Oregon', N'United States', N'97005', N'eb5a214a-15a1-4e25-b405-dc0ef9907874', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (843, N'253950 N.E. 178th Place', NULL, N'Woodinville', N'Washington', N'United States', N'98072', N'e75a2222-d636-4494-a314-2125ee2336f8', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (844, N'755 Nw Grandstand', NULL, N'Issaquah', N'Washington', N'United States', N'98027', N'0e8578f8-21f7-482d-8dd8-8aa52f68f70a', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (845, N'22571 South 2500 East', NULL, N'Idaho Falls', N'Idaho', N'United States', N'83402', N'1e5743c8-b8f7-4a65-b812-0302ffcb9d0e', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (846, N'257700 Ne 76th Street', NULL, N'Redmond', N'Washington', N'United States', N'98052', N'e606ad23-f6d4-4aa5-b177-7d03d62b0187', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (847, N'25102 Springwater', NULL, N'Wenatchee', N'Washington', N'United States', N'98801', N'f84f402f-9bd5-432e-a1d6-f284a6dffa29', CAST(N'2006-06-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (848, N'Bldg. 9n/99298', NULL, N'Redmond', N'Washington', N'United States', N'98052', N'f8ef420d-b3c8-48b1-a237-4a7d2dad987e', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (849, N'4251 First Avenue', NULL, N'Seattle', N'Washington', N'United States', N'98104', N'a077368b-26bf-41b7-b35f-fc380092e6b9', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (850, N'558 S 6th St', NULL, N'Klamath Falls', N'Oregon', N'United States', N'97601', N'329894ab-0142-4d9b-9851-2da2f6dc95e3', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (851, N'994 Sw Cherry Park Rd', NULL, N'Troutdale', N'Oregon', N'United States', N'97060', N'fcde15ff-85d3-4136-9fb6-ea493f39605e', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (852, N'25718 Se Sunnyside Rd', NULL, N'Clackamas', N'Oregon', N'United States', N'97015-6403', N'e85ac59f-59b6-4ed2-9436-fcdb78959b80', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (853, N'567 Sw Mcloughlin Blvd', NULL, N'Milwaukie', N'Oregon', N'United States', N'97222', N'055b060a-7da2-455c-bcb3-a8dcea4c5156', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (854, N'490 Ne 4th St', NULL, N'Renton', N'Washington', N'United States', N'98055', N'471190d7-86c1-48cd-985a-7046b1b89c3c', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (855, N'15 East Main', NULL, N'Port Orchard', N'Washington', N'United States', N'98366', N'09926325-7f83-427b-83d6-817df7d70ce9', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (856, N'3025 E Waterway Blvd', NULL, N'Shelton', N'Washington', N'United States', N'98584', N'779d4f7d-c90c-4a8a-bf29-41613e8907ef', CAST(N'2006-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (857, N'7990 Ocean Beach Hwy.', NULL, N'Longview', N'Washington', N'United States', N'98632', N'873d03b3-e2ef-4b8b-add8-f237fdc7fe31', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (858, N'2345 West Spencer Road', NULL, N'Lynnwood', N'Washington', N'United States', N'98036', N'68aeb59d-0f79-4a0d-92ef-4d0c2beb5821', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (859, N'1050 Oak Street', NULL, N'Seattle', N'Washington', N'United States', N'98104', N'8caaf6be-9c88-466d-862c-ae7673e3d0f0', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (860, N'4927 S Meridian Ave Ste D', NULL, N'Puyallup', N'Washington', N'United States', N'98371', N'ff2be5e9-7d22-4c1c-acf8-199148e957ab', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (861, N'25915 140th Ave Ne', NULL, N'Bellevue', N'Washington', N'United States', N'98004', N'0d46f203-cdb6-4495-83f5-a97ff0cec174', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (862, N'3307 Evergreen Blvd', N'Ste 1071', N'Washougal', N'Washington', N'United States', N'98671', N'0c81cbd2-96d3-40c1-97d4-056d776b7676', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (863, N'2507 Pacific Ave S', NULL, N'Tacoma', N'Washington', N'United States', N'98403', N'fbac273f-934e-474f-9ccb-f96ca9ae889d', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (864, N'67 Rainer Ave S', NULL, N'Renton', N'Washington', N'United States', N'98055', N'a2fc2f01-c6be-4af4-b718-2a86eb782e5f', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (865, N'750 Lakeway Dr', NULL, N'Bellingham', N'Washington', N'United States', N'98225', N'243020ec-84c3-417a-b34d-f7760ff130d1', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (866, N'2528 Meridian E', NULL, N'Puyallup', N'Washington', N'United States', N'98371', N'5668e02c-16fa-4331-8603-29ee11417843', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (867, N'48995 Evergreen Wy.', NULL, N'Everett', N'Washington', N'United States', N'98201', N'6cd4e374-0ef8-4cee-ac60-9dbf1f4e0007', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (868, N'25111 228th St Sw', NULL, N'Bothell', N'Washington', N'United States', N'98011', N'40100c97-5097-43be-9f44-abd881220e8f', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (869, N'2583 Se 272nd St', NULL, N'Kent', N'Washington', N'United States', N'98031', N'e13c4f18-990a-4b7d-9fc9-afd0ea943b13', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (870, N'409 S. Main Ste. 25', NULL, N'Ellensburg', N'Washington', N'United States', N'98926', N'955e88ea-083d-446e-a856-42cb0692826a', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (871, N'2502 Evergreen Ste E', NULL, N'Everett', N'Washington', N'United States', N'98201', N'3ae9003f-f806-41ad-98a5-3c4a86514bc3', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (872, N'755 W Washington Ave Ste D', NULL, N'Sequim', N'Washington', N'United States', N'98382', N'932514a1-04e4-4e95-b97c-0ad4c06b890e', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (873, N'44606 N Division St', NULL, N'Spokane', N'Washington', N'United States', N'99202', N'3438afb3-390c-48d5-8ccf-5438278d981d', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (874, N'2550 Ne Sandy Blvd', NULL, N'Portland', N'Oregon', N'United States', N'97205', N'14d5dde7-c771-4819-9ff1-a4faa66f0e7a', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (875, N'2540 Dell Range Blvd', NULL, N'Cheyenne', N'Wyoming', N'United States', N'82001', N'3ac8958a-76ee-41ca-8a88-2b783ea18acc', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (876, N'765 Delridge Way Sw', NULL, N'Seattle', N'Washington', N'United States', N'98104', N'cb1392f5-fcb9-4cf5-b4c9-33fafb876c3d', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (877, N'4781 Highway 95', NULL, N'Sandpoint', N'Idaho', N'United States', N'83864', N'49f0b458-40cd-4852-a936-8576070fcb96', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (878, N'4210 E Sprague Ave', NULL, N'Spokane', N'Washington', N'United States', N'99202', N'7c04cf1b-ad79-44d4-9611-381b2f094f96', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (879, N'Valley Mall', NULL, N'Union Gap', N'Washington', N'United States', N'98903', N'860cb49b-5774-441f-b8c5-753ca50fa5e1', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (880, N'S Sound Ctr Suite 25300', NULL, N'Lacey', N'Washington', N'United States', N'98503', N'3a400497-1000-4d9f-bb8d-d9cbf00c2822', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (881, N'Southgate Mall', NULL, N'Missoula', N'Montana', N'United States', N'59801', N'3ded7f59-79a9-4034-98f9-f2a0b045d7ae', CAST(N'2006-10-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (882, N'Medford', NULL, N'Medford', N'Oregon', N'United States', N'97504', N'dbc16bdd-c86d-4d5f-91f5-79fa000716fb', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (883, N'Heritage Mall', NULL, N'Albany', N'Oregon', N'United States', N'97321', N'cf9c1921-d741-4576-9d32-849e62d57698', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (884, N'Lewis County Mall', NULL, N'Chehalis', N'Washington', N'United States', N'98532', N'2f91410b-2988-4e8f-bf01-8009c2f9abba', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (885, N'755 Columbia Ctr Blvd', NULL, N'Kennewick', N'Washington', N'United States', N'99337', N'f3b58620-4857-44a0-9c48-51f21c1ca0c8', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (886, N'Lancaster Mall', NULL, N'Salem', N'Oregon', N'United States', N'97301', N'3513c4cd-96af-4e5f-b3ff-32d268fb5f54', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (887, N'Lewiston Mall', NULL, N'Lewiston', N'Idaho', N'United States', N'83501', N'4ddbacc9-7898-403e-856a-128e34245424', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (888, N'Three Rivers Mall', NULL, N'Kelso', N'Washington', N'United States', N'98626', N'834ae73a-01a9-4850-9f8c-6db5d1344aad', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (889, N'Eastridge Mall', NULL, N'Casper', N'Wyoming', N'United States', N'82601', N'6d5c5880-2c83-4df1-b8ce-46cfe9a9ffac', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (890, N'Holiday Village Mall', NULL, N'Great Falls', N'Montana', N'United States', N'59401', N'5fe7c888-bb21-421e-9b8b-38da8da10085', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (891, N'2526a Tri-Lake Blvd Ne', NULL, N'Kirkland', N'Washington', N'United States', N'98033', N'ec34e865-d130-403f-a437-d92d7ef02f05', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (892, N'Frontier Mall', NULL, N'Cheyenne', N'Wyoming', N'United States', N'82001', N'cb0a8223-fd82-4d26-b7c7-0c120e4eafc5', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (893, N'White Mountain Mall', NULL, N'Rock Springs', N'Wyoming', N'United States', N'82901', N'9308a21d-aae2-42e2-889d-2cd802072d36', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (894, N'3390 South 23rd St.', NULL, N'Tacoma', N'Washington', N'United States', N'98403', N'e7979fa4-253c-41fd-b74f-2feec966a6b5', CAST(N'2006-01-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (895, N'3250 South Meridian', NULL, N'Puyallup', N'Washington', N'United States', N'98371', N'3b2e6107-040b-4f60-8901-a950bf0562d4', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (896, N'2255 254th Avenue Se', NULL, N'Albany', N'Oregon', N'United States', N'97321', N'77d18072-b99b-4b1e-a9b9-948fa927efbb', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (897, N'705 SE Mall Parkway', NULL, N'Everett', N'Washington', N'United States', N'98201', N'77a34652-5d9b-40b6-a15a-56d7ee4056f4', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (898, N'700 Se Sunnyside Road', NULL, N'Clackamas', N'Oregon', N'United States', N'97015', N'd88449db-7116-427b-bfaf-cae7c08de084', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (899, N'North 93270 Newport Highway', NULL, N'Spokane', N'Washington', N'United States', N'99202', N'8ae1c168-958e-41da-92d8-7a3a0765f744', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (900, N'25708 Dell Range Blvd.', NULL, N'Cheyenne', N'Wyoming', N'United States', N'82001', N'9b10fe3a-a1fb-497e-8bc2-e84e8c2a77da', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (901, N'No. 60 Bellis Fair Parkway', NULL, N'Bellingham', N'Washington', N'United States', N'98225', N'8135b5dc-f7e9-401c-992c-93a058ada079', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (902, N'950 Gateway Street', NULL, N'Springfield', N'Oregon', N'United States', N'97477', N'e8beecaf-8668-4d53-97e8-405bc6978def', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (903, N'250775 SW Hillsdale Hwy', NULL, N'Beaverton', N'Oregon', N'United States', N'97005', N'ac8f33f8-4dc4-467d-b459-788d84749c5d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (904, N'9905 Three Rivers Drive', NULL, N'Kelso', N'Washington', N'United States', N'98626', N'01a85112-6ee1-4f2c-9212-1c2abc612e67', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (905, N'225 South 314th Street', NULL, N'Federal Way', N'Washington', N'United States', N'98003', N'd305d73c-d595-4961-b870-0dcecb7c6ea9', CAST(N'2006-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (906, N'7009 Sw Hall Blvd.', NULL, N'Tigard', N'Oregon', N'United States', N'97223', N'b8efdbfa-3ba9-45d8-9c09-646dd0c8af93', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (907, N'99295 S.e. Tualatin Valley_hwy.', NULL, N'Hillsboro', N'Oregon', N'United States', N'97123', N'a0e88130-6262-4484-815e-e5c485bf3eac', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (988, N'482505 Warm Springs Blvd.', NULL, N'Fremont', N'California', N'United States', N'94536', N'cd6d22b0-d941-4928-b6f7-1508021e6539', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (989, N'39933 Mission Oaks Blvd', NULL, N'Camarillo', N'California', N'United States', N'93010', N'8b1241ca-1db6-4f9d-861e-1d6cc3796443', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (990, N'5420 West 22500 South', NULL, N'Salt Lake City', N'Utah', N'United States', N'84101', N'7612c47a-e24a-4bd8-9b8b-3aed15af64f9', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (991, N'60025 Bollinger Canyon Road', NULL, N'San Ramon', N'California', N'United States', N'94583', N'962a4d00-c5aa-41cc-b7bc-2afbe2fa65b8', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (992, N'9992 Whipple Rd', NULL, N'Union City', N'California', N'United States', N'94587', N'88258a1b-b50f-440f-93b9-5d7af831d5fc', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (993, N'Corporate Office', NULL, N'El Segundo', N'California', N'United States', N'90245', N'6cccc74f-6389-4d08-8ed1-9079b42cf7ae', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (994, N'25001 Montague Expressway', NULL, N'Milpitas', N'California', N'United States', N'95035', N'89901b2a-fda8-4926-b22c-dd5d583681a6', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (995, N'4460 Newport Center Drive', NULL, N'Newport Beach', N'California', N'United States', N'92625', N'd6b9e9e9-f288-4590-be12-8ddbb5e53bc2', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (996, N'2575 West 2700 South', NULL, N'Salt Lake City', N'Utah', N'United States', N'84101', N'708fc1dd-4994-4aa5-80a5-8c977c37aa15', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (997, N'70259 West Sunnyview Ave', NULL, N'Visalia', N'California', N'United States', N'93291', N'7c2e0511-de61-4761-80ea-6a7b2f39e524', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (998, N'60750 San Clemente', NULL, N'Hayward', N'California', N'United States', N'94541', N'822dc2be-aac2-4283-93a6-5027cfb6a7df', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (999, N'Receiving', NULL, N'Fullerton', N'California', N'United States', N'92831', N'93d3c32f-cc26-4f27-b91f-35a804554976', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1000, N'22555 Paseo De Las Americas', NULL, N'San Diego', N'California', N'United States', N'92102', N'982bdcc2-6429-4725-a6df-4faf032ec908', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1001, N'Incom Sports Center', NULL, N'Ontario', N'California', N'United States', N'91764', N'079e5de8-169f-4eb6-be75-813b40a0143e', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1002, N'C/O Starpak, Inc.', NULL, N'Greeley', N'Colorado', N'United States', N'80631', N'512bd07c-7ed7-421b-923f-d41999bd5bd7', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1003, N'5967 W Las Positas Blvd', NULL, N'Pleasanton', N'California', N'United States', N'94566', N'6b26292f-1ebe-41ce-9a3e-ff42d3c10a44', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1004, N'25600 E St Andrews Pl', NULL, N'Santa Ana', N'California', N'United States', N'92701', N'489390e0-48c0-4bb4-a5dc-38c4b39ea833', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1005, N'6756 Mowry', NULL, N'Newark', N'California', N'United States', N'94560', N'cfb5ed2a-43fe-4102-8413-73c74dacc79e', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1006, N'25472 Marlay Ave', NULL, N'Fontana', N'California', N'United States', N'92335', N'90c5f983-b302-4f6c-9d8a-bfb9e1bff406', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1007, N'77 Beale Street', N'Room 99767c', N'San Francisco', N'California', N'United States', N'94109', N'5122f535-c03e-4244-90c8-5d360c0c4cc4', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1008, N'910 Main Street.', NULL, N'Sparks', N'Nevada', N'United States', N'89431', N'f12c6f58-6095-47d4-9fa0-21a639b90db9', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1009, N'2500 N Serene Blvd', N'19th Floor', N'El Segundo', N'California', N'United States', N'90245', N'7619e3bd-780b-45b1-a477-8fc3e0948352', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1010, N'5650 West 88th Ave.', NULL, N'Westminster', N'Colorado', N'United States', N'80030', N'bd7fa7a0-4cbe-442a-a5e5-e5e2b79214ec', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1011, N'9700 Sisk Road', NULL, N'Modesto', N'California', N'United States', N'95354', N'fb563347-c157-43b3-a7e4-a851495df874', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1012, N'789 West Alameda', NULL, N'Westminster', N'Colorado', N'United States', N'80030', N'73bf97f3-e4e3-402d-8609-7839aebaa947', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1013, N'54254 Pacific Ave.', NULL, N'Stockton', N'California', N'United States', N'95202', N'7b82a39f-d175-4543-8f6f-ae6fe9c34a99', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1014, N'25136 Jefferson Blvd.', NULL, N'Culver City', N'California', N'United States', N'90232', N'05196d3f-f726-4ab9-a66b-af87500846ad', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1015, N'99000 S. Avalon Blvd. Suite 750', NULL, N'Carson', N'California', N'United States', N'90746', N'206163d9-0324-476d-909e-607fe07b2a2a', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1016, N'72502 Eastern Ave.', NULL, N'Bell Gardens', N'California', N'United States', N'90201', N'06431d74-4caf-442c-870e-efc20f9d45b8', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1017, N'2560 E. Newlands Dr', NULL, N'Fernley', N'Nevada', N'United States', N'89408', N'5d07c55b-9e6a-49de-8f49-04f28ad2f36a', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1018, N'630 N. Capitol Ave.', NULL, N'San Jose', N'California', N'United States', N'95112', N'aceb7a03-c8e6-43f6-94f2-266e571bd413', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1019, N'4660 Rodeo Road', NULL, N'Santa Fe', N'New Mexico', N'United States', N'87501', N'4fe824c1-f1bc-48b6-a4fd-6b866d0d07c8', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1020, N'251340 E. South St.', NULL, N'Cerritos', N'California', N'United States', N'90703', N'ba72737a-0827-46a8-af5b-971fd8464a87', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1021, N'440 West Huntington Dr.', NULL, N'Monrovia', N'California', N'United States', N'91016', N'2ae4d8c2-6d11-4945-a032-430dc8ce5b1b', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1022, N'99235 Hawthorne Blvd.', NULL, N'Torrance', N'California', N'United States', N'90505', N'52724cd9-1dc9-4d28-9b89-c404692c0b73', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1023, N'870 N. 54th Ave.', NULL, N'Chandler', N'Arizona', N'United States', N'85225', N'26d3a3ec-3d51-493e-a541-a0cc80b54f35', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1024, N'9952 E. Lohman Ave.', NULL, N'Las Cruces', N'New Mexico', N'United States', N'88001', N'42af4b56-ece2-4595-929d-fb60db1392d9', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1025, N'2530 South Colorado Blvd.', NULL, N'Denver', N'Colorado', N'United States', N'80203', N'012ef479-5dad-4009-b456-24e47ca1f472', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1026, N'955 E. County Line Rd.', NULL, N'Englewood', N'Colorado', N'United States', N'80110', N'17a96f13-8658-4f02-a557-2bc4463ade21', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1027, N'409 Santa Monica Blvd.', NULL, N'Santa Monica', N'California', N'United States', N'90401', N'58d58e3e-bf3e-4e0c-8f96-1717821e3516', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1028, N'Mall Of Orange', NULL, N'Orange', N'California', N'United States', N'92867', N'8d9b75cc-90c4-4e15-b69c-891126386ba6', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1029, N'Topanga Plaza', NULL, N'Canoga Park', N'California', N'United States', N'91303', N'0b945127-9c6f-47a1-80e4-2fb0e057fa55', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1030, N'Escondido', NULL, N'Escondido', N'California', N'United States', N'92025', N'e5b6618d-a92b-4da1-ba99-316babfff7db', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1031, N'Natomas Marketplace', NULL, N'Sacramento', N'California', N'United States', N'95814', N'27af5ed8-d33a-4fb2-9c55-d5cdd5017cd4', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1032, N'Simi @ The Plaza', NULL, N'Simi Valley', N'California', N'United States', N'93065', N'8e4a379f-f6d6-4995-aa19-6db50325d0fe', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1033, N'Lakewood Mall', NULL, N'Lakewood', N'California', N'United States', N'90712', N'd28c7fef-9ea3-458f-a2b9-11964c3cc60b', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1034, N'Oxnard Outlet', NULL, N'Oxnard', N'California', N'United States', N'93030', N'300d2a6e-67b4-417b-83a9-2026818a21c6', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1035, N'Vista Marketplace', NULL, N'Alhambra', N'California', N'United States', N'91801', N'7795fcdf-76c3-4627-86b2-0291398868de', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1036, N'Sports Store At Park City', NULL, N'Park City', N'Utah', N'United States', N'84098', N'a04ec332-1120-4ac3-837e-97efc40636b2', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1037, N'North County Square', NULL, N'Vista', N'California', N'United States', N'92084', N'5a794553-877e-4977-8e76-de38aa064ebd', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1038, N'123 Camelia Avenue', NULL, N'Oxnard', N'California', N'United States', N'93030', N'a86c8140-ad7d-4caa-9b40-4006bd9998e2', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1039, N'Mountain Square', NULL, N'Upland', N'California', N'United States', N'91786', N'8f1bdc33-0bfb-41d0-bb85-71aafe6126e7', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1040, N'Fox Hills', NULL, N'Culver City', N'California', N'United States', N'90232', N'5042b0a9-d10a-4f99-9f6f-50f96defa226', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1041, N'Parkway Plaza', NULL, N'El Cajon', N'California', N'United States', N'92020', N'c0fdc154-d2b5-480d-a5da-4e0d6b5d750c', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1042, N'Stonewood Mall', NULL, N'Downey', N'California', N'United States', N'90241', N'd1d79211-aec3-424d-a279-af1d01da3ec2', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1043, N'Hanford Mall', NULL, N'Hanford', N'California', N'United States', N'93230', N'f4f57d92-1839-49f4-a491-63f43215aaf1', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1044, N'Ontario Mills', NULL, N'Ontario', N'California', N'United States', N'91764', N'c66b86d8-bdfc-4161-9cbf-9a46d5f57b91', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1045, N'Nut Tree Factory', NULL, N'Vacaville', N'California', N'United States', N'95688', N'eb58eebb-3f55-45d1-9702-eddaccd687e2', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1046, N'Rocky Mountain Pines Outlet', NULL, N'Loveland', N'Colorado', N'United States', N'80537', N'518e7219-193f-4d72-90c9-e82f201afbe4', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1047, N'Stevens Creek Shopping Center', NULL, N'San Jose', N'California', N'United States', N'95112', N'0e6f74f0-9128-4688-9007-6395d6c6f4c4', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1048, N'Factory Merchants', NULL, N'Barstow', N'California', N'United States', N'92311', N'470574f9-6a06-43dc-a4b9-de3c8d88b0e6', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1049, N'The Citadel Commerce Plaza', NULL, N'City Of Commerce', N'California', N'United States', N'90040', N'42cd575b-22a1-42e0-93bb-d8ee998e4fb7', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1050, N'University Town Center', NULL, N'San Diego', N'California', N'United States', N'92102', N'6d9ebb03-5c5a-4a20-8910-12d894591727', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1051, N'Pavillion @ Redlands', NULL, N'Redlands', N'California', N'United States', N'92373', N'b2f0f099-ddd2-4ab6-90af-972d72186937', CAST(N'2005-10-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1052, N'San Diego Factory', NULL, N'San Ysidro', N'California', N'United States', N'92173', N'8c3cff8c-3a5d-419a-8dd8-3349c29aa3fd', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1053, N'Pacific West Outlet', NULL, N'Gilroy', N'California', N'United States', N'95020', N'de6463d5-42d9-4d34-ac99-4aaa19fab3ca', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1054, N'Belz Factory Outlet', NULL, N'Las Vegas', N'Nevada', N'United States', N'89106', N'0e75e01f-76d4-4420-beb7-0033f16dea62', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1055, N'Camarillo Athletic Stores', NULL, N'Camarillo', N'California', N'United States', N'93010', N'30e691f7-1d06-4df7-aedf-627ad911a770', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1056, N'Lake Elisnor Place', NULL, N'Lake Elsinore', N'California', N'United States', N'92530', N'596345c5-0be2-444d-ba93-d109713bc0b6', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1057, N'Norwalk Square', NULL, N'Norwalk', N'California', N'United States', N'90650', N'ccce93be-ab0b-4211-8407-5be45034534c', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1058, N'Riverside', NULL, N'Sherman Oaks', N'California', N'United States', N'91403', N'a26100f0-511f-45a2-879a-ff365794fcf5', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1059, N'The Quad @ WestView', NULL, N'Whittier', N'California', N'United States', N'90605', N'2215f750-1863-4aff-926d-de309c298de9', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1060, N'Arcadia Crossing', NULL, N'Phoenix', N'Arizona', N'United States', N'85004', N'cc91297c-567b-4186-96c8-2ba6f0875e73', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1061, N'Eastern Beltway Center', NULL, N'Las Vegas', N'Nevada', N'United States', N'89106', N'84603598-f6d4-4e26-9b9e-6a468365d4d8', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1062, N'Factory Stores/tucson', NULL, N'Tucson', N'Arizona', N'United States', N'85701', N'c15eca9a-6054-40e4-8d09-d4341aabce2d', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1063, N'Viejas Outlet Center', NULL, N'Alpine', N'California', N'United States', N'91901', N'4f8ec2c2-71d6-4b7f-bcc7-808e17696373', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1064, N'West Park Plaza', NULL, N'Irvine', N'California', N'United States', N'92614', N'365914ce-cbb2-429b-a2d8-24638fcf17fc', CAST(N'2006-01-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1065, N'Factory Stores Of America', NULL, N'Mesa', N'Arizona', N'United States', N'85201', N'1b96d3a3-ed06-482f-a813-7136e5aaa57d', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1066, N'Prime Outlets', NULL, N'Phoenix', N'Arizona', N'United States', N'85004', N'bd687691-297f-4b72-9465-c8dbd0f8e2ee', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1067, N'Bayshore Mall', NULL, N'Eureka', N'California', N'United States', N'95501', N'001d1a67-585c-44b2-aac6-1199afd7425f', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1068, N'7709 West Virginia Avenue', NULL, N'Phoenix', N'Arizona', N'United States', N'85004', N'b8184c93-a8de-4321-b381-1babc7088d60', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1069, N'6900 Sisk Road', NULL, N'Modesto', N'California', N'United States', N'95354', N'60110399-edf3-4c06-ac87-1d9856e9d2e3', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1070, N'3250 Baldwin Park Blvd', NULL, N'Baldwin Park', N'California', N'United States', N'91706', N'957ec59c-7a7d-438e-9014-20fbeb807e99', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1071, N'5867 Sunrise Boulevard', NULL, N'Citrus Heights', N'California', N'United States', N'95610', N'a64fc10b-61f7-4102-b076-e9cb77e9ec8f', CAST(N'2006-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1072, N'6500 East Grant Road', NULL, N'Tucson', N'Arizona', N'United States', N'85701', N'b9265d45-3fed-4b7d-aeea-00d0e54b3cc7', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1073, N'3065 Santa Margarita Parkway', NULL, N'Trabuco Canyon', N'California', N'United States', N'92679', N'c5c0801f-f124-4a5e-b8ba-0ace3bf0f993', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1074, N'9920 Bridgepointe Parkway', NULL, N'San Mateo', N'California', N'United States', N'94404', N'c346981b-2093-474a-9bc0-54ce2e0e4a94', CAST(N'2005-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1075, N'5525 South Hover Road', NULL, N'Longmont', N'Colorado', N'United States', N'80501', N'e5fa71b3-685a-4d11-bc0c-e4aa69cd4ded', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1076, N'8525 South Parker Road', NULL, N'Parker', N'Colorado', N'United States', N'80138', N'd4f4ab28-5f27-4f89-a0d6-5fcea394bb47', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1077, N'7505 Laguna Boulevard', NULL, N'Elk Grove', N'California', N'United States', N'95624', N'b6213e39-9da3-4423-8756-0b195ed95fb4', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1078, N'9909 W. Ventura Boulevard', NULL, N'Camarillo', N'California', N'United States', N'93010', N'0a911f46-295e-4485-a9d8-90dfcc0c9223', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1079, N'25150 El Camino Real', NULL, N'San Bruno', N'California', N'United States', N'94066', N'9f1bc24e-66f2-41e2-94a2-d1001c050bb4', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1080, N'2575 Rocky Mountain Ave.', NULL, N'Loveland', N'Colorado', N'United States', N'80537', N'bcc0867e-cb4e-4852-994e-03abed8c95ab', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1081, N'25871 North Main Street', NULL, N'Walnut Creek', N'California', N'United States', N'94596', N'a00218d5-482d-44c2-8cd0-6f65af8642d3', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1082, N'2551 East Warner Road', NULL, N'Gilbert', N'Arizona', N'United States', N'85233', N'd88afbda-b59b-496e-ba6d-b3b2356574ff', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1083, N'22589 West Craig Road', NULL, N'North Las Vegas', N'Nevada', N'United States', N'89030', N'a4c2efe6-17e5-4dd5-9bed-6743405627e7', CAST(N'2007-05-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1084, N'25751 University Drive', NULL, N'Vista', N'California', N'United States', N'92084', N'bd3035f6-4018-4e4c-8d70-6dd3f4fe8eb4', CAST(N'2007-05-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1085, N'49925 Crestview Drive N.E.', NULL, N'Rio Rancho', N'New Mexico', N'United States', N'87124', N'3a1f16cf-6889-40b2-b067-7d044a8c7d42', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1086, N'57251 Serene Blvd', NULL, N'Van Nuys', N'California', N'United States', N'91411', N'7df3a412-f2b3-4abb-88e1-21d4677f1311', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1087, N'253731 West Bell Road', NULL, N'Surprise', N'Arizona', N'United States', N'85374', N'4ba77e6a-4a47-4bfe-8aeb-dbfea179795d', CAST(N'2006-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1088, N'99040 California Avenue', NULL, N'Sand City', N'California', N'United States', N'93955', N'a18799a1-342a-4b6c-a63c-8e4e2c07f734', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1089, N'25620 Firestone Boulevard', NULL, N'Norwalk', N'California', N'United States', N'90650', N'31a07731-18ff-4100-8319-b4704f414497', CAST(N'2007-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1090, N'25130 South State Street', NULL, N'Sandy', N'Utah', N'United States', N'84070', N'cf3ae92a-3e66-4af0-b683-731826e89cd1', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1091, N'5500 Grossmont Center Drive', NULL, N'La Mesa', N'California', N'United States', N'91941', N'24f1dbc4-7fdc-4edb-b3cb-640f9fb72534', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1092, N'99700 Bell Road', NULL, N'Auburn', N'California', N'United States', N'95603', N'79cdd89c-3c91-48db-8277-46d04aad7251', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1093, N'7750 E Marching Rd', NULL, N'Scottsdale', N'Arizona', N'United States', N'85257', N'f181458a-b5a3-4944-b7b1-73dcad67c14e', CAST(N'2007-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1094, N'25250 N 90th St', NULL, N'Scottsdale', N'Arizona', N'United States', N'85257', N'3e024d96-b7d3-4622-ab9b-0724b91b7832', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1095, N'9980 S Alma School Road', NULL, N'Chandler', N'Arizona', N'United States', N'85225', N'b09b3f8e-89f2-4528-9578-53cbcf805b4a', CAST(N'2007-02-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1096, N'6753 Howard Hughes Parkway', NULL, N'Las Vegas', N'Nevada', N'United States', N'89106', N'30c83112-a09f-4e26-9ad7-4fd6c10fec4e', CAST(N'2006-10-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1097, N'Corp Ofc Accts Payable', NULL, N'El Segundo', N'California', N'United States', N'90245', N'5f6d242f-dda3-462c-bec1-097c63913176', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1098, N'Po Box 252525', NULL, N'Santa Ana', N'California', N'United States', N'92701', N'7d2bd572-f8ab-435a-a47b-3a534d7d9cdc', CAST(N'2006-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1099, N'62500 Neil Road', NULL, N'Reno', N'Nevada', N'United States', N'89502', N'be51f10f-1a66-46e6-8154-9fe01597769c', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1100, N'4635 S. Harrison Blvd.', NULL, N'Ogden', N'Utah', N'United States', N'84401', N'be4dfeef-cb1c-4af8-b517-3214c7c1f311', CAST(N'2007-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1101, N'825 W 500 S', NULL, N'Bountiful', N'Utah', N'United States', N'84010', N'2e6d7491-e0a8-4c79-98ce-bac61a07fb25', CAST(N'2006-10-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1102, N'603 Gellert Blvd', NULL, N'Daly City', N'California', N'United States', N'94015', N'a8dcad62-8678-458c-87eb-e2c2e550ff80', CAST(N'2005-12-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1103, N'2564 S. Redwood Rd.', NULL, N'Riverton', N'Utah', N'United States', N'84065', N'e299e96d-63cb-4acc-9bfd-5f0c23ae5820', CAST(N'2005-11-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1104, N'9927 N. Main St.', NULL, N'Tooele', N'Utah', N'United States', N'84074', N'ce0fa600-8761-402c-a6c0-84fb6244984b', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (1105, N'566 S. Main', NULL, N'Cedar City', N'Utah', N'United States', N'84720', N'c16f92ab-817f-42d1-a560-bc0f86fe2783', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (11380, N'165 North Main', NULL, N'Austin', N'Texas', N'United States', N'78701', N'412e3088-1fb8-4a1f-b3a8-abb23a4f01c1', CAST(N'2006-07-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (11381, N'2000 300th Street', NULL, N'Denver', N'Colorado', N'United States', N'80203', N'a9dbb460-a624-4e6a-aa22-311ee18f6746', CAST(N'2005-09-01T00:00:00.000' AS DateTime));
  INSERT `AdventureWorksLT`.`Address` (`AddressID`, `AddressLine1`, `AddressLine2`, `City`, `StateProvince`, `CountryRegion`, `PostalCode`, `rowguid`, `ModifiedDate`) VALUES (11382, N'99 Front Street', NULL, N'Minneapolis', N'Minnesota', N'United States', N'55402', N'878660a8-a9fe-4ef8-8d2d-53c614c6f042', CAST(N'2005-08-01T00:00:00.000' AS DateTime));
  
  