USE [GrpInsurance]

---- create temp table
DECLARE @list_peserta TABLE ( 
								no_polis VARCHAR(11),
								no_peserta VARCHAR(12),
								email VARCHAR(80)
							)

---- insert data to temp table
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022542-0','pribadi.sumara@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001552-0','abdul.kohar@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001675-0','achmad.syarifuddin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001629-0','alamsah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001685-0','amin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001691-0','amril@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001569-0','anastasia.limbong@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001562-0','atikah.bakri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001611-0','citra.warina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001686-0','dedi.mulyadi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001544-0','demina.ginting@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001698-0','dwiyani.priyanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001574-0','edi.winarno@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004691-0','elfrido@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001731-0','elies.irmayanti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001560-0','febria.rahmadani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001612-0','gusti.ayu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001603-0','herets.tobias@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001547-0','herlina.sinaga@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001713-0','ketut.sumarta@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001567-0','anom.suteja@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001712-0','irwan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001632-0','jaka.riyanta@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001652-0','jaslina.suprihatin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001701-0','jonathan.ndena@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001738-0','lamhot.simanjuntak@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001673-0','marcus.tri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001541-0','maria.benyamin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001636-0','maria.yulvianty@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001607-0','martin.toni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001682-0','rahmatullah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001550-0','mutahir@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001722-0','nasiyo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001546-0','prita.dewi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001581-0','yulina.zawiyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001601-0','ratna.sari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001723-0','renie.tatiana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001558-0','rinawati.purnamaningrum@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001657-0','rizky.faried@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004671-0','rojali@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001664-0','rosma.panggabean@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001608-0','roudhotul.janah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001565-0','samijan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001728-0','sodik.purwanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001606-0','sofyan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001549-0','darto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001618-0','sugeng.starmono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001580-0','syarifuddin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001658-0','tata.kurnia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001683-0','teguh.widodo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001600-0','trianik@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001641-0','warkim.sutawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001564-0','wartoyo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001688-0','wiwit.mulyawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001741-0','fajri.syawal@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001736-0','nyoman.kartikayasa@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001647-0','mery.melati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001745-0','stephanus.anton@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001749-0','muchlis.syaifudin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001759-0','theresia.puspasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001774-0','wayan.merthana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001764-0','abdul.hamid@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001791-0','shinta.natalia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001777-0','ade.yustian@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001773-0','didik.suhartanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001758-0','eko.boedi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001768-0','budy.darmawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001785-0','agus.pujiono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001797-0','fransisca.dian@equity.id')
--INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001794-0','deswitha.natalya@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001798-0','nia.kurniatin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001676-0','deby.samuel@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001539-0','grace.liawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001721-0','gunadi.mulia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1999.0082.0','1999018322-0','julius.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001590-0','melitasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001556-0','noor.setiadi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001697-0','riko.kurniawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001557-0','rudi.pakpahan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1999.0082.0','1999017737-0','samuel.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001747-0','hendarto.koeswara@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001780-0','tania.chandra@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001802-0','wayan.astika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001814-0','ocin.suryana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001804-0','david.soetadi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001806-0','yis.wiriani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001810-0','anggiat.tambunan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1999.0082.0','1999018430-0','endy.stjen@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001835-0','aribhawa.samudra@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001828-0','suhartono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001823-0','suhardi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001844-0','rahmi.endah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001848-0','lita.agustinar@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001849-0','meilia.rosaria@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001865-0','amilin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001861-0','andriyano@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001857-0','nurwidya.hayati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001847-0','jufri.rauf@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001867-0','rica.dhamajanti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001851-0','telvi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001868-0','widodo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000006-0','hutomo.dwi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000123-0','john.kasenda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000020-0','rerry.sukmawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000125-0','jaenul.waton@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000067-0','david.franico@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000018-0','sutisna@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000173-0','hedy.romadhon@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000024-0','wihartono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000022-0','syaiful.effendi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004129-0','hilmi.saputra@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004207-0','waras@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004349-0','hendrique.dacruz@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004374-0','indri.hapsari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992001449-0','budi.sulistyowati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004461-0','sintya.maria@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004459-0','susanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004488-0','dimas.poesponegoro@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004484-0','uli.desyana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004495-0','agus.diana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005372-0','teguh.iman@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004518-0','rita.iskarina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004528-0','monika.sari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004535-0','poppy@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004536-0','aretha.magdalena@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004549-0','indra.stephanus@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004557-0','fauziah.akib@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004565-0','hendra@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004563-0','andhi.suprayitno@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004572-0','bona@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004573-0','budi.candra@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004570-0','ariyanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004571-0','maryono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004424-0','khuwailid@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004427-0','sugiharto.halim@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004577-0','agus.setiawan@equity.id')
--INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004582-0','irvan.santoso@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004560-0','indra.jayakasih@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004559-0','indri.puji@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004575-0','ferry.muhammad@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004588-0','indri.astuti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004583-0','suyono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004616-0','hendrikus.dharmawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004610-0','novitriana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004617-0','theresia.agustina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004614-0','nyoman.alit@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004618-0','henny.martina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022543-0','hasim@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004627-0','sumaryono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004661-0','dyah.yani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004665-0','dilia.mona@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022544-0','nur.ali@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004767-0','yuliarti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005412-0','rindu.miliawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004687-0','nita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1999.0082.0','1999018396-0','pranoto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004632-0','irena.yoga@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004753-0','bambang.santoso@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004747-0','tri.ertan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005504-0','reza.aditya@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004770-0','denny.hasan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004761-0','theresia.sally@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004760-0','made.teguh@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004773-0','wiwi.apriani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005076-0','imanuel.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004778-0','erika.wulandari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004779-0','imanu.dhuriyatin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004777-0','amargo.ami@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005501-0','dian.novita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005245-0','risna.dian@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005239-0','cipta.wibisana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004798-0','lusi.rahayu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005049-0','maria.caroline@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004817-0','darsono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004819-0','risha.dwijayati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004832-0','dewi.puspa@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004888-0','kastari.sardjono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004826-0','ibut.gemantri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004849-0','nuki.wirawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004847-0','darwindo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004850-0','fahrul.mundjid@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004855-0','eka.gunturi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004854-0','fitri.sandi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004880-0','liana.dewi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004879-0','yosep.pernandos@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004853-0','debby.ismah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005394-0','dani.sethia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022548-0','ibnu.sofwan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005237-0','neneng.nurhayati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005393-0','noto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005411-0','katherine@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004884-0','novianty.haholongan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004878-0','christine.hadiman@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004915-0','hendra.ww@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004885-0','delyawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005039-0','nurdiana.isnaeni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005672-0','utami.handayani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005054-0','siti.nurhidayati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005475-0','romanti@equity.id')
--INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005330-0','pribadi.pamungkas@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004911-0','ulfi.rizki@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004914-0','agung.dwi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005476-0','achdan.ali@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005075-0','lina.laila@equity.id')
--INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004916-0','dadang.anggoro@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004923-0','nurfadillah.hannum@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004922-0','armagatha.rani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004936-0','mieke.apriska@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005485-0','novrinta.widya@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005211-0','fahrir.rezal@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005212-0','eka.camalia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004966-0','diah.mustika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004951-0','rahniah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004957-0','dian.herdiyanti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005600-0','melin.siswida@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005601-0','naomi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005213-0','anastasia.pitaloka@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005267-0','ai.faziah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005238-0','arnita.herdiyati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004982-0','nugroho.wijakongko@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004955-0','roy.wibisono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004958-0','dominiko@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005242-0','henny@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005502-0','jerry.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005397-0','nurni.sundari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005318-0','triana.febianti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005243-0','hernawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004979-0','djendra.saebrono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004953-0','tri.paryono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005317-0','alif.nasrulloh@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005316-0','eko.prasetyo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005721-0','misgianto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005328-0','dwirintiasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004977-0','nilasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004981-0','mugi.ginulur@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004985-0','vivi.aprianti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004986-0','mardiah.tumalun@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005018-0','fiesa.setia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005569-0','finta.ratna@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005332-0','regina.hadmawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005566-0','bernadine.duhita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004987-0','murtini@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005570-0','ayudina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005348-0','puspa.ratih@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005734-0','nellya.chrispin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005574-0','fitra.novriza@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005726-0','nur.lestari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005386-0','gusti.musthafa@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005573-0','novia.nuraini@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005725-0','maya.ulfah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992004999-0','rifni.ismalia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005019-0','silvia.susanty@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005695-0','irene.utari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005511-0','irma.delviasih@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005760-0','siti.hasanah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005603-0','eka.haryati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005599-0','ira.wahyuni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005509-0','alwidya.atim@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005602-0','deswita.husna@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005024-0','ali.hamzah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022545-0','sudarto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005266-0','yohannes.fernando@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005764-0','febriyanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005560-0','dwy.ariani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005658-0','reina.rahmatika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005682-0','rienanda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005350-0','siti.amalia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005486-0','yenni.riana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000236-0','juniaty@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005676-0','dimas.oktafian@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000208-0','adi.sulistianto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005577-0','yulisti.putri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005349-0','rury.ferianti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005674-0','ciana.alfi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005508-0','galuh.mustika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005564-0','muhammad.nurhidayat@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005510-0','nur.renala@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022555-0','hamzah.edwin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005506-0','sontiar.christina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005315-0','lilik.ernawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005615-0','iman.subarkah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005725-0','magdalena@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005571-0','ichroni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005598-0','hanni.abdullah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005726-0','hanita.aritonang@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005616-0','zainul.fahmi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005567-0','adyati.apriliani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005462-0','bernadete.ria@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005474-0','diyan.yuwono@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005592-0','marini.pasaribu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005620-0','maharani.sari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005554-0','rendy.pansa@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005613-0','lucia.isadora@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005618-0','hesny.sebatiningsih@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005607-0','meganita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005553-0','dewi.puri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005531-0','nugrahani.susilowati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005657-0','ernica.putri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005671-0','ayu.hasni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005668-0','rosmawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005665-0','chrisma.pravita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005667-0','inda.nirmala@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005666-0','oktania.maharani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005704-0','jenita.reni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005664-0','chrysta.nahuwaiy@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005621-0','ronald.karta@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005612-0','sugiharto.nugroho@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000207-0','khoirul.huda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005714-0','baita.lutfiyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005691-0','aida.intan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005617-0','barnas.danu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005614-0','perry.ekawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005696-0','febiola.diajeng@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005720-0','dhanianggi.estu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005675-0','aisah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005758-0','melia.frewita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005719-0','adista.maharani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005669-0','florence.isabella@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005718-0','rini.melati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005670-0','dyah.ayu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005656-0','yusca.maulana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005684-0','teresia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005746-0','wahyu.wulan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005685-0','trifena.nugraheni@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005690-0','dimas.wahyu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000212-0','asih.putri@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005716-0','nike.irawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005688-0','glory.wattimena@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000220-0','suci.afriliyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022533-0','musyadat@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005749-0','dasya.apika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022534-0','aristya.wira@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022540-0','ahmad.imam@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005703-0','trishadi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005700-0','revina.rista@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005708-0','antonius.guntur@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005701-0','rolas@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005733-0','muhammad.febrianto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005710-0','dhimas.samiaji@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005707-0','jevon.radytia@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000188-0','erna.puspasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005744-0','fransisca.sunarsasi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022541-0','erwin.gunawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005706-0','anthonius.kanaris@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005728-0','maria.veronika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005705-0','indra.nurzainsyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005744-0','alvin.augusta@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005722-0','martha.evioren@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005727-0','ria.apellina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005709-0','adeline.fransiska@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000215-0','natalia.desi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005748-0','evi.marliani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000202-0','anggia.sekar@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000199-0','debby.yolanda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005715-0','dhesty.rindhu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000190-0','didi.permedi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005736-0','ditya.amanda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005739-0','yunita.anggarawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005735-0','athanasius.leonardo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005734-0','minetta.nadesul@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005745-0','reni.firdaus@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005741-0','smita.amaranggana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005750-0','sri.lestari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005752-0','winda.purnamasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022546-0','jovi.bastian@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005753-0','yunita.kumalasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005757-0','nurizka.firda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005759-0','galih.dyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022547-0','beni.iswanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005723-0','yoke.veranda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000214-0','putri.diana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005765-0','jeally.inggrid@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992005763-0','andreas.rizal@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005731-0','royntan.marlina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005730-0','dian.surya@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005729-0','anjani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005740-0','ana.farida@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005737-0','faizatul.khikmah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005743-0','dahlan.sihombing@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000210-0','stella.linda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005741-0','anisa.firdausi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017005761-0','desshinta.rizki@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000198-0','angela.christianti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022551-0','nana.rusdiana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022550-0','nur.kholis@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000191-0','andrey.artanto@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000192-0','serlen.nathania@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000186-0','gogor.ariyo@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000193-0','veronica.diahsiwi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000213-0','sitti.anindya@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000201-0','catherine.mahardika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017008006-0','airyvita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000240-0','krisentia.sheren@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000206-0','imam.kurniawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000239-0','maria.dianti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000205-0','umar.ahmad@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000219-0','philipus.himawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017009297-0','arita.aisyah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022552-0','budi.nugroho@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022554-0','dedi.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017009916-0','catur.wahyu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017009889-0','fahrul.rajab@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022553-0','angger.dika@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017009475-0','editha.octorina@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000242-0','inmas.merlita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161701-0','rina.mirnasari@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022556-0','herdi@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000224-0','noni.agustin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161702-0','mery.salita@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022557-0','ardi.maulana@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000227-0','johan.waworuntu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162207-0','rumondang.simatupang@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161855-0','doddy.affandy@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161837-0','novrianda@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161838-0','siti.royani@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161929-0','bethavinia.nurputranti@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017161963-0','roni.yohanes@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000231-0','feisal.laras@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162036-0','fendy.apriyantoro@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162125-0','devi.kusuma@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000233-0','andhika.eka@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000235-0','yotrin.setiawan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162121-0','abi.bayu@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000238-0','lusty.losak@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022558-0','siti.fatonah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000241-0','andreas.fabian@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162194-0','andrey.miko@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022559-0','dhilham.taqiyudin@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2017.0052.0','2017162196-0','virga.hasibuan@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('2018.0049.0','2018022560-0','sandy.fadillah@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000229-0','adreana.mirawati@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000237-0','kartina.sury@equity.id')
INSERT INTO @list_peserta ( no_polis, no_peserta, email ) VALUES ('1992.0011.0','1992000232-0','zulfikar.ali@equity.id')


