-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathduplicate-data-table.sql
315 lines (315 loc) · 27.5 KB
/
duplicate-data-table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
USE [TestDB]
GO
/****** Object: Table [dbo].[DuplicateData] Script Date: 6/1/2020 11:25:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DuplicateData](
[CustomerName] [varchar](255) NULL,
[Address] [varchar](255) NULL,
[City] [varchar](255) NULL,
[State] [varchar](50) NULL,
[Country] [varchar](100) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sed Tortor Incorporated', N'Ap #942-1613 Nunc St.', N'Zierikzee', N'Zl', N'American Samoa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nec LLC', N'Ap #388-1596 Phasellus Av.', N'Rockville', N'MD', N'Greece')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Arcu Consulting', N'2606 Fringilla Rd.', N'Orangeville', N'Ontario', N'Hong Kong')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non Enim Mauris Company', N'Ap #166-7609 Sagittis St.', N'Hamburg', N'Hamburg', N'Laos')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Euismod Mauris Institute', N'622-4804 Pharetra Road', N'Ligney', N'LU', N'South Africa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Suspendisse Eleifend LLC', N'642-8672 Ligula. Avenue', N'Tauranga', N'NI', N'Austria')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Egestas Incorporated', N'Ap #876-6397 Non, Avenue', N'Sydney', N'NSW', N'Laos')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Est LLP', N'331-3967 Pede Avenue', N'Torno', N'Lombardia', N'Finland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'A Incorporated', N'652-1281 Lobortis Road', N'Motueka', N'South Island', N'Liberia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ridiculus Mus Company', N'Ap #505-4543 Tristique Ave', N'Cusco', N'CUS', N'Mexico')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'In Associates', N'Ap #152-5734 Nisl Rd.', N'Whyalla', N'SA', N'Venezuela')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultricies Inc.', N'Ap #299-8779 Dolor. Av.', N'Bremerhaven', N'HB', N'Ireland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ut Consulting', N'P.O. Box 777, 1363 Sollicitudin Avenue', N'Frauenkirchen', N'Burgenland', N'San Marino')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Incorporated', N'8535 Aenean St.', N'Cabano', N'Quebec', N'Syria')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mauris Vestibulum Industries', N'727-7941 Nunc Av.', N'Patalillo', N'San José', N'Mongolia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Euismod Enim Etiam Incorporated', N'Ap #552-8582 Molestie Rd.', N'Ludhiana', N'PB', N'Tajikistan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Orci Ut Consulting', N'Ap #614-4926 Praesent Av.', N'Wodonga', N'VIC', N'Tanzania')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Fusce Institute', N'630-4696 Ante St.', N'Madrid', N'Madrid', N'Saint Vincent and The Grenadines')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lorem Lorem Institute', N'157-176 Ac, Ave', N'Jeongeup', N'Jeo', N'Niue')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Cum Sociis Incorporated', N'606-7022 Purus. Street', N'Beauvais', N'Picardie', N'Ukraine')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ornare Lectus Ante Inc.', N'321-9795 Morbi Rd.', N'Morinville', N'Alberta', N'Belgium')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Tincidunt Corp.', N'2274 Sem St.', N'Campomarino', N'Molise', N'Egypt')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'At Velit LLC', N'9229 Fusce St.', N'Kerikeri', N'NI', N'Virgin Islands, United States')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Facilisis Facilisis Inc.', N'P.O. Box 787, 9998 Mollis Avenue', N'Bauchi', N'Bauchi', N'New Caledonia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sociosqu Ad Litora Company', N'Ap #337-340 Consectetuer Road', N'Hervey Bay', N'QLD', N'Antarctica')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultricies Institute', N'Ap #288-9360 Tempor Rd.', N'Tehuacán', N'Pue', N'Cyprus')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Egestas LLC', N'Ap #576-7271 Sit Rd.', N'Massarosa', N'Toscana', N'French Guiana')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eu Arcu Morbi Inc.', N'P.O. Box 998, 9940 Tempus, St.', N'Ramsey', N'Huntingdonshire', N'South Africa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lobortis Augue Scelerisque Ltd', N'328-7998 Maecenas Ave', N'Bajaur Agency', N'FATA', N'Chad')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultricies Inc.', N'Ap #299-8779 Dolor. Av.', N'Bremerhaven', N'HB', N'Ireland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lacus Incorporated', N'P.O. Box 910, 2154 Adipiscing Rd.', N'Dehri', N'Bihar', N'Lebanon')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mattis Cras Eget Associates', N'201-9942 Et, Street', N'Medellín', N'Antioquia', N'Korea, North')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultrices Sit Amet Associates', N'P.O. Box 317, 1293 Orci, Av.', N'Tehuacán', N'Pue', N'Denmark')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Integer Industries', N'7905 Semper Rd.', N'Alingsås', N'O', N'Reunion')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Magnis Dis LLP', N'P.O. Box 984, 5498 Et, St.', N'Morrinsville', N'NI', N'Saint Barthélemy')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Duis Incorporated', N'Ap #307-5615 Tellus Street', N'Owen Sound', N'ON', N'Åland Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Habitant Morbi Tristique Consulting', N'Ap #477-8466 Eget St.', N'San Polo d''Enza', N'Emilia-Romagna', N'Botswana')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Et Industries', N'174-3575 Aliquam St.', N'Dublin', N'Leinster', N'Iceland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Fusce Limited', N'385-7867 Hendrerit Road', N'Waitakere', N'NI', N'Lithuania')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Quisque Ac Associates', N'P.O. Box 717, 4898 Sapien, Street', N'Huancayo', N'Junín', N'Bosnia and Herzegovina')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Etiam Vestibulum Inc.', N'Ap #995-6083 Cras Street', N'Midway', N'British Columbia', N'Anguilla')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Hendrerit Inc.', N'7418 Tortor, St.', N'Nizhny', N'NIZ', N'Cuba')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Amet Ante Vivamus Limited', N'346-6475 Quis Ave', N'Mildura', N'VIC', N'Saint Kitts and Nevis')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Euismod Enim Etiam Incorporated', N'Ap #552-8582 Molestie Rd.', N'Ludhiana', N'PB', N'Tajikistan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non LLC', N'624-3876 Nulla Road', N'Hulst', N'Zeeland', N'Bahamas')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Leo Elementum Sem LLC', N'P.O. Box 369, 155 Ut Rd.', N'Lleida', N'Catalunya', N'Burundi')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultricies Institute', N'Ap #288-9360 Tempor Rd.', N'Tehuacán', N'Pue', N'Cyprus')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Porttitor Eros Limited', N'Ap #884-7397 Nunc, St.', N'Södertälje', N'AB', N'Marshall Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Erat Etiam Vestibulum Company', N'Ap #274-1691 Egestas. Road', N'Istanbul', N'Ist', N'Micronesia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Quam Elementum Corp.', N'Ap #329-7952 Eu Avenue', N'Arviat', N'NU', N'Bolivia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Consulting', N'1683 Sollicitudin Rd.', N'Nîmes', N'LA', N'Israel')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sociosqu Ad Litora Ltd', N'216-9905 Dui. Street', N'Zaanstad', N'N.', N'Monaco')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ante Nunc LLC', N'Ap #282-6215 Et, Avenue', N'Abbotsford', N'BC', N'Thailand')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Porttitor Scelerisque Neque Institute', N'Ap #423-4187 Integer St.', N'Peñalolén', N'Metropolitana de Santiago', N'Fiji')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sed LLC', N'Ap #340-1258 Mauris Av.', N'Las Palmas', N'CN', N'Liberia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lobortis Tellus Industries', N'626-5281 Ut St.', N'Saint-Nazaire', N'Pays de la Loire', N'Wallis and Futuna')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sollicitudin Ltd', N'Ap #764-1269 Mus. Ave', N'Rampur', N'UP', N'Bouvet Island')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Inceptos Hymenaeos Mauris Limited', N'729-1523 Mi Ave', N'La Granja', N'RM', N'Jamaica')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Egestas Incorporated', N'Ap #876-6397 Non, Avenue', N'Sydney', N'NSW', N'Laos')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mauris Non LLP', N'Ap #786-2775 Tellus St.', N'Marseille', N'Provence-Alpes-Côte d''Azur', N'Bosnia and Herzegovina')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Risus Consulting', N'381-8371 Eget Street', N'Oklahoma City', N'OK', N'Mexico')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non Enim Mauris Company', N'Ap #166-7609 Sagittis St.', N'Hamburg', N'Hamburg', N'Laos')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Consectetuer Mauris Inc.', N'7824 Porta Avenue', N'Travo', N'ERM', N'Czech Republic')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Turpis LLC', N'Ap #348-5388 Nec Street', N'Pishin Valley', N'Balochistan', N'United Kingdom (Great Britain)')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nec Eleifend LLP', N'762-2446 Tortor. Av.', N'Whangarei', N'North Island', N'Colombia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'At Arcu Vestibulum Associates', N'833 Nam Street', N'Chartres', N'Centre', N'Iraq')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nec Malesuada Corporation', N'Ap #978-3583 Aliquam Rd.', N'Bertogne', N'LX', N'Cuba')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vehicula Risus Ltd', N'327-6408 Pretium Rd.', N'Voronezh', N'Voronezh Oblast', N'Macedonia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nulla Company', N'Ap #489-1664 Aliquet Rd.', N'Bhavnagar', N'GJ', N'Tonga')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nunc Lectus Company', N'Ap #835-2429 Lacus Rd.', N'Kediri', N'East Java', N'United States')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ut Consulting', N'P.O. Box 777, 1363 Sollicitudin Avenue', N'Frauenkirchen', N'Burgenland', N'San Marino')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Commodo Tincidunt Industries', N'4336 Eget Rd.', N'Isla de Pascua', N'V', N'Jersey')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Cum Sociis Corp.', N'8993 Elit, Road', N'Dijon', N'Bourgogne', N'Gibraltar')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sociosqu Ad Litora Company', N'Ap #337-340 Consectetuer Road', N'Hervey Bay', N'QLD', N'Antarctica')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vitae Semper Egestas LLP', N'3529 Ad St.', N'Bremen', N'HB', N'Austria')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ligula Consectetuer Rhoncus Company', N'886-1463 Eu Av.', N'Kirkby Lonsdale', N'WE', N'Russian Federation')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nibh Lacinia Orci Foundation', N'7013 Fusce Rd.', N'Te Puke', N'NI', N'Ukraine')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Hendrerit Inc.', N'7418 Tortor, St.', N'Nizhny', N'NIZ', N'Cuba')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'In Associates', N'Ap #152-5734 Nisl Rd.', N'Whyalla', N'SA', N'Venezuela')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'At Arcu Vestibulum Associates', N'833 Nam Street', N'Chartres', N'Centre', N'Iraq')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ornare Lectus Ante Inc.', N'321-9795 Morbi Rd.', N'Morinville', N'Alberta', N'Belgium')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Facilisis Inc.', N'5967 Ut Av.', N'Columbus', N'Georgia', N'Australia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nec Malesuada Associates', N'Ap #500-4056 Morbi Rd.', N'Frederick', N'Maryland', N'Ecuador')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eu Odio Institute', N'Ap #800-5526 Mollis St.', N'Jundiaí', N'SP', N'Switzerland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eu Foundation', N'8508 Ornare, Avenue', N'Buren', N'Gl', N'Sao Tome and Principe')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ipsum Inc.', N'Ap #916-408 Ad Road', N'Donosti', N'Euskadi', N'Bhutan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eget Institute', N'919 Feugiat Rd.', N'Berlin', N'BE', N'Iraq')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Fusce Institute', N'630-4696 Ante St.', N'Madrid', N'Madrid', N'Saint Vincent and The Grenadines')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Rutrum Associates', N'Ap #602-1795 Mus. St.', N'Istanbul', N'Istanbul', N'Andorra')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vivamus PC', N'P.O. Box 905, 138 Mi St.', N'Waiuku', N'NI', N'Pitcairn Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lorem Sit Consulting', N'Ap #266-1794 Lectus Rd.', N'Vienna', N'Wie', N'Oman')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non PC', N'674-294 Accumsan St.', N'Little Rock', N'AK', N'Andorra')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lectus Pede Consulting', N'Ap #815-5840 Non, Road', N'Acapulco', N'Gro', N'Italy')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'At Velit LLC', N'9229 Fusce St.', N'Kerikeri', N'NI', N'Virgin Islands, United States')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sed Limited', N'361-178 Euismod Street', N'Fusignano', N'Emilia-Romagna', N'Panama')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Pede Blandit Corp.', N'500-7064 Donec Ave', N'Barra do Corda', N'MA', N'South Georgia and The South Sandwich Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Euismod Mauris Institute', N'622-4804 Pharetra Road', N'Ligney', N'LU', N'South Africa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Porttitor Eros Limited', N'Ap #884-7397 Nunc, St.', N'Södertälje', N'AB', N'Marshall Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Integer Industries', N'7905 Semper Rd.', N'Alingsås', N'O', N'Reunion')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'A Incorporated', N'652-1281 Lobortis Road', N'Motueka', N'South Island', N'Liberia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ipsum Inc.', N'Ap #916-408 Ad Road', N'Donosti', N'Euskadi', N'Bhutan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lorem Ut LLC', N'P.O. Box 508, 5244 Sit Rd.', N'Alva', N'ST', N'Papua New Guinea')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ligula Institute', N'Ap #128-9921 Sit Rd.', N'Apartadó', N'ANT', N'Timor-Leste')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sed LLC', N'Ap #340-1258 Mauris Av.', N'Las Palmas', N'CN', N'Liberia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eu Foundation', N'8508 Ornare, Avenue', N'Buren', N'Gl', N'Sao Tome and Principe')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Sociosqu Ad Litora Ltd', N'216-9905 Dui. Street', N'Zaanstad', N'N.', N'Monaco')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Augue Malesuada Malesuada LLC', N'258-814 Libero. St.', N'Thines', N'Waals-Brabant', N'Mongolia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non LLC', N'624-3876 Nulla Road', N'Hulst', N'Zeeland', N'Bahamas')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Est LLP', N'331-3967 Pede Avenue', N'Torno', N'Lombardia', N'Finland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mattis Cras Eget Associates', N'201-9942 Et, Street', N'Medellín', N'Antioquia', N'Korea, North')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Phasellus Elit LLP', N'152-9433 Eleifend. Rd.', N'Diadema', N'São Paulo', N'Kyrgyzstan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non Cursus Inc.', N'402-6510 Nisi Av.', N'Tranås', N'Jönköpings län', N'South Africa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lorem Lorem Institute', N'157-176 Ac, Ave', N'Jeongeup', N'Jeo', N'Niue')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Egestas LLC', N'Ap #576-7271 Sit Rd.', N'Massarosa', N'Toscana', N'French Guiana')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vivamus PC', N'P.O. Box 905, 138 Mi St.', N'Waiuku', N'NI', N'Pitcairn Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nibh Lacinia Orci Foundation', N'7013 Fusce Rd.', N'Te Puke', N'NI', N'Ukraine')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Consulting', N'1683 Sollicitudin Rd.', N'Nîmes', N'LA', N'Israel')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mauris Vestibulum Industries', N'727-7941 Nunc Av.', N'Patalillo', N'San José', N'Mongolia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ipsum Dolor Sit Inc.', N'403-3386 Erat Rd.', N'Sluis', N'Zl', N'Pitcairn Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Fusce Limited', N'385-7867 Hendrerit Road', N'Waitakere', N'NI', N'Lithuania')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Amet Metus Aliquam Corporation', N'Ap #749-2673 Commodo St.', N'Cork', N'M', N'Guyana')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Leo Elementum Sem LLC', N'P.O. Box 369, 155 Ut Rd.', N'Lleida', N'Catalunya', N'Burundi')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Lobortis Tellus Industries', N'626-5281 Ut St.', N'Saint-Nazaire', N'Pays de la Loire', N'Wallis and Futuna')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vel Arcu Associates', N'543-3613 Augue St.', N'Vienna', N'Vienna', N'Guadeloupe')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Vel Arcu Associates', N'543-3613 Augue St.', N'Vienna', N'Vienna', N'Guadeloupe')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nec Malesuada Associates', N'Ap #500-4056 Morbi Rd.', N'Frederick', N'Maryland', N'Ecuador')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Fermentum Risus Corporation', N'670-5337 Vitae Avenue', N'Itagüí', N'ANT', N'Cocos (Keeling) Islands')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Tincidunt Corp.', N'2274 Sem St.', N'Campomarino', N'Molise', N'Egypt')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Mollis Vitae Posuere Associates', N'6100 Rhoncus. St.', N'Sukabumi', N'JB', N'Egypt')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ultrices Sit Amet Associates', N'P.O. Box 317, 1293 Orci, Av.', N'Tehuacán', N'Pue', N'Denmark')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Non Cursus Inc.', N'402-6510 Nisi Av.', N'Tranås', N'Jönköpings län', N'South Africa')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Eu Odio Institute', N'Ap #800-5526 Mollis St.', N'Jundiaí', N'SP', N'Switzerland')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Suspendisse Eleifend LLC', N'642-8672 Ligula. Avenue', N'Tauranga', N'NI', N'Austria')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Semper Nam Tempor Industries', N'211-506 Ut Road', N'Veere', N'Zeeland', N'Turkmenistan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ac Incorporated', N'8535 Aenean St.', N'Cabano', N'Quebec', N'Syria')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Amet Ante Vivamus Limited', N'346-6475 Quis Ave', N'Mildura', N'VIC', N'Saint Kitts and Nevis')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Inceptos Hymenaeos Mauris Limited', N'729-1523 Mi Ave', N'La Granja', N'RM', N'Jamaica')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'A Industries', N'P.O. Box 142, 3678 Porttitor Ave', N'Feilding', N'NI', N'Iraq')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Magnis Dis LLP', N'P.O. Box 984, 5498 Et, St.', N'Morrinsville', N'NI', N'Saint Barthélemy')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Turpis Aliquam Adipiscing Corp.', N'P.O. Box 760, 9369 Odio, Avenue', N'Patos', N'Paraíba', N'Uruguay')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Commodo Tincidunt Industries', N'4336 Eget Rd.', N'Isla de Pascua', N'V', N'Jersey')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Semper Nam Tempor Industries', N'211-506 Ut Road', N'Veere', N'Zeeland', N'Turkmenistan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ligula Institute', N'Ap #128-9921 Sit Rd.', N'Apartadó', N'ANT', N'Timor-Leste')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Nonummy Ipsum Ltd', N'P.O. Box 345, 1011 Aliquam, St.', N'Rionegro', N'ANT', N'Barbados')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Erat Eget Ipsum LLP', N'P.O. Box 962, 9947 Lorem Road', N'Berlin', N'Berlin', N'Korea, North')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Etiam Vestibulum Inc.', N'Ap #995-6083 Cras Street', N'Midway', N'British Columbia', N'Anguilla')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Phasellus Elit LLP', N'152-9433 Eleifend. Rd.', N'Diadema', N'São Paulo', N'Kyrgyzstan')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Erat Etiam Vestibulum Company', N'Ap #274-1691 Egestas. Road', N'Istanbul', N'Ist', N'Micronesia')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Ut Nulla Institute', N'P.O. Box 419, 8619 Nascetur Av.', N'Blitar', N'East Java', N'Trinidad and Tobago')
GO
INSERT [dbo].[DuplicateData] ([CustomerName], [Address], [City], [State], [Country]) VALUES (N'Diam At Pretium Limited', N'Ap #218-3031 Et Ave', N'Petit-Hallet', N'Luik', N'British Indian Ocean Territory')
GO