ADD SAMPLE DATA TO CUSTOMERCONTACT TABLE

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100001, 525000000001, 20211, 18, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘A9A 9A9’, 4164529876, 4164526789, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100002, 525000000002, 30001, 11, ‘ELM ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘Z8Z 8Z8’, 4168745412, 4168749658, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100003, 525000000003, 301, 248, ‘SHEPPARD AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M3M 8Z8’, 4168745847, 4168745848, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100004, 525000000004, 20123, 1111, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘Z8Z 8C0’, 4168744859, 4168744852, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100005, 525000000005, 30005, 121, ‘VICTORIA PARK AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘N9N 8Z8’, 4168744563, 4168749652, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100006, 525000000006, 30021, 421, ‘WARDEN AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘V7V 8Z8’, 4168745147, 4168749741, NULL);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100007, 525000000007, 2201, 181, ‘BLOOR ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M8M 8Z8’, 4168745852, 4168749258, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100008, 525000000008, 2110, 748, ‘BLOOR ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M8M 8Z8’, 4168749632, 4168736958, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100009, 525000000009, 30110, 854, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘Z8Z 8Z8’, 4168754612, 4168456658, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100010, 788000000001, 20001, 111, ‘SPADINA AV’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘V7B 8Z8’, 4168747892, 4168747538, NULL);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100011, 788000000002, 22014, 411, ‘COLEGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘C8Z V7B’, 4168798712, 4168795158, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100012, 788000000003, 30141, 115, ‘DUNDAS ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M9K 8Z8’, 4168123412, 4168735758, NULL);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100013, 788000000004, 11425, 181, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘E8Z 0H7’, 4168963412, 4168715958, ‘[email protected]’);

 

INSERT INTO CUSTOMERSCONTACT (CONTACTID, CUSTOMERID, UNIT#, STREET#, STREETNAME, CITY, PROVINCE, COUNTRY, POSTALCODE, PHONE#, ALTERNATIVEPHONE#, EMAIL)

VALUES (10001000100014, 788000000005, 11251, 1771, ‘YONGE ST’, ‘TORONTO’, ‘ONTARIO’, ‘CANADA’, ‘M8J 8Z8’, 4168741472, 4168742658, NULL);