---- main process
DECLARE 
    @no_polis VARCHAR(11),
    @email VARCHAR(80),
    @no_peserta VARCHAR(12)

DECLARE list_cursor CURSOR FAST_FORWARD FOR  

SELECT
	no_polis,
	no_peserta,
	LOWER(RTRIM(LTRIM(email))) AS email
FROM
	@list_peserta

OPEN list_cursor  
FETCH NEXT FROM list_cursor INTO @no_polis, @no_peserta, @email

WHILE @@FETCH_STATUS = 0  
BEGIN  

		IF NOT EXISTS(SELECT
							*
						FROM
							custport_user_login_client
						WHERE
							username = @email)
			BEGIN
				DECLARE @id_user INT
				INSERT INTO [dbo].[custport_user_login_client]
					    ([username]
					    ,[password]
					    ,[no_polis]
					    ,[no_peserta]
					    ,[status]
					    ,[create_by]
					    ,[create_date]
					    ,[change_by]
					    ,[change_date])
					VALUES
					    (@email
					    ,NULL
					    ,@no_polis
					    ,@no_peserta
					    ,'G'
					    ,'SYS'
					    ,GETDATE()
					    ,'SYS'
					    ,GETDATE())
				SELECT @id_user = SCOPE_IDENTITY()
				INSERT INTO [dbo].[custport_user_login_client_polis]
					   ([create_by]
					   ,[create_date]
					   ,[change_by]
					   ,[change_date]
					   ,[is_deleted]
					   ,[id_user]
					   ,[no_polis]
					   ,[no_peserta]
					   ,[status])
				  VALUES
					   ('SYS'
					   ,GETDATE()
					   ,'SYS'
					   ,GETDATE()
					   ,0
					   ,@id_user
					   ,@no_polis
					   ,@no_peserta
					   ,'I')
			END

    FETCH NEXT FROM list_cursor INTO @no_polis, @no_peserta, @email
END  

CLOSE list_cursor  
DEALLOCATE list_cursor 


---- insert policy configuration
INSERT INTO dbo.custport_polis_member
        (no_polis,
         view_klaim_backdate_bulan,
         status,
         create_date,
         create_by,
         change_date,
         change_by)
SELECT DISTINCT
	list_login.no_polis,
	12,
	'I',
	GETDATE(),
	'SYS',
	GETDATE(),
	'SYS'
FROM
	@list_peserta AS list_login LEFT JOIN
	dbo.custport_polis_member AS cpm ON list_login.no_polis = cpm.no_polis
WHERE
	cpm.no_polis IS NULL