-- declare variables
declare @tempuserinfo table ( username varchar(255) not null );
declare @tempusernames table ( id int not null identity(0,1), username varchar(255) not null );
declare @tempemails table ( id int not null identity(0,1), email varchar(255) not null );
declare @missing table ( UserNameMissing varchar(255) not null, EmailMissing varchar(255) not null );
declare @missingbutexisting table ( username varchar(255) not null, email varchar(255) not null, userid int not null, parentuser varchar(255) not null );

declare @NTotalUsers int; declare @NExpectedFromImport int; declare @NExpectedEmailsFromImport int; declare @NActualFromImport int;

-- put import file data into temp tables
insert into @tempuserinfo select username from userinfo where parentuser = 'mainerealestate' and username in ('aaron@tmren.biz','acarver@tmren.biz','aimeetonneson@tmren.biz','alexamerrill@tmren.biz','allisonp@tmren.biz','alyssa@tmren.biz','amy@tmren.biz','amyarata@tmren.biz','amycross@tmren.biz','amysylvestre@tmren.biz','andrea@tmren.biz','andrewhanscom@tmren.biz','angelcole@tmren.biz','annemarie@tmren.biz','annie@tmren.biz','april@tmren.biz','aprilb@tmren.biz','athurston@tmren.biz','auburnadmin@tmren.biz','autumn@tmren.biz','awadsworth@tmren.biz','bangoradmin@tmren.biz','barbara.deschenes@tmren.biz','barbarat@tmren.biz','barbieperkins@tmren.biz','bbabirak@tmren.biz','beckydoughty@tmren.biz','ben@tmren.biz','benharvey@tmren.biz','bettyn@tmren.biz','billp@tmren.biz','billreilly@tmren.biz','billt@tmren.biz','blocke@tmren.biz','bmason@tmren.biz','bob@tmren.biz','bobmagazu@tmren.biz','bpike@tmren.biz','bradp@tmren.biz','brandon@tmren.biz','brenda@tmren.biz','brendab@tmren.biz','brendajames@tmren.biz','brianm@tmren.biz','brianw@tmren.biz','brichard@tmren.biz','bsessions@tmren.biz','budfarwell@tmren.biz','budstoddard@tmren.biz','bweeks@tmren.biz','camille@tmren.biz','carolchaffee@tmren.biz','carolfox@tmren.biz','carolpapale@tmren.biz','carolyn@tmren.biz','carrie@tmren.biz','carriew@tmren.biz','casey@tmren.biz','cassie@tmren.biz','cathyc@tmren.biz','celina@tmren.biz','cfox@tmren.biz','cfullerton@tmren.biz','cgoyet@tmren.biz','chad@tmren.biz','charlesgrover@tmren.biz','charlyb@tmren.biz','chase@tmren.biz','chawes@tmren.biz','chelsea@tmren.biz','cherylh@tmren.biz','cherylw@tmren.biz','chinckley@tmren.biz','chris@tmren.biz','chrisalbert@tmren.biz','chrisalmasi@tmren.biz','chrisolsen@tmren.biz','christinapierce@tmren.biz','christopherl@tmren.biz','christya@tmren.biz','cindyd@tmren.biz','cmac@tmren.biz','cnichols@tmren.biz','codys@tmren.biz','cookie@tmren.biz','cortnie@tmren.biz','corya@tmren.biz','cpoulin@tmren.biz','craigd@tmren.biz','craigg@tmren.biz','creynolds@tmren.biz','cthorpe@tmren.biz','cturnbull@tmren.biz','curtis@tmren.biz','cwarren@tmren.biz','cwhalen@tmren.biz','cynthiat@tmren.biz','czegouros@tmren.biz','dackerson@tmren.biz','dandowns@tmren.biz','daniell@tmren.biz','danmclellan@tmren.biz','dansellsmaine@tmren.biz','daurice@tmren.biz','davidbuchstaber@tmren.biz','daviddeschaine@tmren.biz','davidford@tmren.biz','davidkane@tmren.biz','davidkitchen@tmren.biz','davidpaul@tmren.biz','davidr@tmren.biz','davidsumner@tmren.biz','dblahusch@tmren.biz','dbond@tmren.biz','dbuffum@tmren.biz','dcoleman@tmren.biz','dcourtney@tmren.biz','dcrafts@tmren.biz','deb@tmren.biz','debbiesanborn@tmren.biz','debi@tmren.biz','debra@tmren.biz','debrah@tmren.biz','debrosa@tmren.biz','debsileo@tmren.biz','denisev@tmren.biz','derek@tmren.biz','derektheriault@tmren.biz','desiree@tmren.biz','dgagne@tmren.biz','dgelinas@tmren.biz','dianecote@tmren.biz','dianeg@tmren.biz','dianneh@tmren.biz','djabar@tmren.biz','djackson@tmren.biz','djenkins@tmren.biz','dlegassie@tmren.biz','don@tmren.biz','donaldp@tmren.biz','donnag@tmren.biz','donnapinkham@tmren.biz','donruss@tmren.biz','dougbond@tmren.biz','dpenney@tmren.biz','dpilon@tmren.biz','dstults@tmren.biz','edh@tmren.biz','edsharpe@tmren.biz','edwardrichard@tmren.biz','egarrison@tmren.biz','eleanorf@tmren.biz','elibby@tmren.biz','elizabethbanwell@tmren.biz','elizabethsanford@tmren.biz','epratte@tmren.biz','eric@tmren.biz','ericka@tmren.biz','ernest@tmren.biz','evas@tmren.biz','ewhitehouse@tmren.biz','faye@tmren.biz','francesca@tmren.biz','gail@tmren.biz','gailkolda@tmren.biz','garyw@tmren.biz','gena@tmren.biz','gerardl@tmren.biz','gina@tmren.biz','glennd@tmren.biz','glenngarry@tmren.biz','glenp@tmren.biz','gmaclean@tmren.biz','gray@tmren.biz','gregroy@tmren.biz','gregsouza@tmren.biz','gretchenb@tmren.biz','hbuda@tmren.biz','hciampi@tmren.biz','heatherk@tmren.biz','heidiyoung@tmren.biz','helenfox@tmren.biz','hharrison@tmren.biz','hilarygotlieb@tmren.biz','holly@tmren.biz','hollyadkins@tmren.biz','hollyb@tmren.biz','idaearle@tmren.biz','jacquelineguido@tmren.biz','jaimec@tmren.biz','jakewight@tmren.biz','jamescalifano@tmren.biz','jami@tmren.biz','jamief@tmren.biz','jandwinal@tmren.biz','janef@tmren.biz','janemaine@tmren.biz','janice@tmren.biz','janicejannetty@tmren.biz','jansmith@tmren.biz','jarrodmallon@tmren.biz','jasonb@tmren.biz','jasonbecvar@tmren.biz','jbasinet@tmren.biz','jcat@tmren.biz','jdarling@tmren.biz','jdouglass@tmren.biz','jdye@tmren.biz','jeannette@tmren.biz','jeff@tmren.biz','jeffclark@tmren.biz','jeffcyr@tmren.biz','jenivangilder@tmren.biz','jenna@tmren.biz','jennifer@tmren.biz','jenniferdowdy@tmren.biz','jennifermorin@tmren.biz','jenniferv@tmren.biz','jeremyhanken@tmren.biz','jerryprice@tmren.biz','jfruzia@tmren.biz','jginter@tmren.biz','jgrover@tmren.biz','jguy@tmren.biz','jhammond@tmren.biz','jhancock@tmren.biz','jillian@tmren.biz','jillwatson@tmren.biz','jimk@tmren.biz','jimknight@tmren.biz','jimmyliang@tmren.biz','jimw@tmren.biz','jkarchov@tmren.biz','jkeenan@tmren.biz','jnadeau@tmren.biz','jnutting@tmren.biz','joannew@tmren.biz','joef@tmren.biz','joejordan@tmren.biz','joes@tmren.biz','joetrask@tmren.biz','joeyc@tmren.biz','johncarroll@tmren.biz','johnh@tmren.biz','johnlawrence@tmren.biz','johnmarquis@tmren.biz','joshp@tmren.biz','joshuaj@tmren.biz','jperron@tmren.biz','jryan@tmren.biz','jtomazin@tmren.biz','judyreeves@tmren.biz','juliaw@tmren.biz','juliecourt@tmren.biz','julietmorrison@tmren.biz','justinjohnson@tmren.biz','kaitlyn@tmren.biz','kara@tmren.biz','karenh@tmren.biz','karenstpeter@tmren.biz','katecaron@tmren.biz','kathleen@tmren.biz','kathleenm@tmren.biz','kathleens@tmren.biz','kathrynlevesque@tmren.biz','katiey@tmren.biz','katrina@tmren.biz','katy@tmren.biz','kclark@tmren.biz','kdavis@tmren.biz','keith@tmren.biz','keithnicely@tmren.biz','kellyellis@tmren.biz','kellyp@tmren.biz','kellys@tmren.biz','kellystump@tmren.biz','kenl@tmren.biz','kennyjacques@tmren.biz','keren@tmren.biz','kevin@tmren.biz','kevinc@tmren.biz','kfowler@tmren.biz','kgannon@tmren.biz','khight@tmren.biz','kianakane@tmren.biz','kim@tmren.biz','kimberly@tmren.biz','kimchilds@tmren.biz','kirk@tmren.biz','kkendrick@tmren.biz','kristen@tmren.biz','kristenb@tmren.biz','kristenw@tmren.biz','larryc@tmren.biz','lauradavis@tmren.biz','laurelf@tmren.biz','laurieb@tmren.biz','lbowie@tmren.biz','lchampagne@tmren.biz','lcote@tmren.biz','leeboutwell@tmren.biz','lenny@tmren.biz','les@tmren.biz','lesser@tmren.biz','lindababbitt@tmren.biz','lindsay@tmren.biz','lisac@tmren.biz','lisalibby@tmren.biz','lisavilla@tmren.biz','lizd@tmren.biz','llabauve@tmren.biz','lmorrison@tmren.biz','loni@tmren.biz','lonig@tmren.biz','loristonge@tmren.biz','louc@tmren.biz','ltaylor@tmren.biz','lucyr@tmren.biz','lvetterline@tmren.biz','lynnoleary@tmren.biz','lynnw@tmren.biz','maddie@tmren.biz','maie@tmren.biz','mandy@tmren.biz','marcello@tmren.biz','marcy@tmren.biz','mariah@tmren.biz','marieb@tmren.biz','mariesullivan@tmren.biz','marketing@tmren.biz','markf@tmren.biz','markl@tmren.biz','markm@tmren.biz','markmc@tmren.biz','markmoody@tmren.biz','martynorton@tmren.biz','matthew@tmren.biz','mattl@tmren.biz','mattparks@tmren.biz','maudewright@tmren.biz','mbrown@tmren.biz','mcook@tmren.biz','mcookson@tmren.biz','meganc@tmren.biz','melanie@tmren.biz','melindatorrens@tmren.biz','meredith@tmren.biz','meredithdunn@tmren.biz','michaeldubois@tmren.biz','michaelhamilton@tmren.biz','michaeljepson@tmren.biz','michaelm@tmren.biz','michaelmcmanus@tmren.biz','michaelurban@tmren.biz','michellec@tmren.biz','michellef@tmren.biz','michellesweet@tmren.biz','mike@tmren.biz','mikeb@tmren.biz','mikejlane@tmren.biz','mikeq@tmren.biz','milos@tmren.biz','mindyh@tmren.biz','mindysanderson@tmren.biz','mkerry@tmren.biz','mlawsure@tmren.biz','mmcaleney@tmren.biz','mmichaud@tmren.biz','monet@tmren.biz','moniquesanders@tmren.biz','moxi-auburn@tmren.biz','moxi-falmouth@tmren.biz','moxi-southportland@tmren.biz','mrich@tmren.biz','mrogers@tmren.biz','mrs@tmren.biz','msiggy@tmren.biz','mtapley@tmren.biz','nancyb@tmren.biz','nasali@tmren.biz','nathan@tmren.biz','nbartlett@tmren.biz','nbrown@tmren.biz','nicole@tmren.biz','normp@tmren.biz','nsaucier@tmren.biz','oreilly@tmren.biz','pam@tmren.biz','patcribby@tmren.biz','patricia@tmren.biz','pattyvigue@tmren.biz','paularm@tmren.biz','paulcurrier@tmren.biz','paulh@tmren.biz','peter@tmren.biz','peteri@tmren.biz','petersawyer@tmren.biz','pfelker@tmren.biz','phatem@tmren.biz','pmcleod@tmren.biz','pnicely@tmren.biz','prowe@tmren.biz','psmith@tmren.biz','pstewart@tmren.biz','qminhle@tmren.biz','randiburnell@tmren.biz','raylene@tmren.biz','rbouffard@tmren.biz','rebeccathomen@tmren.biz','rhaskell@tmren.biz','rhondakenney@tmren.biz','richardc@tmren.biz','rickm@tmren.biz','rob@tmren.biz','ronb@tmren.biz','ronh@tmren.biz','rosemary@tmren.biz','rtompkins@tmren.biz','russell@tmren.biz','rustymeggison@tmren.biz','sabine@tmren.biz','sallyh@tmren.biz','sandi@tmren.biz','sandralegere@tmren.biz','sandramonzo@tmren.biz','sandraphillips@tmren.biz','sandrasherry@tmren.biz','sandy@tmren.biz','sandyb@tmren.biz','sandycross@tmren.biz','sarab@tmren.biz','sarah@tmren.biz','sarareynolds@tmren.biz','sarsenault@tmren.biz','sbilodeau@tmren.biz','schenker@tmren.biz','scottmorgan@tmren.biz','scottvogell@tmren.biz','scroteau@tmren.biz','sdrew@tmren.biz','serickson@tmren.biz','sgreen@tmren.biz','shammond@tmren.biz','shannonstevens@tmren.biz','shelley@tmren.biz','shellp@tmren.biz','sierraallen@tmren.biz','sjclauson@tmren.biz','smerrill@tmren.biz','smetzger@tmren.biz','sonja@tmren.biz','spetersen@tmren.biz','splourde@tmren.biz','ssmith@tmren.biz','ssnow@tmren.biz','stacycolbybarnes@tmren.biz','stalbot@tmren.biz','stanley@tmren.biz','statie@tmren.biz','stephanielynn@tmren.biz','stevemiller@tmren.biz','stevemorgan@tmren.biz','stevet@tmren.biz','stevew@tmren.biz','suef@tmren.biz','sueliebling@tmren.biz','suem@tmren.biz','suepoirier@tmren.biz','susanporell@tmren.biz','sydneyharrison@tmren.biz','talexander@tmren.biz','tamib@tmren.biz','tammyb@tmren.biz','tammym@tmren.biz','tanyab@tmren.biz','tanyacrawford@tmren.biz','tboudreau@tmren.biz','tdurepo@tmren.biz','ted@tmren.biz','teresamorse@tmren.biz','terril@tmren.biz','tesskeeran@tmren.biz','tgreeley@tmren.biz','tim@tmren.biz','tmangino@tmren.biz','tmorra@tmren.biz','tom@tmren.biz','tomtrask@tmren.biz','tori@tmren.biz','travish@tmren.biz','trish@tmren.biz','trusso@tmren.biz','tux@tmren.biz','tynekenny@tmren.biz','ubenoit@tmren.biz','vaida@tmren.biz','vaughn@tmren.biz','vicki@tmren.biz','vickieshane@tmren.biz','vinniematson@tmren.biz','wendylebel@tmren.biz','willleary@tmren.biz','willplummer@tmren.biz','wnelsen@tmren.biz','wshafter@tmren.biz','x4o0','x71t','xab4','yolanda@tmren.biz','yvonne@tmren.biz','zacharyhanson@tmren.biz','zcreps@tmren.biz');
insert into @tempusernames values ('aaron@tmren.biz'),('acarver@tmren.biz'),('aimeetonneson@tmren.biz'),('alexamerrill@tmren.biz'),('allisonp@tmren.biz'),('alyssa@tmren.biz'),('amy@tmren.biz'),('amyarata@tmren.biz'),('amycross@tmren.biz'),('amysylvestre@tmren.biz'),('andrea@tmren.biz'),('andrewhanscom@tmren.biz'),('angelcole@tmren.biz'),('annemarie@tmren.biz'),('annie@tmren.biz'),('april@tmren.biz'),('aprilb@tmren.biz'),('athurston@tmren.biz'),('auburnadmin@tmren.biz'),('autumn@tmren.biz'),('awadsworth@tmren.biz'),('bangoradmin@tmren.biz'),('barbara.deschenes@tmren.biz'),('barbarat@tmren.biz'),('barbieperkins@tmren.biz'),('bbabirak@tmren.biz'),('beckydoughty@tmren.biz'),('ben@tmren.biz'),('benharvey@tmren.biz'),('bettyn@tmren.biz'),('billp@tmren.biz'),('billreilly@tmren.biz'),('billt@tmren.biz'),('blocke@tmren.biz'),('bmason@tmren.biz'),('bob@tmren.biz'),('bobmagazu@tmren.biz'),('bpike@tmren.biz'),('bradp@tmren.biz'),('brandon@tmren.biz'),('brenda@tmren.biz'),('brendab@tmren.biz'),('brendajames@tmren.biz'),('brianm@tmren.biz'),('brianw@tmren.biz'),('brichard@tmren.biz'),('bsessions@tmren.biz'),('budfarwell@tmren.biz'),('budstoddard@tmren.biz'),('bweeks@tmren.biz'),('camille@tmren.biz'),('carolchaffee@tmren.biz'),('carolfox@tmren.biz'),('carolpapale@tmren.biz'),('carolyn@tmren.biz'),('carrie@tmren.biz'),('carriew@tmren.biz'),('casey@tmren.biz'),('cassie@tmren.biz'),('cathyc@tmren.biz'),('celina@tmren.biz'),('cfox@tmren.biz'),('cfullerton@tmren.biz'),('cgoyet@tmren.biz'),('chad@tmren.biz'),('charlesgrover@tmren.biz'),('charlyb@tmren.biz'),('chase@tmren.biz'),('chawes@tmren.biz'),('chelsea@tmren.biz'),('cherylh@tmren.biz'),('cherylw@tmren.biz'),('chinckley@tmren.biz'),('chris@tmren.biz'),('chrisalbert@tmren.biz'),('chrisalmasi@tmren.biz'),('chrisolsen@tmren.biz'),('christinapierce@tmren.biz'),('christopherl@tmren.biz'),('christya@tmren.biz'),('cindyd@tmren.biz'),('cmac@tmren.biz'),('cnichols@tmren.biz'),('codys@tmren.biz'),('cookie@tmren.biz'),('cortnie@tmren.biz'),('corya@tmren.biz'),('cpoulin@tmren.biz'),('craigd@tmren.biz'),('craigg@tmren.biz'),('creynolds@tmren.biz'),('cthorpe@tmren.biz'),('cturnbull@tmren.biz'),('curtis@tmren.biz'),('cwarren@tmren.biz'),('cwhalen@tmren.biz'),('cynthiat@tmren.biz'),('czegouros@tmren.biz'),('dackerson@tmren.biz'),('dandowns@tmren.biz'),('daniell@tmren.biz'),('danmclellan@tmren.biz'),('dansellsmaine@tmren.biz'),('daurice@tmren.biz'),('davidbuchstaber@tmren.biz'),('daviddeschaine@tmren.biz'),('davidford@tmren.biz'),('davidkane@tmren.biz'),('davidkitchen@tmren.biz'),('davidpaul@tmren.biz'),('davidr@tmren.biz'),('davidsumner@tmren.biz'),('dblahusch@tmren.biz'),('dbond@tmren.biz'),('dbuffum@tmren.biz'),('dcoleman@tmren.biz'),('dcourtney@tmren.biz'),('dcrafts@tmren.biz'),('deb@tmren.biz'),('debbiesanborn@tmren.biz'),('debi@tmren.biz'),('debra@tmren.biz'),('debrah@tmren.biz'),('debrosa@tmren.biz'),('debsileo@tmren.biz'),('denisev@tmren.biz'),('derek@tmren.biz'),('derektheriault@tmren.biz'),('desiree@tmren.biz'),('dgagne@tmren.biz'),('dgelinas@tmren.biz'),('dianecote@tmren.biz'),('dianeg@tmren.biz'),('dianneh@tmren.biz'),('djabar@tmren.biz'),('djackson@tmren.biz'),('djenkins@tmren.biz'),('dlegassie@tmren.biz'),('don@tmren.biz'),('donaldp@tmren.biz'),('donnag@tmren.biz'),('donnapinkham@tmren.biz'),('donruss@tmren.biz'),('dougbond@tmren.biz'),('dpenney@tmren.biz'),('dpilon@tmren.biz'),('dstults@tmren.biz'),('edh@tmren.biz'),('edsharpe@tmren.biz'),('edwardrichard@tmren.biz'),('egarrison@tmren.biz'),('eleanorf@tmren.biz'),('elibby@tmren.biz'),('elizabethbanwell@tmren.biz'),('elizabethsanford@tmren.biz'),('epratte@tmren.biz'),('eric@tmren.biz'),('ericka@tmren.biz'),('ernest@tmren.biz'),('evas@tmren.biz'),('ewhitehouse@tmren.biz'),('faye@tmren.biz'),('francesca@tmren.biz'),('gail@tmren.biz'),('gailkolda@tmren.biz'),('garyw@tmren.biz'),('gena@tmren.biz'),('gerardl@tmren.biz'),('gina@tmren.biz'),('glennd@tmren.biz'),('glenngarry@tmren.biz'),('glenp@tmren.biz'),('gmaclean@tmren.biz'),('gray@tmren.biz'),('gregroy@tmren.biz'),('gregsouza@tmren.biz'),('gretchenb@tmren.biz'),('hbuda@tmren.biz'),('hciampi@tmren.biz'),('heatherk@tmren.biz'),('heidiyoung@tmren.biz'),('helenfox@tmren.biz'),('hharrison@tmren.biz'),('hilarygotlieb@tmren.biz'),('holly@tmren.biz'),('hollyadkins@tmren.biz'),('hollyb@tmren.biz'),('idaearle@tmren.biz'),('jacquelineguido@tmren.biz'),('jaimec@tmren.biz'),('jakewight@tmren.biz'),('jamescalifano@tmren.biz'),('jami@tmren.biz'),('jamief@tmren.biz'),('jandwinal@tmren.biz'),('janef@tmren.biz'),('janemaine@tmren.biz'),('janice@tmren.biz'),('janicejannetty@tmren.biz'),('jansmith@tmren.biz'),('jarrodmallon@tmren.biz'),('jasonb@tmren.biz'),('jasonbecvar@tmren.biz'),('jbasinet@tmren.biz'),('jcat@tmren.biz'),('jdarling@tmren.biz'),('jdouglass@tmren.biz'),('jdye@tmren.biz'),('jeannette@tmren.biz'),('jeff@tmren.biz'),('jeffclark@tmren.biz'),('jeffcyr@tmren.biz'),('jenivangilder@tmren.biz'),('jenna@tmren.biz'),('jennifer@tmren.biz'),('jenniferdowdy@tmren.biz'),('jennifermorin@tmren.biz'),('jenniferv@tmren.biz'),('jeremyhanken@tmren.biz'),('jerryprice@tmren.biz'),('jfruzia@tmren.biz'),('jginter@tmren.biz'),('jgrover@tmren.biz'),('jguy@tmren.biz'),('jhammond@tmren.biz'),('jhancock@tmren.biz'),('jillian@tmren.biz'),('jillwatson@tmren.biz'),('jimk@tmren.biz'),('jimknight@tmren.biz'),('jimmyliang@tmren.biz'),('jimw@tmren.biz'),('jkarchov@tmren.biz'),('jkeenan@tmren.biz'),('jnadeau@tmren.biz'),('jnutting@tmren.biz'),('joannew@tmren.biz'),('joef@tmren.biz'),('joejordan@tmren.biz'),('joes@tmren.biz'),('joetrask@tmren.biz'),('joeyc@tmren.biz'),('johncarroll@tmren.biz'),('johnh@tmren.biz'),('johnlawrence@tmren.biz'),('johnmarquis@tmren.biz'),('joshp@tmren.biz'),('joshuaj@tmren.biz'),('jperron@tmren.biz'),('jryan@tmren.biz'),('jtomazin@tmren.biz'),('judyreeves@tmren.biz'),('juliaw@tmren.biz'),('juliecourt@tmren.biz'),('julietmorrison@tmren.biz'),('justinjohnson@tmren.biz'),('kaitlyn@tmren.biz'),('kara@tmren.biz'),('karenh@tmren.biz'),('karenstpeter@tmren.biz'),('katecaron@tmren.biz'),('kathleen@tmren.biz'),('kathleenm@tmren.biz'),('kathleens@tmren.biz'),('kathrynlevesque@tmren.biz'),('katiey@tmren.biz'),('katrina@tmren.biz'),('katy@tmren.biz'),('kclark@tmren.biz'),('kdavis@tmren.biz'),('keith@tmren.biz'),('keithnicely@tmren.biz'),('kellyellis@tmren.biz'),('kellyp@tmren.biz'),('kellys@tmren.biz'),('kellystump@tmren.biz'),('kenl@tmren.biz'),('kennyjacques@tmren.biz'),('keren@tmren.biz'),('kevin@tmren.biz'),('kevinc@tmren.biz'),('kfowler@tmren.biz'),('kgannon@tmren.biz'),('khight@tmren.biz'),('kianakane@tmren.biz'),('kim@tmren.biz'),('kimberly@tmren.biz'),('kimchilds@tmren.biz'),('kirk@tmren.biz'),('kkendrick@tmren.biz'),('kristen@tmren.biz'),('kristenb@tmren.biz'),('kristenw@tmren.biz'),('larryc@tmren.biz'),('lauradavis@tmren.biz'),('laurelf@tmren.biz'),('laurieb@tmren.biz'),('lbowie@tmren.biz'),('lchampagne@tmren.biz'),('lcote@tmren.biz'),('leeboutwell@tmren.biz'),('lenny@tmren.biz'),('les@tmren.biz'),('lesser@tmren.biz'),('lindababbitt@tmren.biz'),('lindsay@tmren.biz'),('lisac@tmren.biz'),('lisalibby@tmren.biz'),('lisavilla@tmren.biz'),('lizd@tmren.biz'),('llabauve@tmren.biz'),('lmorrison@tmren.biz'),('loni@tmren.biz'),('lonig@tmren.biz'),('loristonge@tmren.biz'),('louc@tmren.biz'),('ltaylor@tmren.biz'),('lucyr@tmren.biz'),('lvetterline@tmren.biz'),('lynnoleary@tmren.biz'),('lynnw@tmren.biz'),('maddie@tmren.biz'),('maie@tmren.biz'),('mandy@tmren.biz'),('marcello@tmren.biz'),('marcy@tmren.biz'),('mariah@tmren.biz'),('marieb@tmren.biz'),('mariesullivan@tmren.biz'),('marketing@tmren.biz'),('markf@tmren.biz'),('markl@tmren.biz'),('markm@tmren.biz'),('markmc@tmren.biz'),('markmoody@tmren.biz'),('martynorton@tmren.biz'),('matthew@tmren.biz'),('mattl@tmren.biz'),('mattparks@tmren.biz'),('maudewright@tmren.biz'),('mbrown@tmren.biz'),('mcook@tmren.biz'),('mcookson@tmren.biz'),('meganc@tmren.biz'),('melanie@tmren.biz'),('melindatorrens@tmren.biz'),('meredith@tmren.biz'),('meredithdunn@tmren.biz'),('michaeldubois@tmren.biz'),('michaelhamilton@tmren.biz'),('michaeljepson@tmren.biz'),('michaelm@tmren.biz'),('michaelmcmanus@tmren.biz'),('michaelurban@tmren.biz'),('michellec@tmren.biz'),('michellef@tmren.biz'),('michellesweet@tmren.biz'),('mike@tmren.biz'),('mikeb@tmren.biz'),('mikejlane@tmren.biz'),('mikeq@tmren.biz'),('milos@tmren.biz'),('mindyh@tmren.biz'),('mindysanderson@tmren.biz'),('mkerry@tmren.biz'),('mlawsure@tmren.biz'),('mmcaleney@tmren.biz'),('mmichaud@tmren.biz'),('monet@tmren.biz'),('moniquesanders@tmren.biz'),('moxi-auburn@tmren.biz'),('moxi-falmouth@tmren.biz'),('moxi-southportland@tmren.biz'),('mrich@tmren.biz'),('mrogers@tmren.biz'),('mrs@tmren.biz'),('msiggy@tmren.biz'),('mtapley@tmren.biz'),('nancyb@tmren.biz'),('nasali@tmren.biz'),('nathan@tmren.biz'),('nbartlett@tmren.biz'),('nbrown@tmren.biz'),('nicole@tmren.biz'),('normp@tmren.biz'),('nsaucier@tmren.biz'),('oreilly@tmren.biz'),('pam@tmren.biz'),('patcribby@tmren.biz'),('patricia@tmren.biz'),('pattyvigue@tmren.biz'),('paularm@tmren.biz'),('paulcurrier@tmren.biz'),('paulh@tmren.biz'),('peter@tmren.biz'),('peteri@tmren.biz'),('petersawyer@tmren.biz'),('pfelker@tmren.biz'),('phatem@tmren.biz'),('pmcleod@tmren.biz'),('pnicely@tmren.biz'),('prowe@tmren.biz'),('psmith@tmren.biz'),('pstewart@tmren.biz'),('qminhle@tmren.biz'),('randiburnell@tmren.biz'),('raylene@tmren.biz'),('rbouffard@tmren.biz'),('rebeccathomen@tmren.biz'),('rhaskell@tmren.biz'),('rhondakenney@tmren.biz'),('richardc@tmren.biz'),('rickm@tmren.biz'),('rob@tmren.biz'),('ronb@tmren.biz'),('ronh@tmren.biz'),('rosemary@tmren.biz'),('rtompkins@tmren.biz'),('russell@tmren.biz'),('rustymeggison@tmren.biz'),('sabine@tmren.biz'),('sallyh@tmren.biz'),('sandi@tmren.biz'),('sandralegere@tmren.biz'),('sandramonzo@tmren.biz'),('sandraphillips@tmren.biz'),('sandrasherry@tmren.biz'),('sandy@tmren.biz'),('sandyb@tmren.biz'),('sandycross@tmren.biz'),('sarab@tmren.biz'),('sarah@tmren.biz'),('sarareynolds@tmren.biz'),('sarsenault@tmren.biz'),('sbilodeau@tmren.biz'),('schenker@tmren.biz'),('scottmorgan@tmren.biz'),('scottvogell@tmren.biz'),('scroteau@tmren.biz'),('sdrew@tmren.biz'),('serickson@tmren.biz'),('sgreen@tmren.biz'),('shammond@tmren.biz'),('shannonstevens@tmren.biz'),('shelley@tmren.biz'),('shellp@tmren.biz'),('sierraallen@tmren.biz'),('sjclauson@tmren.biz'),('smerrill@tmren.biz'),('smetzger@tmren.biz'),('sonja@tmren.biz'),('spetersen@tmren.biz'),('splourde@tmren.biz'),('ssmith@tmren.biz'),('ssnow@tmren.biz'),('stacycolbybarnes@tmren.biz'),('stalbot@tmren.biz'),('stanley@tmren.biz'),('statie@tmren.biz'),('stephanielynn@tmren.biz'),('stevemiller@tmren.biz'),('stevemorgan@tmren.biz'),('stevet@tmren.biz'),('stevew@tmren.biz'),('suef@tmren.biz'),('sueliebling@tmren.biz'),('suem@tmren.biz'),('suepoirier@tmren.biz'),('susanporell@tmren.biz'),('sydneyharrison@tmren.biz'),('talexander@tmren.biz'),('tamib@tmren.biz'),('tammyb@tmren.biz'),('tammym@tmren.biz'),('tanyab@tmren.biz'),('tanyacrawford@tmren.biz'),('tboudreau@tmren.biz'),('tdurepo@tmren.biz'),('ted@tmren.biz'),('teresamorse@tmren.biz'),('terril@tmren.biz'),('tesskeeran@tmren.biz'),('tgreeley@tmren.biz'),('tim@tmren.biz'),('tmangino@tmren.biz'),('tmorra@tmren.biz'),('tom@tmren.biz'),('tomtrask@tmren.biz'),('tori@tmren.biz'),('travish@tmren.biz'),('trish@tmren.biz'),('trusso@tmren.biz'),('tux@tmren.biz'),('tynekenny@tmren.biz'),('ubenoit@tmren.biz'),('vaida@tmren.biz'),('vaughn@tmren.biz'),('vicki@tmren.biz'),('vickieshane@tmren.biz'),('vinniematson@tmren.biz'),('wendylebel@tmren.biz'),('willleary@tmren.biz'),('willplummer@tmren.biz'),('wnelsen@tmren.biz'),('wshafter@tmren.biz'),('x4o0'),('x71t'),('xab4'),('yolanda@tmren.biz'),('yvonne@tmren.biz'),('zacharyhanson@tmren.biz'),('zcreps@tmren.biz')
insert into @tempemails values ('aaron@tmren.biz'),('acarver@tmren.biz'),('aimeetonneson@tmren.biz'),('alexalmerrill@gmail.com'),('allison3333@gmail.com'),('alyssa@tmren.biz'),('info@scovillefoleyhomes.com'),('amyarata@tmren.biz'),('amycross@tmren.biz'),('amysylvestre@tmren.biz'),('andrea@tmren.biz'),('hanscomandrew@gmail.com'),('angelcole@tmren.biz'),('annemarie@tmren.biz'),('annie@tmren.biz'),('april@tmren.biz'),('aprilb@tmren.biz'),('athurston@tmren.biz'),('auburnAdmin@tmren.biz'),('autumn@tmren.biz'),('awadsworth@tmren.biz'),('BangorAdmin@tmren.biz'),('barbara.deschenes@tmren.biz'),('barbaratrafton@gmail.com'),('barbieperkins@tmren.biz'),('bbabirak@tmren.biz'),('beckydoughty@tmren.biz'),('ben@tmren.biz'),('benharvey@tmren.biz'),('bettyn@tmren.biz'),('billp@tmren.biz'),('billreilly@tmren.biz'),('billt@tmren.biz'),('blocke@tmren.biz'),('bmason@tmren.biz'),('bob@tmren.biz'),('bobmagazu@tmren.biz'),('bpike@tmren.biz'),('bradp@tmren.biz'),('brandon@tmren.biz'),('brenda@tmren.biz'),('brendab@tmren.biz'),('brendajames@tmren.biz'),('brianm@tmren.biz'),('brianw@tmren.biz'),('brichard@tmren.biz'),('bsessions@tmren.biz'),('budfarwell@tmren.biz'),('budstoddard@tmren.biz'),('bweeks@tmren.biz'),('camille@tmren.biz'),('carolcmaine@gmail.com'),('carolfox@tmren.biz'),('carolpapale@gmail.com'),('carolyn@tmren.biz'),('carrie@tmren.biz'),('carriew@tmren.biz'),('casey@tmren.biz'),('cassiemasonrealestate@gmail.com'),('cathyc@tmren.biz'),('celina@tmren.biz'),('cfox@tmren.biz'),('cfullerton@tmren.biz'),('cgoyet@tmren.biz'),('chadbradbury14@gmail.com'),('charlesgrover@tmren.biz'),('charlyb@tmren.biz'),('cvcaprio@gmail.com'),('chawes@tmren.biz'),('chelsea@tmren.biz'),('cherylh@tmren.biz'),('cherylwilleybroker@gmail.com'),('chinckley@tmren.biz'),('SaladinoME@gmail.com'),('chrisalbert@tmren.biz'),('chrisalmasi@tmren.biz'),('chrisolsen@tmren.biz'),('christinapierce@tmren.biz'),('christopherl@tmren.biz'),('christya@tmren.biz'),('cindysdan@yahoo.com'),('cmac@tmren.biz'),('cnichols@tmren.biz'),('codys@tmren.biz'),('cookie@tmren.biz'),('cortnie@tmren.biz'),('corya@tmren.biz'),('cpoulin@tmren.biz'),('craigd@tmren.biz'),('craigg@tmren.biz'),('creynolds@tmren.biz'),('cthorpe@tmren.biz'),('turnbullteamtmren@gmail.com'),('curtis@tmren.biz'),('cwarren@tmren.biz'),('cwhalen@tmren.biz'),('cynthiat@tmren.biz'),('czegouros@tmren.biz'),('dackerson@tmren.biz'),('dandowns@tmren.biz'),('daniell@tmren.biz'),('danmclellan@tmren.biz'),('dansellsmaine@tmren.biz'),('brendasessionsgroup@gmail.com'),('davidbuchstaber@tmren.biz'),('daviddeschaine@tmren.biz'),('david.fordproperties@gmail.com'),('davidkane@tmren.biz'),('davidkitchenre@gmail.com'),('davidsellsmaine@outlook.com'),('davidr@tmren.biz'),('davidsumner@tmren.biz'),('dblahusch@tmren.biz'),('dbond@tmren.biz'),('dbuffum@tmren.biz'),('dcoleman@tmren.biz'),('dcourtney@tmren.biz'),('dcrafts@tmren.biz'),('deb@tmren.biz'),('debbiesanborn@tmren.biz'),('DEBI@TMREN.BIZ'),('debra@tmren.biz'),('debrah@tmren.biz'),('debrosa@tmren.biz'),('deb@debsileo.com'),('denisev@tmren.biz'),('Derek@DerekGoff.com'),('derektheriault@tmren.biz'),('desiree@themainerealestatenetwork.com'),('dgagne@tmren.biz'),('dgelinas@tmren.biz'),('dianecote@tmren.biz'),('dianeg@tmren.biz'),('dianneh@tmren.biz'),('djabar@tmren.biz'),('djackson@tmren.biz'),('djenkins@tmren.biz'),('dlegassie@tmren.biz'),('don@tmren.biz'),('donaldp@tmren.biz'),('donnag@tmren.biz'),('donnapinkham@tmren.biz'),('donruss@tmren.biz'),('dougbond@tmren.biz'),('debpenneyre@gmail.com'),('dpilon@tmren.biz'),('dstults@tmren.biz'),('edherczeg@gmail.com'),('edsharpe@tmren.biz'),('edwardrichard@tmren.biz'),('eric@mymainedreamhome.com'),('eleanorf@tmren.biz'),('elibby@tmren.biz'),('elizabethbanwell@tmren.biz'),('elizabethsanford@tmren.biz'),('epratte@tmren.biz'),('eric@tmren.biz'),('ericka@tmren.biz'),('ernest@ernestporell.com'),('evas@tmren.biz'),('ewhitehouse@tmren.biz'),('faye@tmren.biz'),('fgrassi@maine.rr.com'),('gail@tmren.biz'),('gailkolda@tmren.biz'),('garyw@tmren.biz'),('gena@tmren.biz'),('gerardl@tmren.biz'),('gina@tmren.biz'),('glennd@tmren.biz'),('glenngarry@tmren.biz'),('glenp@tmren.biz'),('gmaclean@tmren.biz'),('gray@tmren.biz'),('gregroy@tmren.biz'),('gregsouza@tmren.biz'),('gretchenb@tmren.biz'),('hbuda@tmren.biz'),('hciampi@tmren.biz'),('heatherk@tmren.biz'),('heidiyoung@tmren.biz'),('helenfox@tmren.biz'),('hharrison@tmren.biz'),('hilary.gotlieb@gmail.com'),('holly@tmren.biz'),('hollyadkins@tmren.biz'),('holly@bancroftbrown.com'),('idaearle@gmail.com'),('jacquelineguido@tmren.biz'),('jaimec@tmren.biz'),('jakewight@tmren.biz'),('jamescalifano@tmren.biz'),('jami@tmren.biz'),('jamief@tmren.biz'),('jandwinal@gmail.com'),('janef@tmren.biz'),('janemaine@tmren.biz'),('Johnandjanice@tmren.biz'),('janicejannetty@tmren.biz'),('jansmith@tmren.biz'),('jarrodmallon@tmren.biz'),('jasonb@tmren.biz'),('jasonbecvar@tmren.biz'),('jbasinet@tmren.biz'),('catmacgroup@gmail.com'),('jdarling@tmren.biz'),('jdouglass@tmren.biz'),('jdye@tmren.biz'),('jeannette@tmren.biz'),('jeffwalkersells@gmail.com'),('jeffclark@tmren.biz'),('jeffcyr@tmren.biz'),('teamvangilder@gmail.com'),('jenna@tmren.biz'),('jennifer@tmren.biz'),('jenniferdowdy@tmren.biz'),('jennifermorin@tmren.biz'),('jenniferv@tmren.biz'),('jeremyhanken@tmren.biz'),('jerryprice@tmren.biz'),('jfruzia@tmren.biz'),('joleen@MaineHouse2Home.com'),('jgrover@tmren.biz'),('jguy@tmren.biz'),('jodyhammond3@msn.com'),('jhancock@tmren.biz'),('jillian@tmren.biz'),('jillwatson@tmren.biz'),('jimk@tmren.biz'),('jimknight@tmren.biz'),('jimmyliang@tmren.biz'),('jimw@tmren.biz'),('jkarchov@tmren.biz'),('jon@weAREsellingmaine.com'),('jnadeau@tmren.biz'),('jodynutting@gmail.com'),('mainepropertysold@gmail.com'),('joef@tmren.biz'),('joejordan@tmren.biz'),('joes@tmren.biz'),('joetrask@tmren.biz'),('joeyc@tmren.biz'),('johncarroll@tmren.biz'),('teamharmon@tmren.biz'),('johnlawrence@tmren.biz'),('johnmarquis@tmren.biz'),('Josh@JoshSellsMaine.com'),('joshuaj@tmren.biz'),('jperron@tmren.biz'),('jryan@tmren.biz'),('jtomazin@tmren.biz'),('judyreeves@tmren.biz'),('juliaw@tmren.biz'),('juliecourt@tmren.biz'),('julietmorrison@tmren.biz'),('justinjohnson@tmren.biz'),('kaitlyn@tmren.biz'),('kara@scovillefoleyhomes.com'),('karenh@tmren.biz'),('karenstpeter@tmren.biz'),('katecaron@tmren.biz'),('kathleen@tmren.biz'),('kathleenm@tmren.biz'),('Kathleen@MaineRealEstatePro.com'),('kathrynlevesque@tmren.biz'),('katiey@tmren.biz'),('katrina@tmren.biz'),('katy@tmren.biz'),('kclark@tmren.biz'),('kdavis@tmren.biz'),('keith@tmren.biz'),('keith@keithnicely.com'),('kellyellis@tmren.biz'),('kellyparkerrealtor@gmail.com'),('kellys@tmren.biz'),('kellystump@tmren.biz'),('kenl@tmren.biz'),('kennyjacques@tmren.biz'),('keren@tmren.biz'),('Kevin@tmren.biz'),('kevinc@tmren.biz'),('reladymaine@gmail.com'),('kgannon@tmren.biz'),('khight@tmren.biz'),('kianakane@tmren.biz'),('Kim@tmren.biz'),('kimberly@tmren.biz'),('kimchilds@tmren.biz'),('kirk@kirkkennedyrealtor.com'),('kkendrick@tmren.biz'),('Kristen@tmren.biz'),('kristenb@tmren.biz'),('kristenw@tmren.biz'),('larryc@tmren.biz'),('lauradavis@tmren.biz'),('laurelf@tmren.biz'),('laurieb@tmren.biz'),('lbowie@tmren.biz'),('lchampag@maine.rr.com'),('lcote@tmren.biz'),('leeboutwell@tmren.biz'),('Lenny@tmren.biz'),('les@tmren.biz'),('lesser@tmren.biz'),('lindababbitt@tmren.biz'),('lindsay@tmren.biz'),('Lisa@LisaCoteRealtor.com'),('LisaLibbyRealtor@gmail.com'),('lisavilla@tmren.biz'),('lizd@tmren.biz'),('llabauve@tmren.biz'),('lmorrison@tmren.biz'),('loni@themainerealestatenetwork.com'),('lonig@tmren.biz'),('loristonge@tmren.biz'),('louc@tmren.biz'),('ltaylor@tmren.biz'),('lucyr@tmren.biz'),('lvetterline@tmren.biz'),('lynnoleary@tmren.biz'),('lynnw@tmren.biz'),('maddie@tmren.biz'),('maiewakefield@gmail.com'),('mandy@tmren.biz'),('marcello@tmren.biz'),('marcy@tmren.biz'),('mariah@tmren.biz'),('marieb@tmren.biz'),('mariesullivan@tmren.biz'),('marketing@tmren.biz'),('markf@tmren.biz'),('markl@tmren.biz'),('markm@tmren.biz'),('markmc@tmren.biz'),('markmoody@tmren.biz'),('martynorton@tmren.biz'),('matthew@tmren.biz'),('info@wearesellingmaine.com'),('mattparks@tmren.biz'),('maudewright@tmren.biz'),('mbrown@tmren.biz'),('mcook@tmren.biz'),('mcookson@tmren.biz'),('meganc@tmren.biz'),('melanie@tmren.biz'),('Melinda@MaineRES.com'),('meredith@tmren.biz'),('meredithdunn@tmren.biz'),('michaeldubois@tmren.biz'),('michaelhamilton@tmren.biz'),('michaeljepson@tmren.biz'),('michaelm@tmren.biz'),('michaelmcmanus@tmren.biz'),('michaelurban@tmren.biz'),('michellec@tmren.biz'),('michellef@tmren.biz'),('michellesweet@tmren.biz'),('mike@tmren.biz'),('mikeb@tmren.biz'),('mikejlane@tmren.biz'),('mikeq@tmren.biz'),('milos@tmren.biz'),('mindyh@tmren.biz'),('mindysanderson@tmren.biz'),('mkerry@tmren.biz'),('mlawsure@tmren.biz'),('mmcaleney@tmren.biz'),('mmichaud@tmren.biz'),('monet@tmren.biz'),('moniquesanders@tmren.biz'),('moxi-auburn@tmren.biz'),('moxi-falmouth@tmren.biz'),('moxi-southportland@tmren.biz'),('mrich@tmren.biz'),('mrogers@tmren.biz'),('mrs@tmren.biz'),('msiggy2@gmail.com'),('mtapley@tmren.biz'),('nancyb@tmren.biz'),('nasali@tmren.biz'),('nathan@tmren.biz'),('nbartlett@tmren.biz'),('nbrown@tmren.biz'),('nicole@tmren.biz'),('normp@tmren.biz'),('nsaucier@tmren.biz'),('oreilly@tmren.biz'),('pam@tmren.biz'),('patcribby@tmren.biz'),('pat@mainehomestoday.com'),('pattyvigue@tmren.biz'),('paularm@tmren.biz'),('paulcurrier01@gmail.com'),('paulh@tmren.biz'),('peter@tmren.biz'),('peter@mainehomeownership.com'),('petsaw11@gmail.com'),('patty@haskellteam.com'),('phatem@tmren.biz'),('pmcleod@tmren.biz'),('pnicely@tmren.biz'),('phil@popssellsmaine.com'),('psmith@tmren.biz'),('pstewart@tmren.biz'),('qminhle@tmren.biz'),('randiburnell@tmren.biz'),('makingmainehome@gmail.com'),('rbouffard@tmren.biz'),('rebeccathomen@tmren.biz'),('rick@haskellteam.com'),('rhondakenney@themainerealestatenetwork.com'),('richardc@tmren.biz'),('harpswellrm@gmail.com'),('rob@tmren.biz'),('ronb@tmren.biz'),('ronh@tmren.biz'),('rosemary@tmren.biz'),('rtompkins@tmren.biz'),('russell@tmren.biz'),('Rusty@RustySoldMyHouse.com'),('sabine@tmren.biz'),('sallyh@themainerealestatenetwork.com'),('sandi@tmren.biz'),('sandralegere@tmren.biz'),('sandramonzo@tmren.biz'),('sandraphillips@tmren.biz'),('sandrasherry@tmren.biz'),('sandy@tmren.biz'),('sandyb@tmren.biz'),('sandycross@tmren.biz'),('sarab@tmren.biz'),('sarah@sarahcarsonrealestate.com'),('sarareynolds@tmren.biz'),('sarsenault@tmren.biz'),('sbilodeau@tmren.biz'),('schenker@tmren.biz'),('scottmorgan@tmren.biz'),('scottvogell@tmren.biz'),('homesalesbysue@gmail.com'),('sdrew@tmren.biz'),('ericksoncroteauhomesales@gmail.com'),('sgreen@tmren.biz'),('shammond@tmren.biz'),('shannonstevens@tmren.biz'),('shelley@tmren.biz'),('shellp@tmren.biz'),('sierraallen@tmren.biz'),('sjclauson@tmren.biz'),('smerrill@tmren.biz'),('smetzger@tmren.biz'),('sonja@tmren.biz'),('spetersen@tmren.biz'),('splourde@tmren.biz'),('ssmith@tmren.biz'),('mainelymgmt@yahoo.com'),('stacycolbybarnes@tmren.biz'),('stalbot@tmren.biz'),('stanley@tmren.biz'),('statie@tmren.biz'),('sbrealestatesales@gmail.com'),('smillerrealtor@gmail.com'),('stevemorgan@tmren.biz'),('steve@sebagore.com'),('Steve@WilsonGlobal.org'),('suef@tmren.biz'),('sueliebling@tmren.biz'),('suem@tmren.biz'),('suepoirier@tmren.biz'),('susanporell@tmren.biz'),('sydneyharrison@tmren.biz'),('talexander@tmren.biz'),('tamib@tmren.biz'),('tammyb@tmren.biz'),('tammym@tmren.biz'),('tanyab@tmren.biz'),('tanyacrawford@tmren.biz'),('tboudreau@tmren.biz'),('tdurepo@tmren.biz'),('ted@tmren.biz'),('teresamorse@tmren.biz'),('terril@tmren.biz'),('tesskeeran@tmren.biz'),('tgreeley@tmren.biz'),('tim@tmren.biz'),('tmangino@tmren.biz'),('tmorra@tmren.biz'),('tom@tmren.biz'),('tomtrask@tmren.biz'),('tori@tmren.biz'),('travish@tmren.biz'),('trish@tmren.biz'),('trusso@tmren.biz'),('tux@ask4tux.com'),('tynekenny@gmail.com'),('ubenoit@tmren.biz'),('vaida@tmren.biz'),('vaughn@tmren.biz'),('vicki@tmren.biz'),('vshane@tmren.biz'),('vinniematson@tmren.biz'),('wendylebel@tmren.biz'),('willleary@tmren.biz'),('w.plummer@me.com'),('wnelsen@tmren.biz'),('wshafter@tmren.biz'),('ralph@ralphbartholomew.com'),('wkany@ymail.com'),('tammyb@themainerealestatenetwork.com'),('yolanda@tmren.biz'),('yvonne@themainerealestatenetwork.com'),('zacharyhanson@tmren.biz'),('zcreps@tmren.biz');

-- gather some statistics
set @NTotalUsers = (select count(*) from userinfo where parentuser = 'mainerealestate');
set @NExpectedFromImport = (select count(*) from @tempusernames);
set @NExpectedEmailsFromImport = (select count(*) from @tempemails);
set @NActualFromImport = (select count(*) from userinfo inner join @tempusernames as a on userinfo.username = a.username);
-- display statistics
select @NTotalUsers as NTotalUsers, @NExpectedFromImport as NExpectedFromImport, @NExpectedEmailsFromImport as NExpectedEmailsFromImport, @NActualFromImport as NActualFromImport;

-- find the usernames from the import data that are missing from the database
insert into @missing select a.username, b.email from @tempusernames as a
inner join @tempemails as b on a.id = b.id
where a.username not in (select username from userinfo where parentuser = 'mainerealestate');
-- display
select * from @missing;

-- find any users missing from the import that exist elsewhere in the database
insert into @missingbutexisting select u.username, m.email, ui.userid, ui.parentuser from aspnet_Users as u
inner join aspnet_Membership as m on m.userid = u.userid
inner join userinfo as ui on ui.username = u.username
where m.email in (select EmailMissing from @missing);
-- display
select * from @missingbutexisting;