--CREATE the troubledtable
IF EXISTS (SELECT name from sysobjects where name = 'TroubledTable')
	DROP TABLE TroubledTable
	
CREATE TABLE TroubledTable (
	  FirstName VARCHAR(50)
	, LastName VARCHAR(50)
	, email VARCHAR(255)
)
--insert some test data
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Magee','Trujillo','lorem@Integermollis.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lamar','Kramer','natoque@risusat.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Emerson','Roman','cubilia@Namtempordiam.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nayda','Ellis','at.velit@nonummyut.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Clarke','Glass','elit.a.feugiat@Etiam.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Megan','Small','luctus@Sedauctor.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ruth','Ellis','Sed.eu@ante.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rhonda','Peck','urna@luctusCurabituregestas.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Kimberly','Ray','eget@malesuada.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Genevieve','Ross','tortor.Integer.aliquam@Donecfeugiat.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Aileen','Mccarthy','aliquam@Duiscursusdiam.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Teagan','Conway','lacinia.orci.consectetuer@nislelementumpurus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Tanek','Lott','tempor@a.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hedda','Hampton','scelerisque.scelerisque.dui@lobortis.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Salvador','Schultz','tempor.erat.neque@nonarcu.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Deborah','Paul','non.enim@esttemporbibendum.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Russell','Hood','urna@Aliquamnecenim.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Dustin','Hunter','nec.quam@diamdictumsapien.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ainsley','Sharpe','Pellentesque@Suspendissealiquet.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Arsenio','Dillon','sollicitudin.adipiscing@sedtortorInteger.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Simone','Howard','montes@nislMaecenasmalesuada.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Stacy','Kelly','ipsum.leo@ipsumCurabiturconsequat.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Regan','Ballard','mauris@Sedmalesuadaaugue.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Keely','Love','suscipit.est@arcuvelquam.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Paki','Peters','ac.facilisis@ipsum.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Anjolie','Burgess','ornare.lectus.ante@urnasuscipit.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Kylee','Burnett','metus.Vivamus.euismod@sapien.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Alden','Lewis','nec.mauris.blandit@Maecenas.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sloane','Sullivan','faucibus@antelectus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rachel','Collier','a.feugiat@quis.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Tucker','Hamilton','molestie.tortor.nibh@etultrices.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Mason','Stafford','vel.lectus.Cum@Sedpharetra.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Jerry','Wynn','velit.dui@utnullaCras.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Jillian','Underwood','risus@faucibus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hollee','Rodriquez','Aenean.gravida.nunc@Cum.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Melissa','Henderson','volutpat.ornare@id.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Mikayla','Huff','aliquam@facilisisfacilisis.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Florence','Bauer','elit.fermentum@etmagnaPraesent.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ariel','Curtis','scelerisque@accumsan.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cassady','Nolan','eu.metus@arcu.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Gil','Snider','convallis@ullamcorper.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Plato','Wheeler','Aliquam.ultrices.iaculis@magna.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Yael','Parsons','rutrum.Fusce.dolor@duiCraspellentesque.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Valentine','Browning','Vivamus@Curabiturconsequatlectus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Simone','Burton','facilisi@duinecurna.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Elijah','Mccarthy','arcu.et@Donecegestas.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Kirby','Curry','Quisque@imperdietnecleo.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Shafira','Bowers','aliquet@ornare.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Yasir','Ferguson','elementum.lorem.ut@Integervulputate.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Harrison','Brewer','vel@dignissimpharetraNam.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cooper','Santiago','luctus.aliquet.odio@sit.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Willa','Simpson','lacinia.mattis.Integer@Nuncsollicitudincommodo.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Brittany','Gallegos','Sed.nunc@posuereat.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Addison','Butler','eu.turpis.Nulla@tincidunt.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Thor','Acosta','non.lorem.vitae@pedePraesenteu.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sheila','Koch','ornare@famesac.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Elmo','Alford','facilisis@venenatis.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Vernon','Stevenson','leo.Vivamus@quis.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cyrus','Ramirez','sapien.Aenean@Maurisvelturpis.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lacy','Sherman','magna@eratVivamus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Noelle','Hood','sed.tortor.Integer@Quisquepurus.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ralph','Morrison','quis.arcu.vel@facilisisnon.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Katelyn','Suarez','auctor.nunc.nulla@lectusa.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hamish','Mcmahon','nibh@ornarefacilisis.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Richard','Oneil','at.nisi@non.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lareina','Hooper','risus.Morbi.metus@erat.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lisandra','Garrett','sit.amet.ante@ante.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('September','Caldwell','lacus.Mauris.non@accumsannequeet.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Chastity','Dean','auctor.velit@ullamcorpermagnaSed.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Amela','Lloyd','metus@Morbinequetellus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ariel','Sullivan','sit@tristique.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ila','Kennedy','torquent.per.conubia@inconsequat.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Griffin','Gomez','eget.nisi@aliquetvel.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Joseph','Fisher','Sed@Naminterdumenim.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Roary','Benton','Nulla@aliquetvelvulputate.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Carla','Walton','hendrerit.consectetuer@imperdietullamcorper.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Aretha','Howard','vestibulum@leoMorbineque.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hall','Carter','nunc.sit@interdumligula.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Donna','Norman','Integer.tincidunt@ullamcorpervelitin.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nadine','Stephens','et.malesuada@loremutaliquam.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Dean','Skinner','Duis@aliquet.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Beck','Mcguire','aliquam.enim.nec@Classaptenttaciti.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Chastity','Singleton','elementum.dui.quis@facilisiseget.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Devin','Anthony','dui.Fusce@elitAliquamauctor.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nichole','Sears','eu@ridiculusmusProin.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Yeo','Cantu','magna@velpedeblandit.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Joan','Young','nec.quam.Curabitur@consectetuermaurisid.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hakeem','Watts','dolor.dolor.tempus@sodalesMaurisblandit.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sigourney','Castaneda','cursus.vestibulum@velvenenatisvel.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Melissa','Carver','quis.pede.Praesent@vitae.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ali','Levine','at@Donecest.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hammett','Rios','nulla@laoreetposuereenim.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nasim','Chambers','sed.libero.Proin@quis.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Eric','Yates','et.libero@libero.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Irma','Cross','tempus@ligulaelitpretium.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Drake','Pennington','neque@luctusfelis.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cody','Kelly','amet.luctus.vulputate@facilisislorem.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Xaviera','Callahan','ornare.In@mauris.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Duncan','Medina','nulla.In.tincidunt@sodalesMaurisblandit.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lana','Pruitt','morbi@risusMorbi.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Wanda','Slater','vitae.purus.gravida@estNunc.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Zephr','Ingram','Sed.et@odiosemper.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ori','Estes','Ut.nec@Aeneangravidanunc.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Noble','Kaufman','Duis.ac.arcu@risus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nash','Huber','non.lacinia@nibh.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Martena','Decker','Praesent.eu.dui@tristiqueaceleifend.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Emery','Horne','Quisque.tincidunt.pede@Aeneangravidanunc.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Linda','Morris','nec.diam.Duis@Aliquam.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Gregory','Rojas','aliquam.eu.accumsan@vitae.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Kevin','Stone','felis.Nulla@lacinia.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Riley','Pearson','enim.Nunc@adipiscing.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Stewart','Mcneil','nibh@lacus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hashim','Miller','vulputate.dui@Donecegestas.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Maya','Horton','turpis.Aliquam@adipiscing.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Indigo','George','Duis@ornare.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Clayton','Webb','tincidunt.aliquam@nonlacinia.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rose','Mayo','adipiscing.lobortis@in.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Macon','Scott','tincidunt.tempus.risus@sociosqu.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lewis','Drake','dolor.Quisque.tincidunt@nonummyipsum.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Mannix','Reilly','sagittis.augue@Fuscealiquetmagna.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Doris','Patterson','eget.metus@varius.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Jolene','Macias','egestas@adipiscinglacus.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Maxine','Espinoza','lorem.luctus.ut@cubiliaCurae;.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Blythe','Schwartz','velit.egestas@aenim.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Emily','Curry','Donec.porttitor@Loremipsumdolor.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cody','Sanders','in.aliquet.lobortis@turpisAliquam.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Pearl','Crane','tincidunt@orciPhasellus.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Abra','Romero','eget.odio.Aliquam@enimnec.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Claudia','Melendez','lorem.vehicula@duiFuscediam.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Piper','Walter','libero.Proin.mi@pellentesquemassalobortis.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Brendan','Terrell','eros.Proin@Curabitur.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Leilani','Porter','ligula.eu.enim@senectuset.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cailin','Fuller','Pellentesque.ultricies@lacusUtnec.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Quamar','Whitaker','magnis.dis.parturient@lacusvestibulumlorem.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Maxine','Greer','Donec@sapien.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Grant','Franklin','feugiat.non.lobortis@ipsum.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lacy','Norton','neque@elitelitfermentum.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Valentine','Sargent','Nulla.eu.neque@lacuspedesagittis.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Mona','Knight','arcu.eu.odio@fringillacursuspurus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Britanni','Keith','tempor.est.ac@venenatislacusEtiam.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Selma','Joyce','justo.faucibus.lectus@fermentum.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cameron','Ball','Aliquam@enimnonnisi.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Maite','Velazquez','nec.diam.Duis@magnaa.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Eugenia','Long','orci.in.consequat@dolor.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Samson','Castillo','vestibulum.lorem@sodalesat.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rhonda','Matthews','fermentum@auctorquis.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Jade','Hudson','odio.Nam.interdum@fringillami.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rose','Juarez','vitae@mi.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Ann','Forbes','lorem.eget@etmalesuada.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Benjamin','Conway','consequat.lectus@utipsumac.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hakeem','Coleman','eget.varius.ultrices@Utsemper.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Alan','Knight','lorem@rutrumloremac.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Akeem','Carson','a.odio@interdumlibero.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Thomas','Sims','Curabitur.sed@Suspendisse.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rose','Whitney','Nulla.interdum.Curabitur@Etiam.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Remedios','Griffin','Cras.vulputate.velit@Curae;Phasellusornare.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sonya','Mccoy','lorem.eget@metussitamet.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Charity','Burton','nibh.Quisque.nonummy@odiovelest.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Aladdin','Mccoy','lorem@nuncinterdum.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nina','Hicks','Fusce@semelitpharetra.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Mechelle','Conner','mus.Proin.vel@anteNuncmauris.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Karly','Patrick','nibh.lacinia@sitametornare.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rina','Powers','felis.eget.varius@accumsan.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Suki','Navarro','sapien.cursus.in@Nam.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sonia','Nunez','mus.Proin@molestiedapibusligula.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Matthew','Wells','Maecenas.libero@afeugiattellus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Judah','Byers','nec.tellus.Nunc@magnaetipsum.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Chava','Hull','et.malesuada.fames@ipsum.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Christopher','Colon','senectus.et.netus@idmollisnec.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Paloma','Lang','Mauris.eu@arcuVivamus.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cailin','Velazquez','Cum.sociis@ut.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Uma','Newton','dui@amet.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Daquan','Glenn','ut.odio.vel@dignissimtempor.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hilary','Patrick','nec@Curae;.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Nichole','Sellers','senectus@sagittisplaceratCras.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Robert','Moore','et.ultrices@magnis.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Illiana','Harrell','orci@morbitristiquesenectus.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Dominique','Herrera','magna.nec@semper.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Geraldine','Hopkins','mauris.aliquam@tellus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Alexandra','Woodard','lorem.ut@metusIn.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Vance','Goodwin','metus.Vivamus@lectusquismassa.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Jerry','Evans','auctor@acmetusvitae.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Rogan','Hubbard','eu@magnaPraesentinterdum.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Carol','Barr','in@amet.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Matthew','Goff','ante.Nunc@adipiscingelitCurabitur.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Isadora','Holden','tincidunt.nunc.ac@Aeneanegetmetus.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Hedwig','Sexton','molestie@montes.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Celeste','Vargas','ligula.consectetuer@euismodestarcu.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Zahir','Dale','quis.pede@erosturpis.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Devin','Castillo','Ut@Sedeu.org');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Emerald','Cox','Nulla@Sed.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Finn','Pittman','luctus@cursuspurus.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Lucas','Marks','tincidunt.orci@ornarelectusante.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Gay','Blevins','non.justo@aliquet.com');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Sade','Potts','consequat.dolor.vitae@dictumplacerataugue.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Yolanda','Mosley','arcu.Morbi.sit@Morbineque.ca');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Alexandra','Shannon','Cras.dolor@consectetueradipiscing.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Cedric','Vincent','magnis.dis@mattis.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Darryl','Lopez','Fusce.aliquet@aliquet.edu');
INSERT INTO TroubledTable (FirstName,LastName,email) VALUES ('Constance','Morton','vel@arcu.org');


--create our duplicate data
INSERT INTO TroubledTable
SELECT * FROM TroubledTable WHERE lastname LIKE '[a-l]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[a-l]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[a-l]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[m-z]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[m-z]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[m-z]%' 
UNION ALL
SELECT * FROM TroubledTable WHERE lastname LIKE '[m-z]%' 

--set a backup copy (so we can "restore" a backup quickly)
IF EXISTS (SELECT name from sysobjects where name = 'OriginalTroubledTable')
	DROP TABLE OriginalTroubledTable
	
SELECT * INTO OriginalTroubledTable FROM troubledtable