insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~1~1','19000100','Liyun Zhu','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~2~1','19000100','Meijun Jiang','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~3~1','19000100','China Rahman','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~4~1','19000100','Mariana Rodan','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~5~1','19000100','Victor Rodan','David James Hobbs McWhirter','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~6~1','19000100','Yibin Dai','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~7~1','19000100','Yan Hui Yu','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~8~1','19000100','Quality of Homelife Properties Inc. (Irene Xiaofan Zhang)','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~9~1','19000100','Mehman Farziyev','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~10~1','19000100','Xin Zhou','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~11~1','19000100','Geetika Bedi','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~12~1','19000100','Mariam Asif','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~13~1','19000100','Poh Kuen Wong','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~14~1','19000100','Michelle Eunyoung Park','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~15~1','19000100','Silu Yang','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~16~1','19000100','Wan Heng Cheng','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~17~1','19000100','Barry George Wong','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~18~1','19000100','Yi Guan','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~19~1','19000100','Hong Xu','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~20~1','19000100','Jianhui Liang','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~21~1','19000100','Ruby YanYee Tse','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~23~1','19000100','Hoi Yan Chan','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~24~1','19000100','Lily Wong Ma','Stephen Chi Fung Ma','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~25~1','19000100','Chi Keung Wong','Chi Yuet Chang','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~26~1','19000100','YuenChing Shern','Jeremy G.K. Iu and Tiana ChunKay Shern','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~27~1','19000100','Woon Ching Cheung','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~28~1','19000100','S. K. Angela Tang','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~29~1','19000100','Yong Mei Li','','','Winlock Towns'); insert into tb_Worksheet(col_ID, col_FinalClosing, col_Name1, col_Name2, col_ContractDate, col_Centre) values('winlock~30~1','19000100','Crystal Sin Yee Tse','','','Winlock Towns'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~1~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~1~1','Longmore 5|6 (2BF)','1','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','1'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','1',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~1~1',1,'Contact','Unit 1 260 Finch Avenue East','Liyun Zhu','Unit 1 260 Finch Avenue East','Toronto','Ontario','','Karenzhu7788@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~2~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~2~1','Parkview 4 (2B)','2','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','2'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','2',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~2~1',1,'Contact','Unit 2 260 Finch Avenue East','Meijun Jiang','Unit 2 260 Finch Avenue East','Toronto','Ontario','','850158778@qq.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~3~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~3~1','Longmore 1|2 (2BF)','3','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','3'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','3',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~3~1',1,'Contact','Unit 3 260 Finch Avenue East','China Rahman','Unit 3 260 Finch Avenue East','Toronto','Ontario','','quazi.s.islam@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~4~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~4~1','Parkview 1 (2B)','4','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','4'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','4',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~4~1',1,'Contact','Unit 4 260 Finch Avenue East','Mariana Rodan','Unit 4 260 Finch Avenue East','Toronto','Ontario','','mrodan@mondconsult.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~5~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~5~1','Longmore 1|2 (2BF)','5','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','5'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','5',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~5~1',1,'Contact','Unit 5 262 Finch Avenue East','Victor Rodan','Unit 5 262 Finch Avenue East','Toronto','Ontario','','vrodan@mondconsult.com'); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email, col_Phone1, col_Phone2) values('winlock~5~1',2,'Contact','Unit 5 262 Finch Avenue East','David James Hobbs McWhirter','Unit 5 262 Finch Avenue East','Toronto','Ontario','','vrodan@mondconsult.com','6475011845','6478398407'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~6~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~6~1','Parkview 2 (2B)','6','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','6'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','6',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~6~1',1,'Contact','Unit 6 262 Finch Avenue East','Yibin Dai','Unit 6 262 Finch Avenue East','Toronto','Ontario','','1628064922@QQ.COM'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~7~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~7~1','Longmore 1|2 (2BF)','7','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','7'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','7',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~7~1',1,'Contact','Unit 7 262 Finch Avenue East','Yan Hui Yu','Unit 7 262 Finch Avenue East','Toronto','Ontario','','realtorjenniferyu@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~8~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~8~1','Parkview 1 (2B)','8','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','8'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','8',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~8~1',1,'Contact','Unit 8 262 Finch Avenue East','Quality of Homelife Properties Inc. (Irene Xiaofan Zhang)','Unit 8 262 Finch Avenue East','Toronto','Ontario','','irene.zhang@ecescorp.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~9~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~9~1','Longmore 1|2 (2BF)','9','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','9'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','9',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~9~1',1,'Contact','Unit 9 264 Finch Avenue East','Mehman Farziyev','Unit 9 264 Finch Avenue East','Toronto','Ontario','','memo.farzi@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~10~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~10~1','Parkview 2 (2B)','10','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','10'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','10',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~10~1',1,'Contact','Unit 10 264 Finch Avenue East','Xin Zhou','Unit 10 264 Finch Avenue East','Toronto','Ontario','','xin.zhou.xz@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~11~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~11~1','Longmore 1|2 (2BF)','11','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','11'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','11',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~11~1',1,'Contact','Unit 11 264 Finch Avenue East','Geetika Bedi','Unit 11 264 Finch Avenue East','Toronto','Ontario','','geetikabida2001@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~12~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~12~1','Parkview 1 (2B)','12','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','12'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','12',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~12~1',1,'Contact','Unit 12 264 Finch Avenue East','Mariam Asif','Unit 12 264 Finch Avenue East','Toronto','Ontario','','mariam_asif@live.co.uk'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~13~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~13~1','Longmore 1|2 (2BF)','13','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','13'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','13',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~13~1',1,'Contact','Unit 13 266 Finch Avenue East','Poh Kuen Wong','Unit 13 266 Finch Avenue East','Toronto','Ontario','','janiceaegold@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~14~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~14~1','Parkview 1 (2B)','14','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','14'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','14',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~14~1',1,'Contact','Unit 14 266 Finch Avenue East','Michelle Eunyoung Park','Unit 14 266 Finch Avenue East','Toronto','Ontario','','eypark94@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~15~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~15~1','Longmore 1|2 (2BF)','15','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','15'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','15',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~15~1',1,'Contact','Unit 15 266 Finch Avenue East','Silu Yang','Unit 15 266 Finch Avenue East','Toronto','Ontario','','Silusnow23@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~16~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~16~1','Parkview 2 (2B)','16','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','16'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','16',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~16~1',1,'Contact','Unit 16 266 Finch Avenue East','Wan Heng Cheng ','Unit 16 266 Finch Avenue East','Toronto','Ontario','','anthony.wan.cheng@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~17~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~17~1','Longmore 1|2 (2BF)','17','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','17'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','17',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~17~1',1,'Contact','Unit 17 268 Finch Avenue East','Barry George Wong','Unit 17 268 Finch Avenue East','Toronto','Ontario','','esson506@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~18~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~18~1','Parkview 1 (2B)','18','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','18'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','18',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~18~1',1,'Contact','Unit 18 268 Finch Avenue East','Yi Guan','Unit 18 268 Finch Avenue East','Toronto','Ontario','','guanyi10000@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~19~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~19~1','Longmore 3|4 (2BF)','19','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','19'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','19',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~19~1',1,'Contact','Unit 19 268 Finch Avenue East','Hong Xu','Unit 19 268 Finch Avenue East','Toronto','Ontario','','hxujob@hotmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~20~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~20~1','Parkview 3 (2B)','20','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','20'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','20',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~20~1',1,'Contact','Unit 20 268 Finch Avenue East','Jianhui Liang','Unit 20 268 Finch Avenue East','Toronto','Ontario','','huihui308@163.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~21~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~21~1','Maxome 3 (2BF)','21','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','21'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','21',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~21~1',1,'Contact','Unit 21 51 Winlock Park','Ruby YanYee Tse','Unit 21 51 Winlock Park','Toronto','Ontario','','rubyt636@gmail.com'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','22'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','22',''); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~23~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~23~1','Maxome 2 (2BF)','23','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','23'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','23',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~23~1',1,'Contact','Unit 23 51 Winlock Park','Hoi Yan Chan','Unit 23 51 Winlock Park','Toronto','Ontario','','yankee3228@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~24~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~24~1','Maxome 1 (2BF)','24','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','24'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','24',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~24~1',1,'Contact','Unit 24 51 Winlock Park','Lily Wong Ma','Unit 24 51 Winlock Park','Toronto','Ontario','','lilywma@gmail.com'); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email, col_Phone1, col_Phone2) values('winlock~24~1',2,'Contact','Unit 24 51 Winlock Park','Stephen Chi Fung Ma','Unit 24 51 Winlock Park','Toronto','Ontario','','lilywma@gmail.com','6263835462','6263835462'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~25~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~25~1','Maxome 2 (2BF)','25','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','25'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','25',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~25~1',1,'Contact','Unit 25 51 Winlock Park','Chi Keung Wong','Unit 25 51 Winlock Park','Toronto','Ontario','','revjwong@gmail.com'); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email, col_Phone1, col_Phone2) values('winlock~25~1',2,'Contact','Unit 25 51 Winlock Park','Chi Yuet Chang','Unit 25 51 Winlock Park','Toronto','Ontario','','revjwong@gmail.com','9055674798','6479393036'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~26~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~26~1','Maxome 2 (2BF)','26','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','26'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','26',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~26~1',1,'Contact','Unit 26 51 Winlock Park','YuenChing Shern','Unit 26 51 Winlock Park','Toronto','Ontario','','wshern2000@yahoo.ca'); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email, col_Phone1, col_Phone2) values('winlock~26~1',2,'Contact','Unit 26 51 Winlock Park','Jeremy G.K. Iu and Tiana ChunKay Shern','Unit 26 51 Winlock Park','Toronto','Ontario','','wshern2000@yahoo.ca','6476690725','6474607030'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~27~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~27~1','Maxome 1 (2BF)','27','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','27'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','27',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~27~1',1,'Contact','Unit 27 51 Winlock Park','Woon Ching Cheung','Unit 27 51 Winlock Park','Toronto','Ontario','','wucaj@yahoo.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~28~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~28~1','Maxome 2 (2BF)','28','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','28'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','28',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~28~1',1,'Contact','Unit 28 51 Winlock Park','S. K. Angela Tang','Unit 28 51 Winlock Park','Toronto','Ontario','','tang.jaja@gmail.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~29~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~29~1','Maxome 1 (2BF)','29','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','29'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','29',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~29~1',1,'Contact','Unit 29 51 Winlock Park','Yong Mei Li','Unit 29 51 Winlock Park','Toronto','Ontario','','593357466@qq.com'); insert into tb_Prospect(col_ID,col_LastName, col_FirstName, col_StatusDate, col_Centre) values('winlock~30~1','Toronto','','','Winlock Towns'); insert into tb_Deal(col_ID, col_Model,col_Lot,col_Phase,col_Status,col_DealDate ,col_ActiveYN,col_Centre) values('winlock~30~1','Maxome 4 (2BF)','30','1','Sold','19000100','Yes','Winlock Towns'); insert into tb_Lot(col_Phase, col_LotClass, col_SalesStatus, col_Centre, col_Lot) values('1','.','Sold','Winlock Towns','30'); insert into tb_SuppLot(col_Phase, col_Centre, col_Lot,col_WarrantyNumber) values('1','Winlock Towns','30',''); insert into tb_Person(col_ID,col_PurchaserNumber, col_Type, col_Salutation, col_Name, col_address, col_City, col_province, col_postal,col_Email) values('winlock~30~1',1,'Contact','Unit 30 51 Winlock Park','Crystal Sin Yee Tse','Unit 30 51 Winlock Park','Toronto','Ontario','','crystaltse1996@gmail.com'); update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='Karenzhu7788@gmail.com' where col_id='winlock~1~1'; update tb_Prospect set col_address='Unit 1 260 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~1~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='850158778@qq.com' where col_id='winlock~2~1'; update tb_Prospect set col_address='Unit 2 260 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~2~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='quazi.s.islam@gmail.com' where col_id='winlock~3~1'; update tb_Prospect set col_address='Unit 3 260 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~3~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='mrodan@mondconsult.com' where col_id='winlock~4~1'; update tb_Prospect set col_address='Unit 4 260 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~4~1'; update tb_Prospect set col_PhoneRes='6478398407', col_PhoneBus='', col_Email='vrodan@mondconsult.com' where col_id='winlock~5~1'; update tb_Prospect set col_address='Unit 5 262 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~5~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='1628064922@QQ.COM' where col_id='winlock~6~1'; update tb_Prospect set col_address='Unit 6 262 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~6~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='realtorjenniferyu@gmail.com' where col_id='winlock~7~1'; update tb_Prospect set col_address='Unit 7 262 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~7~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='irene.zhang@ecescorp.com' where col_id='winlock~8~1'; update tb_Prospect set col_address='Unit 8 262 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~8~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='memo.farzi@gmail.com' where col_id='winlock~9~1'; update tb_Prospect set col_address='Unit 9 264 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~9~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='xin.zhou.xz@gmail.com' where col_id='winlock~10~1'; update tb_Prospect set col_address='Unit 10 264 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~10~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='geetikabida2001@gmail.com' where col_id='winlock~11~1'; update tb_Prospect set col_address='Unit 11 264 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~11~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='mariam_asif@live.co.uk' where col_id='winlock~12~1'; update tb_Prospect set col_address='Unit 12 264 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~12~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='janiceaegold@gmail.com' where col_id='winlock~13~1'; update tb_Prospect set col_address='Unit 13 266 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~13~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='eypark94@gmail.com' where col_id='winlock~14~1'; update tb_Prospect set col_address='Unit 14 266 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~14~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='Silusnow23@gmail.com' where col_id='winlock~15~1'; update tb_Prospect set col_address='Unit 15 266 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~15~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='anthony.wan.cheng@gmail.com' where col_id='winlock~16~1'; update tb_Prospect set col_address='Unit 16 266 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~16~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='esson506@gmail.com' where col_id='winlock~17~1'; update tb_Prospect set col_address='Unit 17 268 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~17~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='guanyi10000@gmail.com' where col_id='winlock~18~1'; update tb_Prospect set col_address='Unit 18 268 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~18~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='hxujob@hotmail.com' where col_id='winlock~19~1'; update tb_Prospect set col_address='Unit 19 268 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~19~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='huihui308@163.com' where col_id='winlock~20~1'; update tb_Prospect set col_address='Unit 20 268 Finch Avenue East', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~20~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='rubyt636@gmail.com' where col_id='winlock~21~1'; update tb_Prospect set col_address='Unit 21 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~21~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='' where col_id='winlock~22~1'; update tb_Prospect set col_address='Unit 22 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~22~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='yankee3228@gmail.com' where col_id='winlock~23~1'; update tb_Prospect set col_address='Unit 23 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~23~1'; update tb_Prospect set col_PhoneRes='6263835462', col_PhoneBus='', col_Email='lilywma@gmail.com' where col_id='winlock~24~1'; update tb_Prospect set col_address='Unit 24 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~24~1'; update tb_Prospect set col_PhoneRes='6479393036', col_PhoneBus='', col_Email='revjwong@gmail.com' where col_id='winlock~25~1'; update tb_Prospect set col_address='Unit 25 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~25~1'; update tb_Prospect set col_PhoneRes='6474607030', col_PhoneBus='', col_Email='wshern2000@yahoo.ca' where col_id='winlock~26~1'; update tb_Prospect set col_address='Unit 26 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~26~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='wucaj@yahoo.com' where col_id='winlock~27~1'; update tb_Prospect set col_address='Unit 27 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~27~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='tang.jaja@gmail.com' where col_id='winlock~28~1'; update tb_Prospect set col_address='Unit 28 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~28~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='593357466@qq.com' where col_id='winlock~29~1'; update tb_Prospect set col_address='Unit 29 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~29~1'; update tb_Prospect set col_PhoneRes='', col_PhoneBus='', col_Email='crystaltse1996@gmail.com' where col_id='winlock~30~1'; update tb_Prospect set col_address='Unit 30 51 Winlock Park', col_City='Toronto', col_Province='Ontario', col_PostalCode='' where col_id='winlock~30~1';