CREATE table #Obra ([Id_obra] int, [Obra] varchar(30)) ; ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

CREATE table #Obra
    ([Id_obra] int, [Obra] varchar(30))
;
CREATE table #Contato
    ([Id_contato] int, [Id_obra] int, [Id_cargo] varchar(30), [ContatoNome] varchar(120), [DDD] varchar(30), [Telefone] varchar(30), [DDDFax] varchar(30), [FAX] varchar(30),[Email] varchar(255),[Id_empresa] int)
;

INSERT INTO #Contato
     ([Id_contato],[Id_obra],[Id_cargo],[ContatoNome],[DDD],[Telefone],[DDDFax],[FAX],[Email],[id_empresa])

VALUES

(64,26,14,'Washington Luis da Silva','21','2644-4585','21','2637-8239','',42),
(89,26,92,'Washington Luis da Silva','21','2644-4585','21','2637-8239','',42),
(90,26,78,'Reginaldo da Cunha Dias','21','2644-4585','21','2637-8239','',42),
(91,26,20,'Gilberto','21','9998-0429','21','2637-8239','',42),
(163,73,20,'Claudete Martins','47','3326-4090','47','3326-4090','',63),
(167,74,20,'Maria Elisa/Pedro Cavalcante','81','3231-5088','81','3222-4022','',117),
(317,138,16,'Andres V. Grana','11','9231-3213','11','4191-6160','',88),
(318,138,123,'Sandro Bontempo','11','4191-6834','11','4191-6160','',88),
(319,138,20,'Engª Daniela','11','4191-6834','11','4191-6160','',88),
(320,139,1,'Ricardo','51','3326-9477','51','Ramal 105','',151),
(321,139,20,'Diogo','51','3326-9477','51','Ramal 105','',151),
(10333,139,20,'Itamar','51','3288-7285','51','3288-7330','',3374),
(324,141,123,'Gerardo Sanches','19','3471-3600','19','3471-3699','',159),
(325,141,122,'Elizabete','19','3471-3600','19','3471-3699','',159),
(617,287,20,'César','48','229-1684','48','229-1684','',273),
(979,432,21,'Rosângela de Medeiros Faria','61','426-5763','61','426-5711','',124),
(980,432,33,'José Mário Miranda Abdo','61','426-5763','61','426-5711','',124),
(981,432,20,'Alan Souza (dep. de Licitação)','61','426-5763','61','426-5711','',124),
(982,432,20,'Celso Charneca','21','3814-4477','21','3814-4787','',221),
(1077,479,16,'Arlindo','21','3351-6285','21','3351-6285','',438),
(1078,479,49,'Pedro Luiz G. de Oliveira','21','3351-6285','21','3351-6285','',438),
(1127,508,20,'Hudson (licitação)','22','2768-9300','22','2768-9367','',460),
(4890,535,16,'Grace Correia','21','2240-8797','21','2524-9464','',484),
(4891,535,49,'Engº Thaís Elizabeth L. deA. Andreiollo','21','2240-8797','21','2524-9464','',484),
(4892,535,20,'Michele','21','2240-8797','21','2524-9464','',484),
(1530,691,16,'Ludo Ludwig Rolfkoether','11','3088-8100','11','3088-8100','',697),
(1531,691,92,'Silvio Kozuchowicz','11','3088-8100','11','3088-8040','',697),
(1532,691,20,'Fabiana','11','3088-8100','11','3088-8040','',697),
(1533,692,16,'Roberta Rodrigues','11','3595-7944','11','3595-7939','roberta@stuhlberger.com.br',388),
(1534,692,92,'Reinaldo','11','3595-7944','11','3595-7939','',388),
(1535,692,20,'Roberta Rodrigues','11','3595-7944','11','3595-7939','roberta@stuhlberger.com.br',388),
(1784,793,21,'Antônio Godoy','65','627-7034','65','627-3940','',767),
(13177,793,20,'Silvia Godoy','65','627-7034','65','627-3940','',767),
(2008,892,16,'Engª Gina','11','5908-8555','11','5908-8555','construtoracordoba@uol.com.br',882),
(2009,892,49,'Gérson Dutra','11','5908-8555','11','5908-8555','',882),
(2010,892,20,'Roseli Justino','11','5908-8555','11','5908-8555','',882),
(2306,995,20,'Engº Eliseu','47','335-0033','47','335-0033','',968),
(2307,995,20,'Dimas (dir. Adm.)','55','3744-2300','55','3744-2300','',962),
(3359,1454,20,'Luis Bonfim da Silva (sindico)','71','386-6459','71','386-1605','',1357),
(3362,1454,20,'Cleunice','71','312-5222','71','312-5222','',1422),
(13569,1454,21,'Hari (proprietário)','71','312-5222','71','312-5222','',1422),
(3454,1492,92,'Gilmar Fonseca Lins','11','3604-4700','11','4538-3725','',1445),
(3455,1492,20,'Gilmar Fonseca  / Roberto','11','3604-4700','11','4538-3725','',1445),
(3500,1492,16,'Heitor Ducci/Gilmar Fonseca','11','3604-4700','11','4538-3725','',1445),
(13391,1492,20,'Engº José Carlos Masí','11','3259-2277','11','3259-9572','',1448),
(3512,1521,20,'Delvo - (Indústria e Comércio)','35','3851-8018','35','3851-1929','',1509),
(3513,1521,20,'Luiz Gustavo Miranda (Minas Ecofish)','35','3851-8000','35','3851-8000','',1509),
(4144,1786,16,'José Cícero','11','3077-1166','11','3077-1160','',363),
(4145,1786,20,'Isabel','11','3077-1166 - R: 221','11','3077-1160','',363),
(24144,1786,49,'Engª Mônica','11','3077-1166','11','3077-1160','',363),
(4441,1930,92,'Caliu','32','3690-7403','32','3690-7665','',1765),
(4664,2031,16,'Fábio','11','3847-9999','11','3842-5453','compras@dialogo.com.br',307),
(4665,2031,49,'Engª Christyane','11','3847-9999','11','3847-5453','',307),
(4666,2031,20,'Kelly - (Engenharia)','11','3847-9999','11','3842-5453','',307),
(4751,2066,20,'Nice - (esposa)','11','3858-5877','   ','','',1864),
(4940,2144,20,'Maurício Gonçalves','31','3250-1607','31','3250-1670','',206),
(5195,2268,20,'Luis Fabiane','43','3379-5000','43','3379-5005','luisfabiane@graunaconstrucoes.com.br',1956),
(6770,2916,16,'Francisco Antônio Garcia Zoldan','19','3252-9999','19','3252-9999','',2363),
(6771,2916,51,'Francisco Antônio Garcia Zoldan','19','3252-9999','19','3252-9999','',2363),
(6772,2916,92,'Francisco Antônio Garcia Zoldan','19','3252-9999','19','3252-9999','',2363),
(6773,2916,20,'Patrícia','19','3256-2870','19','3252-9999','',2363),
(7564,3253,20,'Luciene','81','3527-1593','81','3527-1297','',2476),
(7565,3253,51,'Engº Roberto Borges - (81) 3327-1668','81','3527-1437','81','3464-1200','',57),
(7569,3255,92,'Edgard Corona','11','3365-0800','11','3365-0800','',2601),
(7570,3255,20,'Érica','11','3365-0800','11','3365-0800','',2601),
(7957,3446,16,'Vicente Paulo de Souza','11','4586-2602','11','4586-2251','',2764),
(7958,3446,51,'Engº João Batista','11','4586-2602','11','4586-2251','',2764),
(7959,3446,20,'Rafael M. Pereira','11','4582-6479','11','4586-2251','',2764),
(7960,3446,49,'Vicente Paulo de Souza (Engº administrativo)','11','4586-2602','11','4586-2251','',2764),
(9062,3910,92,'Engº Silvio','11','5589-6000','11','5589-6539','',800),
(9063,3910,16,'Lúcia / Selma','11','5589-6000','11','5589-6539','',800),
(9064,3910,20,'Erineu','11','5012-7331','11','5589-6539','',800),
(10457,4445,92,'Ângela                                 ','11','3291-1800','11','3291-1811','',1069),
(10458,4445,16,'Ângela - (Engenharia) / Milton','11','3291-1800','11','3291-1811','',1069),
(10459,4445,20,'André','11','3291-6200','11','3291-1811','',1069),
(10460,4445,49,'Fábio','11','3291-1800','11','3291-1811','',1069),
(10607,4508,20,'Silvia Pires','11','4228-2964','11','4228-4783','',3433),
(10608,4508,7,'Silvia Pires','11','4228-2964','11','4228-4783','',3433),
(10609,4508,14,'Silvia Pires','11','4228-2964','11','4228-4783','',3433),
(11312,4791,49,'Carlos Alberto Xavier/ Paulo Benjamim','48','241-1107','48','241-1107','',3435),
(11314,4791,16,'Lauro Luiz Chaves','48','241-1107','48','241-1107','',3435),
(11315,4791,20,'Carlos Alberto','48','3241-1107','48','3241-1107','',3435),
(11961,5058,92,'José Luiz Hirota','11','5081-9999','11','5081-9988','costahirota@costahirota.com.br',368),
(11962,5058,16,'Sra. Juraci dos Santos','11','5081-9999','11','5081-9988','juraci@costahirota.com.br',368),
(11963,5058,20,'Engº Francis Solane','11','5081-9999','11','5081-9988','costahirota@costahirota.com.br',368),
(13229,5568,20,'Engº Osvaldo','19','3526-8031','19','3224-7791','',3999),
(13233,5569,20,'Gilson ','51','473-0986','51','473-4475','',4638),
(13234,5569,92,'Arqº Ronaldo Taim Cândido dos Santos','51','473-0986','51','473-4475','',4638),
(19420,5569,16,'Álvaro Júnior','51','473-0986','51','473-4475','',4638),
(13253,5577,16,'Engº Orlando Menezes','11','3531-7476','11','3531-7465','orlando.menezes@oas.com',7614),
(13254,5577,49,'Engº Mário Tining','11','5090-9130','11','5090-9130','',4003),
(13255,5577,20,'Olívia','11','5090-9309','11','5090-9309','',4003),
(46324,5577,70,'Rogério','11','3531-7476','11','3531-7465','',7614),
(13256,5578,20,'Cristian Roberto - (Orçamento)','16','3632-9636','16','3632-9636','criroberto@uol.com.br',4005),
(13257,5578,20,'Cristian Roberto','16','3632-9636','16','3632-9636','',4005),
(13258,5578,49,'Luis Gustavo Leonel','16','3632-9636','16','3632-9636','',4005),
(13259,5578,49,'Milton Moreira Filho','17','3214-7200','17','3214-7201','',675),
(13305,5599,49,'José Mauro B. Freitas','21','2671-0464','21','2671-0464','',3438),
(13306,5599,16,'José Mauro B. Freitas','21','2671-0464','21','2671-0464','',3438),
(13307,5599,20,'Emerson Santos da Costa','21','2671-0464','21','2671-0464','',3438),
(13308,5600,16,'Oscar Aquino','19','3887-1878','19','3887-1878','',4013),
(13309,5600,20,'Natal','19','3887-1878','19','3887-1878','',4013),
(13957,5848,49,'Ivan Pimenta Fattori','21','2622-4016','21','2622-4016','',2684),
(13958,5848,16,'Marcelo Andrade','21','2622-4016','21','2622-4016','',2684),
(13959,5848,20,'Severino Lima','21','2622-4016','21','2622-4016','',2684),
(14360,6002,7,'Frederico Petraglia','21','2491-3634','21','3431-3634','',4232),
(14361,6002,16,'Frederico Petraglia','21','2491-3634','21','3431-3634','',4232),
(14362,6002,20,'Anderson Santos','21','2491-3634','21','3431-3634','',4232),
(14733,6149,49,'Narcélio','85','3260-5156','11','3260-5156','narcelio@alphaville.com.br',1594),
(14734,6149,16,'Vandecy Reis','85','3260-5176','85','3260-5075','vandecy@alphaville.com.br',1594),
(14735,6149,20,'Narcélio','85','3260-5156','85','3260-5156','narcelio@alphaville.com.br',1594),
(14736,6150,49,'Rogério Brito','27','2127-4307','11','4197-1900','alphaville@alphaville.com.br',1594),
(14737,6150,20,'Rogério Brito','27','2127-4307','11','4197-1900','alphaville@alphaville.com.br',1594),
(52288,6150,16,'Depto de Suprimentos','27','2127-4368','27','2127-4307','compras@alphaville.com.br',1594),
(15117,6304,20,'Riden Costa','69','216-3700','69','216-3700','',4411),
(15119,6304,1,'Márcio Brasil - (Presid. CPL)','69','216-3700','69','216-3700','',4411),
(15129,6308,49,'Pedro Luiz G. de Oliveira','21','3351-6285','21','3351-6285','',438),
(15130,6308,16,'Pedro Luiz G. de Oliveira','21','3351-6285','21','3351-6285','',438),
(15131,6308,20,'Moacir Duarte','21','3351-6285','21','3351-6285','',438),
(15139,6311,16,'Arq. Marcos César dos Santos Barbosa','21','2487-8347','21','2487-8347','marcosbarbosarq@bol.com.br',772),
(15140,6311,20,'Aloisio Gomes da Silva','21','2487-8347','21','2487-8347','',772),
(15148,6315,16,'Marcelo Quintas','81','3087-8000','81','3087-8056','compras@mouradubeux.com.br',898),
(15149,6315,20,'José Silva','81','3325-1823','81','3087-8056','',898),
(25735,6315,49,'Flávio Comata','81','3087-8000','81','3087-8056','doloresmoura@mouradubeux.com.br',898),
(15150,6316,16,'Charles','81','3325-8000','81','3325-8056','compras@mouradubeux.com.br',898),
(15151,6316,20,'Eduardo','81','3302-5920','81','3325-8056','',898),
(25916,6316,49,'Eduardo','81','3325-8000','81','3325-8056','',898),
(15152,6317,49,'Carlos Roberto','79','216-5000','79','216-5095','',427),
(15153,6317,16,'Roberto Silva','79','216-5000','79','216-5095','',427),
(15154,6317,20,'Mauro Rêgo','79','9978-5033','79','216-5000','',427),
(15155,6318,16,'Charles','81','3325-8000','81','3325-8056','compras@mouradubeux.com.br',898),
(15156,6318,20,'Daniel','81','3302-5929','81','3325-8056','',898),
(25732,6318,49,'Flávio Comata','81','3325-8000','81','3325-8056','',898),
(15157,6319,16,'Alexandre/Amaro','81','3325-8000','81','3325-8056','compras@mouradubeux.com.br',898),
(15158,6319,20,'Ana','81','3302-5917','81','3325-8056','',898),
(32567,6348,20,'Marlon Sena Goes','75','3421-7512','75','3421-2233','',7883),
(32568,6348,21,'Dionísio Striquer','75','3421-7512','75','3421-2233','',7883),
(16937,7004,20,'Marco A. Moreno','16','3712-2020','16','3712-2000','',1710),
(17090,7070,16,'Ana Luzia','27','2121-7508','27','2121-7575','',3190),
(17091,7070,49,'Antônio Tadeu Fachetti','27','2121-7575','27','2121-7575','',3190),
(17092,7070,20,'Gelson','27','2121-7575','27','2121-7575','hortifruti@hortifruti.com.br',3190),
(17577,7247,20,'Gabriel Neves Neto','81','3268-4149','81','3268-1972','gabriel@castronevesconstrutora.com.br',4945),
(17578,7247,49,'Gabriel Neves Neto','81','3268-3792','81','3268-4149','gabriel@castronevesconstrutora.com.br',4945),
(17579,7247,16,'André Gustavo','81','3268-4149','81','3268-1972','cnc2000@hotmail.com.br',4945),
(18308,7520,16,'Gilberto Schwartz','41','349-0130','41','349-0130','',5104),
(18309,7520,49,'Ricardo Rosa/Gilberto Schwartz','41','357-0268','41','357-0268','',5104),
(18310,7520,20,'Ricardo Rosa Reis','41','357-0268','41','357-0268','',5104),
(18340,7537,16,'Nelson Pereira de Paula','61','3963-1111 - R205','61','3963-1111','nelson@silcoengenharia.com.br',2453),
(18341,7537,49,'Leonardo Guerra','61','3963-1111','61','3963-1111','',2453),
(18342,7537,20,'Glaudeci','61','3963-1111','61','3963-1111','',2453),
(19022,7806,49,'Engº Murilo Alves Dantas','11','3872-0122','11','3872-0122','',5251),
(19023,7806,16,'Ricardo Lemos','11','3872-0122','11','3872-0122','',5251),
(19024,7806,20,'Ricardo Lemos','11','3872-0122','11','3872-0122','',5251),
(19025,7807,49,'Restrito','11','4538-4621','   ','','',5252),
(19026,7807,16,'Paulo Sérgio Lúcio','11','4538-4621','   ','','',5252),
(19027,7807,20,'Guilherme','11','4538-4621','   ','','',5252),
(20125,8251,16,'Ramiro Fernandes','11','4153-7189','11','4153-7189','',5500),
(20126,8251,20,'Alexandra','11','4153-7189','11','4153-9945','',5500),
(20127,8251,7,'Ramiro Fernandes','11','4153-7189','11','4153-7189','',5500),
(20248,8301,49,'Aldo Gazoni','11','4221-6363','11','4221-6363','',5520),
(20249,8301,16,'Ana Maria A. Gomes','11','4221-6363','11','4221-6363','abraham.gazoni@terra.com.br',5520),
(20250,8301,20,'Luciana','11','4221-6363','11','4221-6363','',5520),
(20251,8301,7,'Cledenor Filho','11','5084-4460','','','',5523),
(20326,8336,49,'Engº Felippo','11','3512-4500','11','3512-4503','',1504),
(20327,8336,16,'Gustavo Drumond','11','3512-4500','11','3512-4503','suprimentossp@mrv.com.br',1504),
(20329,8336,20,'Rui','11','5846-0753','11','3512-4503','',1504),
(20332,8338,49,'Fernando Vieira','31','3348-7101','31','3348-7101','',3009),
(20333,8338,16,'Fernando / Amarildo','31','3348-7101','31','3348-7219','',3009),
(20334,8338,20,'Luciano','31','3348-7170','31','3348-7101','',3009),
(20355,8349,49,'Engº Érica','81','3228-5318','81','3467-2419','',5545),
(20356,8349,16,'Simone / Nivaldo','81','3228-5318','81','3467-2419','',5545),
(20357,8349,20,'Simone','81','3228-5318','81','3467-2419','',5545),
(21616,8892,16,'Hugo','48','3624-2208','48','3624-2208','',5859),
(21617,8892,49,'Paulo Fogaça','48','3624-2208','48','3624-2208','',5859),
(21618,8892,20,'Lucas Neves','48','3322-0944','48','3624-2208','',5859),
(21762,8958,77,'Alexandre','11','5087-3400','11','5087-7033','',4707),
(21763,8958,20,'Benedito Lima','71','3379-9919','71','3379-9919','',4707),
(22381,9238,16,'Márcio Grigolon','11','4502-3000','11','4502-3321','marcio.grigolon@cyrela.com.br',1),
(22382,9238,20,'Maria Luiza Zarro','21','3206-5474','21','2274-6831','marialuizazarro@rjzcyrela.com.br',1598),
(28050,9269,20,'Felix Caon (Dir. Unidade)','21','2132-7900','21','2132-8089','cmsa@cmsa.com.br',4631),
(22617,9351,16,'Rovilson','41','3226-5450','41','3226-1143','',6282),
(26409,9351,50,'Dalgoberto','44','3226-5450','44','3226-1143','',6282),
(23347,9685,49,'Engº Ricardo E. Z. Bias','21','2447-9696','21','2447-9696','',4893),
(23348,9685,16,'Setor Compras','21','2447-9696','21','2447-9696','contato@blasengenharia.com.br',4893),
(23349,9685,20,'Kátia Costa','21','2447-9696','21','2425-1564','',4893),
(86359,9766,20,'Renato Gimenez (Jurídico)','11','3531-3030 R:3139','','','renato.gm@pch.com.br',3975),
(23705,9822,16,'João Paulo P. Prado','13','9716-5329','','','',6292),
(23706,9822,20,'João Paulo P. Prado','13','9716-5329','','','',6292),
(23836,9874,49,'Marcos Miyazi','13','3491-4937','13','3491-4979','',3307),
(23837,9874,16,'Marcos Miyazi','13','3491-4937','13','3491-4979','miyazi@miyazi.com.br',3307),
(23838,9874,20,'Walter','13','3491-4937','13','3491-4979','',3307),
(23841,9875,49,'Engº Marcos Coimbra','27','2121-2900','27','2106-2110','',4980),
(23842,9875,16,'Eduardo','71','2106-2900','71','2106-2110','',4980),
(29170,9875,20,'Cida Caruso - (Comunicação)','11','2131-2900','11','2131-2900','',4981),
(23978,9925,49,'Arq. Sérgio Dib','21','2487-8056','21','7838-4853','',1037),
(23979,9925,16,'Arq. Sérgio Dib','21','2487-8056','21','7838-4853','',1037),
(23980,9925,20,'Adilson Moraes','21','2487-8056','   ','','',1037),
(24095,9981,20,'Carlos - (Licitação)','41','3330-3636','41','3330-3344','',463),
(24582,10163,49,'Milton Paraguassú','51','3025-7000','51','3025-7000','',1026),
(24583,10163,16,'Seno Luiz dos Santos','51','3025-7000','51','3025-7000','luiz@goldsztein.com.br',1026),
(24586,10163,20,'Vera Silveira','51','3382-7081','51','3025-7000','',1026),
(24611,10176,49,'Elcio Campos','81','3495-0005','81','3495-0005','',7531),
(30272,10176,3,'Luís Tadeu','81','3495-0005','81','3495-0005','',7531),
(30273,10176,20,'Gilda','81','3495-0005','81','3495-0005','',7531),
(24615,10179,20,'Sra. Antônia','11','3207-3207','11','3253-2380','engenharia@fioresifernandes.com.br',2018),
(30449,10179,16,'Lucilaine de Melo Silva','11','3253-2380','11','3253-2380','',2018),
(30450,10179,49,'Fernando Rossi Fernandes','11','3253-2380','11','3253-2380','',2018),
(30683,10301,21,'Laercio Mazzo','21','2528-4902','21','2528-2119','',1237),
(37020,10301,20,'Aroldo B. Ricardo','21','2528-5520','21','2528-2119','',1237),
(25082,10359,49,'Renata Queiroz de Sabrit','11','3746-0100','11','3746-0100','',6551),
(25083,10359,16,'Renata Queiroz de Sabrit','11','3746-0100','11','3746-0100','renata@bulltick.com',6551),
(25084,10359,20,'Renata Queiroz de Sabrit','11','3746-0100','11','3746-0100','',6551),
(25105,10363,16,'Donizzetti','61','3322-0808','61','3321-1277','',2999),
(25107,10363,49,'Alcy Melo Ribeiro Júnior','61','3361-1031','61','3321-1277','',2999),
(25108,10363,20,'Alcy Melo Ribeiro Júnior','61','3361-1031','61','3321-1277','',2999),
(25544,10537,20,'Rosângela - (Licitação)','12','3947-8000','12','3947-8540','',502),
(38134,10537,49,'Roberto Koshiama','11','6261-5808','','','ecg@cti.com.br',1990),
(38135,10537,49,'João','12','3947-8000','12','3947-8540','',502),
(25587,10553,49,'Leandro Martins','62','3095-2855','62','3095-2855','',6693),
(25588,10553,16,'Humberto Ferreira','62','3095-2855','62','3095-2855','aurea@aureaengenharia.com.br',6693),
(25589,10553,20,'Leandro Martins','62','3095-2855','62','3095-2855','',6693),
(25646,10582,49,'Kleber Gomide','11','4038-4340','11','4038-4340','',6697),
(25647,10582,16,'Kleber Gomide','11','4038-4340','11','4038-4340','kleber_gomide@yahoo.com.br',6697),
(25648,10582,20,'Kleber Gomide','11','4038-4340','11','4038-4340','',6697),
(26673,11001,16,'Eliana Borges','11','3291-7333','11','3291-7333','compras@zappi.com.br',3034),
(26674,11001,20,'Valter Cordeiro','11','6607-4789','11','3291-7333','',3034),
(36194,11001,49,'Márcio Irai','11','6607-4789','11','3291-7333','',3034),
(27352,11256,20,'Aline','11','2187-2296','11','2187-2296','',5660),
(27353,11256,21,'Jorge Vital','11','2187-2296','11','2187-2296','',5273),
(27476,11301,20,'Vincenzo Mário Galluzzi','11','3388-6186','11','3329-9397','',441),
(28289,11590,49,'Sra. Ligia Sein','11','3256-8722','','','ligia@evidencebrasil.com.br',2226),
(28290,11590,16,'Osvaldo Wagner Fernando Filho','11','3259-8982','11','3257-3772','compras@liderbrasil.com.br',2226),
(28291,11590,20,'Sra. Ligia Zein','11','3256-8722','','','ligia@evidencebrasil.com.br',2226),
(28451,11660,49,'Henrique Alvarez','31','3074-4400','31','3291-9053','',1604),
(28452,11660,16,'Maurício / Tarcísio','31','3074-4400','31','3290-4334','tarcisio@lider.com.br',1604),
(28453,11660,20,'Flávia - (Comunicação)','31','3074-4400','31','3291-9053','',1604),
(28800,11782,49,'Engº Luiz Cláudio Cedro','22','2645-5656','22','2645-2435','',5188),
(28801,11782,16,'Arq. Maria Yara Coelho','22','2645-5656','22','2645-2435','yaracoelho@volendam.com.br',5188),
(28802,11782,20,'Sr. José Roberto','22','2645-5656','22','2645-2435','',5188),
(29529,12051,16,'Dr. Antônio de Paula','83','9971-7682','','','',7421),
(29530,12051,49,'Engº Antônio de Paula Porto Vasconcelos','83','9971-7682','','','',7421),
(29809,12166,20,'Arqº Carlos Roberto Pará','11','5549-1835','','','',7475),
(29810,12166,16,'Arqº Carlos Roberto Pará','11','5549-1835','','','',7475),
(30247,12314,49,'Sr. Pedro Carvalho de Vasconcelos','12','3911-2733','12','3911-2733','',7530),
(30249,12314,16,'Eli Carlos','12','3911-2733','12','3911-2733','opera@operaconstrutora.com.br',7530),
(30250,12314,20,'Sr. Capelis','12','3911-2733','12','3911-2733','opera@operaconstrutora.com.br',7530),
(31699,12842,16,'Alexandre','85','3235-6257','85','3235-6257','',6371),
(31700,12842,49,'João','85','3235-6257','85','3235-6257','',6371),
(31701,12842,20,'Elaine','85','3235-6257','85','3235-6257','',6371),
(31729,12853,16,'Marcos Bertoloto','19','3267-3621','','','',7766),
(31730,12853,20,'Marcos Bertoloto','19','9613-0961','','','',7766),
(31915,12928,49,'Engº Euclides Silva Neto','21','2637-2783','21','9998-6156','',4043),
(31916,12928,16,'Engº Euclides Silva Neto','21','2637-2783','21','9998-6156','',4043),
(31917,12928,20,'Ewerton Joaquim da Silva','21','2637-2783','21','2637-2783','',4043),
(32070,12981,20,'Danila Quirino','11','3812-9551','','','ggl_006.lojasamericanas@lasa.com.br',7791),
(32699,13220,49,'Engª Marcela','27','3227-6687','27','3227-6687','',7900),
(32700,13220,16,'Edivan','27','3227-6687','27','3227-6687','edivan@impacto.eng.br',7900),
(32701,13220,20,'Sandra Udison Carlesso','27','3227-6687','27','3227-6687','',7900),
(32702,13221,49,'Engº Marcelo Gobbo Figueiredo','27','3227-6687','27','3227-6687','marcelo@impacto.eng.br',7900),
(32703,13221,16,'Edivan Moreira','27','3227-6687','27','3227-6687','compras@impacto.eng.br',7900),
(32704,13221,20,'Sandro Udison Carlesso','27','3227-6687','27','3227-6687','',7900),
(32876,13293,16,'Engº Luiz Carlos de A. Neves','21','2693-0025','21','9156-4326','',4429),
(32877,13293,49,'Engº Luiz Carlos de A. Neves','21','2693-0025','21','9156-4326','',4429),
(32878,13293,20,'Eng. Luiz Carlos','21','2693-0025','21','9156-4326','',4429),
(32884,13295,16,'Ananias','16','3667-3794','16','3667-3763','',7932),
(32885,13295,49,'Gilmar','16','3667-3794','16','3667-3763','',7932),
(32886,13295,20,'Ananias','16','3667-3794','16','3667-3763','',7932),
(32911,13304,49,'Marcelo Judici','27','3225-2700','27','3225-2700','quintelatorres@quintelatorres.com.br',7924),
(32912,13304,16,'Saulo Xavier','27','3225-2700','27','3225-2700','compras@quintelatorres.com.br',7924),
(32913,13304,20,'Felipe','27','3225-2700','27','3225-2700','engenharia2@quintelatorres.com.br',7924),
(32925,13308,49,'Engº Marco Aurélio','27','9272-8102','27','3325-3544','abaurre@abaurre.com.br',7941),
(32926,13308,16,'Marcio Abaurre','27','3325-3544','27','3325-3544','abaurre@abaurre.com.br',7941),
(32927,13308,20,'Engº Marco Aurélio','27','9272-8102','27','3325-3544','abaurre@abaurre.com.br',7941),
(32937,13312,49,'Engº Luis Roberto da Silva','15','3233-4740','15','3212-4758','',7942),
(32938,13312,49,'Engº Carlos Alberto Vadime Lucas','15','3233-4740','15','3212-4758','',7942),
(32939,13312,16,'Antônio Alberto de Souza','15','3233-4740','15','3212-4758','obra@proest.com.br',7942),
(32940,13312,20,'Lia','15','3233-4740','15','3212-4758','',7942),
(32947,13315,16,'Wagner','11','5080-6090','11','5575-5451','',7943),
(32948,13315,49,'Luís','11','5080-6090','11','5575-5451','',7943),
(32949,13315,20,'Wagner','11','5080-6090','11','5575-5451','',7943),
(32950,13316,16,'Paulo','14','3733-1999','14','3733-1999','',7930),
(32951,13316,49,'José Arten Júnior','14','9661-3933','14','3733-1999','',7930),
(32952,13316,20,'Júnior','14','9661-3933','14','3733-1999','',7930),
(32954,13318,16,'Denizio','11','7819-2760','11','6165-2564','c_souza@dicico.com.br',5559),
(32955,13318,20,'Celso Carlos de Souza - (Dir. Executivo de Obras)','11','7836-5124','11','6165-2500','c_souza@dicico.com.br',5559),
(33046,13354,7,'Arq. Marcos Auderi da Mota','22','9975-4041','','','',7970),
(33047,13354,16,'Arq. Marcos Auderi da Mota','22','9975-4041','','','',7970),
(33048,13354,20,'Arq. Marcos Auderi da Mota','22','9975-4041','','','',7970),
(33074,13367,49,'Joaquim Augusto Ribeiro (Berá)','18','9723-2381','18','3908-5332','',6879),
(33083,13369,16,'Cláudio / Sérgio','19','3253-2215','19','3253-2215','',7154),
(33084,13369,49,'Sérgio','19','3253-2215','19','3253-2215','',7154),
(33085,13369,20,'Maura','19','3253-2215','19','3253-2215','',7154),
(33123,13385,49,'Engº Fernando Lara','51','3227-2233','51','3227-2233','',5268),
(33124,13385,16,'César','51','3227-2233','51','3227-2233','cesar@dhz.com.br',5268),
(33125,13385,20,'Patrícia','51','3227-2233','51','3227-2233','',5268),
(33137,13391,20,'Urbano Pato - (Secretaria do Meio Ambiente)','12','3922-3352','12','3922-3352','',502),
(33143,13395,16,'Engº José Marcos Severo Martins','11','3875-0860','11','3875-6054','ivo-cam@uol.com.br',7521),
(33144,13395,49,'Engº José Marcos Severo Martins','11','3875-0860','11','3875-6054','aloimartins@uol.com.br',7521),
(33145,13395,20,'Everton - (Técnico)','11','3875-0860','11','3875-6054','aloimartins@uol.com.br',7521),
(33234,13429,16,'Jussara Gonçalves','13','3561-1922','','','',7990),
(33235,13429,20,'Jussara Gonçalves','13','3561-1922','','','',7990),
(33246,13434,16,'Irineu','83','3224-4805','83','3224-4805','',7986),
(33247,13434,49,'Sérgio Marcos Lacerda Filho','83','3224-4805','83','3224-4805','',7986),
(33248,13434,20,'João Beltrão','83','3224-4805','83','3224-4805','',7986),
(33249,13434,49,'Augusto César Timóteo de Oliveira','83','3224-4805','83','3224-4805','',7986),
(33521,13525,20,'Engº Everton Peres','11','4163-6940','11','4193-4500','',8055),
(33522,13525,16,'Patricia','11','4193-4500','11','4193-4500','compras@construtoravinocur.com.br',8055),
(33523,13525,49,'Engº Bravan','11','4163-6940','11','4193-4500','',8055),
(33524,13526,20,'Thiago Correia de Barros','82','3359-2244','82','3359-2244','',8056),
(33525,13526,16,'Thiago Correia de Barros','82','3359-2244','82','3359-2244','araujobarrosconstrucoes@hotmail.com',8056),
(33526,13526,49,'Thiago Correia de Barros','82','3359-2244','82','3359-2244','',8056),
(33586,13551,49,'Vladimir Menezes','71','3341-1336','71','3341-1336','',3896),
(33587,13551,16,'André Luiz Guimarães','71','3341-1336','71','3341-1336','',3896),
(33588,13551,20,'Sra. Juciara','71','3341-1336','71','3341-1336','',3896),
(33670,13581,16,'Sr. Sérgio','21','2220-7879','21','2220-7879','',4605),
(33671,13581,49,'Fernando','21','2220-7879','21','2220-7879','',4605),
(33672,13581,20,'Luís Antônio','21','2220-7879','21','2220-7879','',4605),
(33699,13593,123,'Marco Antônio Zuliani','17','3523-2757','17','3523-2757','consfran@consfran.com.br',3655),
(40595,13593,20,'Marco Antônio Zuliani','17','3523-2757','17','3523-2757','',4957),
(40596,13593,16,'Benedito H. Cantão','14','3522-4933','14','3522-4933','bcantao@sabesplins.com.br',3655),
(33709,13596,20,'José Ricardo','21','2710-8809','21','2710-8809','conipar@conipar.com.br',5583),
(33710,13596,16,'Rafael Arantes','21','2710-8809','21','2710-8809','rafael.arantes@conipar.com.br',5583),
(33711,13596,49,'Engº Antônio J. N. Rodrigues','21','2710-8809','21','2710-8809','',5583),
(34034,13717,49,'Ronaldo Faria Maciel','21','2620-8688','21','2620-8688','jmconstrucoes@jmconstrucoes.com.br',2101),
(34035,13717,16,'Eduardo Marques','21','2620-8688','21','2620-8688','compras@jmconstrucoes.com.br',2101),
(34036,13717,20,'Flávia (Comercial)','21','2620-8688','21','2620-8688','jmconstrucoes@jmconstrucoes.com.br',2101),
(34037,13718,49,'Ronaldo Faria Maciel','21','2620-8688','21','2620-8688','jmconstrucoes@jmconstrucoes.com.br',2101),
(34038,13718,16,'Eduardo Maciel','21','2620-8688','21','2620-8688','compras@jmconstrucoes.com.br',2101),
(34039,13718,20,'Priscila Oliveira','21','2620-8688','21','2620-8688','jmconstrucoes@jmconstrucoes.com.br',2101),
(34040,13719,49,'Jorge Alberto Guberman','21','2742-2498','21','2742-2498','',524),
(34041,13719,20,'Bianca Socci','21','2742-2498','21','2742-2498','',524),
(34042,13719,16,'Sra. Liene Chambu Guberman','21','2742-2498','21','2742-2498','ageengenharia@uol.com.br',524),
(34043,13720,49,'Clemildo','21','2742-2498','21','2742-2498','ageengenharia@uol.com.br',524),
(34044,13720,16,'Isabel Oliveira','21','2742-2498','21','2742-2498','ageengenharia@uol.com.br',524),
(34045,13720,20,'Suelen','21','2742-2498','21','2742-2498','ageengenharia@uol.com.br',524),
(34046,13721,20,'Camila','12','3897-8101','12','3882-4806','',3058),
(34506,13878,16,'Engº Luiz Antônio de Carvalho','21','3755-0192','21','9731-5351','',8232),
(34507,13878,49,'Engº Luiz Antônio de Carvalho','21','3755-0192','21','9731-5351','',8232),
(34639,13924,16,'Antônio A. Varandas','11','4193-8797','11','9989-7203','',8260),
(34640,13924,20,'Antônio Alexandre Varandas','11','4193-8797','11','9989-7203','',8260),
(34655,13931,16,'Engº Sérgio Folesco','21','2493-9190','21','7836-9312','',7899),
(34656,13931,49,'Engº Sérgio Folesco','21','2493-9190','21','7836-9312','',7899),
(34657,13931,20,'Engº Sérgio Folesco','21','2493-9190','21','7836-9312','',7899),
(39007,13931,20,'Sr. Dany Zilkha','21','2493-9190','21','2493-9190','',481),
(39008,13931,49,'Sérgio Folesco','21','2493-9190','21','2493-9190','',481),
(39009,13931,16,'Sérgio Folesco / Sr. Dany Zilkha','21','2493-9190','21','2493-9190','',481),
(34719,13956,16,'Carlos Henrique','22','2665-9009','22','2665-9009','',821),
(34720,13956,49,'Engº Marcelo A. Teixeira','22','2665-9009','22','2665-9009','',821),
(34721,13956,20,'Silvio Nunes','22','2665-9009','22','2665-9009','',821),
(34732,13965,20,'Ricardo - (Planejamento)','45','3241-8010','45','3241-8181','',4435),
(34733,13965,49,'Vitor Sondar','45','3326-1182','45','3326-1182','',3607),
(34734,13965,16,'Márcia Crispaldi das Neves / Jocilei','45','3326-1182','45','3326-1182','',3607),
(34829,14005,49,'Sinfronio','11','4425-2589','11','3045-6800','',5243),
(34830,14005,16,'Maurício','11','3045-6800','11','3045-6800','compras@cgsengenharia.com.br',5243),
(34831,14005,20,'Sinfronio','11','4425-2589','11','3045-6800','',5243),
(34832,14006,20,'Sra. Alessandra - (Recepção)','11','4229-2617','11','4229-2617','',4394),
(34833,14006,16,'Benê Venezian','11','9232-1065','11','4229-2617','',4394),
(34834,14006,91,'Benê Venezian','11','9232-1065','11','4229-2617','',4394),
(34835,14007,7,'Arq. Justino F. F. Rocha','21','9982-4748','21','2490-2331','apejf@click21.com.br',8284),
(34836,14007,16,'Arq. Justino F. F. Rocha','21','2490-2331','21','2490-2331','apejf@click21.com.br',8284),
(34837,14007,20,'Danielly','21','2437-9295','21','2490-2331','',8284),
(34843,14010,49,'Engº Marcelino Andrade de Lima','84','3217-9391','84','3217-9391','',8274),
(34844,14010,16,'Zenildo Oliveira ou Wigna Fernandes','84','3217-9391','84','3217-9391','therra@terra.com.br',8274),
(34845,14010,20,'Engª Camilo Marinho','84','3217-9391','84','3217-9391','',8274),
(42127,14010,49,'Engª Camila Marinho','84','3217-9391','84','3217-9391','',8274),
(34862,14017,16,'Renato','48','3035-1036','48','3259-4142','',7066),
(34863,14017,49,'Renato','48','3035-1036','48','3259-4142','',7066),
(34864,14017,20,'Renato','48','3035-1036','48','3259-4142','',7066),
(34865,14018,16,'Renato Krueger','48','3035-1036','48','3259-4142','',7066),
(34866,14018,49,'Renato Krueger','48','3035-1036','48','3259-4142','',7066),
(34867,14018,20,'Renato Krueger','48','3035-1036','48','3259-4142','',7066),
(34953,14049,20,'Lauro Pauluci','15','3363-1684','15','3363-1324','',8305),
(35062,14087,16,'Silvestre Alvares de Rezende','62','4001-3500','62','4001-3510','compras@suryaconstrutora.com.br',10740),
(35063,14087,20,'Sra. Janny Barros','62','4001-3631','62','4001-3510','janny.barros@suryaconstrutora.com.br',10740),
(39349,14087,49,'Mário Bandeira','62','4001-3500','62','4001-3510','',10740),
(35105,14103,49,'Josiane','54','8126-4178','54','3229-5949','viezzer@terra.com.br',8328),
(35106,14103,20,'Josiane','54','8126-4178','54','3229-5949','viezzer@terra.com.br',8328),
(41084,14103,16,'Virgínia','54','3229-5949','54','3229-6903','virginia@viezzerengenharia.com.br',8328),
(35176,14129,16,'Joel Peres de Camargo','16','3375-2400','16','3375-1161','joelcomp@terra.com.br',7079),
(35177,14129,49,'Walter de Lula','16','3375-9700','16','3375-9700','',7079),
(35178,14129,20,'Luize','16','3375-2400','16','3375-9700','',7079),
(35394,14209,49,'Juliano Rocha','11','4177-5961','11','4177-5961','',3366),
(35395,14209,16,'Miguel Abreu Rocha','11','4177-5961','11','4177-5961','construtora@abreurocha.com.br',3366),
(35396,14209,20,'Carla','11','4177-5961','11','4177-5961','',3366),
(35540,14260,16,'Júlio','83','3232-1117','83','3232-1117','',688),
(35541,14260,49,'José Santos Carvalho','83','3232-1117','83','3232-1117','',688),
(35542,14260,20,'Sr. Efren','83','3232-1117','83','3232-1117','',688),
(35895,14388,49,'Engº João Marcelo C. Cunha','21','2240-7536','21','2430-3245','',7577),
(35896,14388,16,'Sr. Luiz Carlos','21','2220-9737','21','2430-3245','l.carlos@mega-construcoes.com.br',7577),
(35897,14388,20,'Camila','21','2240-7536','21','2430-3245','',7577),
(35919,14397,16,'José Ribeiro Vila Nova','19','3342-8029','19','3342-8031','juilla3056@hotmail.com',8441),
(35920,14397,49,'Mário Soares','19','3342-8029','19','3342-8031','',8441),
(35921,14397,20,'Igor Carvalho (Técnico)','19','3342-8029','19','3342-8031','igor.his@gmail.com',8441),
(36363,14566,7,'Arq. Flávio Fonte Vieira','22','9983-2119','22','2771-3355','',5702),
(36364,14566,20,'Deilson Flausino Rodrigues','22','2771-3355','','','',5702),
(36428,14591,49,'Luis Eduardo','81','3267-7532','81','2122-3888','',4120),
(36429,14591,16,'Alexandre Augusto Conceição','81','3267-7532','81','2122-3888','a.augusto.conceicao@bol.com.br',4120),
(36430,14591,20,'Alexandre Augusto Conceição','81','3267-7532','81','2122-3888','a.augusto.conceicao@bol.com.br',4120),
(36445,14598,16,'Nilson Costa','11','3759-8639','11','3759-8639','nilsoncosta@rossiresidencial.com.br',366),
(36446,14598,49,'Murilo Paes','11','5524-7048','11','3759-8600','',366),
(52498,14598,20,'Renata Maldonado','11','5524-7048','11','3759-8600','renatamaldonado@rossiresidencial.com.br',366),
(36447,14599,20,'Sandra Rocha','11','3081-9335','11','3081-9335 -Ramal 205','',8566),
(36477,14612,16,'Valéria Oliveira','91','3204-3600','91','3204-3600','valeriaoliveira@exitoengenharia.com.br',8563),
(36478,14612,20,'Tatiana Braga Mendes (Orçamento e Planejamento)','91','3204-3600','91','3204-3600','tbragamendes@gmail.com',8563),
(36479,14612,49,'Carlos Cruz','91','3204-3600','91','3204-3600','exito@amazon.com.br',8563),
(96500,14612,49,'João Vicente Viana Longo','91','3204-3600','91','3204-3600','jonylong@gmail.com',8563),
(36781,14732,20,'Laíta','35','3694-4021','35','3694-4021','',2371),
(36782,14732,20,'Wainer Laider Santa Cruz','32','3371-6359','35','3371-6359','',2371),
(71363,14739,20,'Wellington Dutra','11','4824-6774','21','3151-7174','wdutra@contreras.co.br',14023),
(71364,14739,49,'Wellington Dutra','11','4825-1323','21','3151-7174','wdutra@contreras.com.br',14023),
(78852,14739,16,'Sr. Simoni Barbosa','11','4824-6774','21','3151-7174','sbarbosa@contreras.com.br',14023),
(36833,14759,49,'Denilson Sacramento','71','3385-9800','71','3385-9800','',10414),
(36834,14759,16,'Aurora Caldas','79','2107-7575','79','2107-7501','aurora.caldas@norcon.com.br',6771),
(36835,14759,20,'Daiane','79','2107-7579','79','2107-7501','',6771),
(36839,14761,49,'Igor Menezes','79','3232-1010','79','3232-1515','',8630),
(36840,14761,16,'Ronaldo Sampaio','79','3232-1010','79','3232-1515','ronaldo@ffb.com.br',8630),
(36841,14761,20,'Denise Duarte','79','3232-1010','79','3232-1515','',8630),
(36866,14772,16,'Aline Gabriela Azevedo','11','3842-6730','11','3842-6730','compras@construtorabasile.com.br',1600),
(36867,14772,20,'Américo Carlos Basile','11','3842-6730','11','3842-6730','',1600),
(36868,14772,91,'Américo Carlos Basile','11','3842-6730','11','3842-6730','',1600),
(36896,14784,16,'Fábio Xavier Guedes','98','3374-1764','98','3374-1764','fabio.xavier@deltaconstrucao.com.br',9811),
(88404,14784,20,'Fábio Xavier Guedes','98','3374-1764','98','3374-1764','fabio.xavier@deltaconstrucao.com.br',9811),
(88405,14784,49,'Fábio Xavier Guedes','98','3374-1764','98','3374-1764','fabio.xavier@deltaconstrucao.com.br',9811),
(37260,14911,49,'Engº Rafael','62','3546-8800','62','3546-8819','enio@govesa.ind.br',8685),
(37261,14911,16,'Hélio Antônio','62','3546-8800','62','3546-8819','helio@govesa.ind.br',8685),
(37262,14911,20,'Engº Rafael','62','3546-8800','62','3546-8819','',8685),
(37416,14979,16,'Adalberto','11','5514-6214','11','5514-6214','enpavi@gmail.com',8719),
(37417,14979,49,'André Luiz','16','3421-4300','','','andre-engenharia@enpavi.com.br',8719),
(37418,14979,20,'Engº Silvino Álvares de Carvalho','11','5514-6214','11','5514-6214','enpavi@gmail.com',8719),
(37457,14994,49,'Edgar Souza','27','3026-4350','27','3357-1099','jackeline.calassara@deltaincorporacao.com.br',2138),
(37458,14994,16,'Sr. Werlen Rodrigues','27','3357-1099','27','3357-1073','werlen@mazzinigomes.com.br',2138),
(37459,14994,20,'Sr. Werlen Rodrigues','27','3357-1099','27','3357-1073','werlen@mazzinigomes.com.br',2138),
(37847,15149,16,'Mauro de Freitas','11','3147-0000','11','3147-0071','maurofreitas@trisul-sa.com.br',10099),
(37848,15149,20,'Alessandra Albuquerque','11','3147-0000','11','3147-0071','',10099),
(56634,15149,30,'William Vitor','11','3147-0000','11','3147-0071','williamvitor@trisul-sa.com.br',10099),
(37858,15154,16,'Helton de Souza','11','5087-3888','11','5571-8666','helton.s@tecnosul.com.br',3487),
(37859,15154,20,'Sandoval','11','4777-1329','11','5087-3888','',10098),
(44897,15154,49,'Ricardo','11','4771-1329','11','5087-3888','',10098),
(37863,15156,7,'Arq. Ana Cláudia S. Labre','22','2664-9158','22','2665-7310','',8777),
(37864,15156,16,'Arq. Ana Cláudia S. Labre','22','2664-9158','22','2665-7310','',8777),
(37865,15156,20,'Sr. Carlos Alberto','22','2664-9158','22','2665-7310','',8777),
(37870,15159,20,'Vladimir Stefani (Diretor Planejamento)','19','3874-5656','19','3874-5654','obras@paulinia.sp.gov.br',459),
(37874,15161,16,'Leonel Turek','41','3334-1297','41','3334-1297','',8781),
(37875,15161,49,'Jorge Enjiu','41','3334-1297','41','3334-1297','',8781),
(37876,15161,20,'Janete','41','3334-1297','41','3334-1297','',8781),
(37897,15170,49,'Luiz Antônio','48','3461-8124','48','3461-8124','construtora@construtorafontana.com.br',3509),
(37898,15170,16,'Fábio Steiner','48','3461-8100','48','3461-8124','compras@construtorafontana.com.br',3509),
(37899,15170,20,'Rodrigo Ugioni','48','3461-8100','48','3461-8100','rodrigo@construtorafontana.com.br',3509),
(37947,15187,20,'Suzana Maria B. Oliveira','12','3925-9503','12','3921-2771','',5465),
(37993,15205,16,'Luiz Orlando','11','5571-0666','11','5539-4272','luizorlando@afonsofranca.com.br',3702),
(37994,15205,20,'Otacílio Prates','11','4411-4233','11','4411-4233','',3702),
(37995,15205,49,'Oscar Favero - (11) 7714-9969 / Marcelo','11','4411-4233','11','4411-4233','',3702),
(38100,15245,49,'Francisco Leite','34','3664-6008','34','3662-8100','espacolivre@espacolivreconstrucoes.com.br',8813),
(38101,15245,16,'Elcio Oliveira','34','3662-8100','34','3662-8100','espacolivre@espacolivreconstrucoes.com.br',8813),
(38102,15245,20,'Carlos Leite','34','3662-8100','34','3662-8100','espacolivre@espacolivreconstrucoes.com.br',8813),
(38355,15333,20,'Flávio Boschiero - (Gerente Compras)','11','4789-8000','11','2196-8232','flavio.boschiero@saint-gobain.com',2475),
(38359,15335,49,'César Barril','11','2673-4545','11','2673-4545','cesar@pozelli.com.br',5),
(38360,15335,16,'Liliam Luiz','11','2673-4545','11','2673-4545','liliamluiz@pozelli.com.br',5),
(38361,15335,20,'Humberto (Arquiteto)','11','2673-4545','11','2673-4545','humberto@pozelli.com.br',5),
(38609,15424,16,'Vagner Suguri','62','3251-8778','62','3251-8778','sercaconstrutora@cultura.com.br',7992),
(38610,15424,49,'Erico Veríssimo','62','3251-8778','62','3251-8778','sercaconstrutora@cultura.com.br',7992),
(38611,15424,20,'Engº Sandro Belo','62','8404-3180','62','3251-8778','sercaconstrutora@cultura.com.br',7992),
(38618,15427,16,'Engº Roberson','19','9128-9393','19','3294-0953','robison@uol.com.br',8918),
(38619,15427,49,'Engº Roberson Vidodi','19','9128-9393','19','3294-0953','',8918),
(38620,15427,20,'Engº Roberson Vidodi','19','9128-9393','19','3294-0953','',8918),
(38651,15436,16,'Maria de Fátima','11','3835-9850','11','3835-9850','fatima@scopus.com.br',3410),
(43488,15436,49,'Engº Fábio','11','7283-9148','11','3835-9850','scopus@scopusconstrutora.com.br',3410),
(51389,15436,20,'Engº Fábio','11','7283-9148','11','3835-9850','scopus@scopusconstrutora.com.br',3410),
(38663,15441,16,'Rodney Flávio Nastalli','34','3292-4500','34','3292-4500','rodney@mrv.com.br',8920),
(38664,15441,20,'Letícia Ramos','31','3348-7135','31','3348-7219','leticia.ramos@mrv.com.br',8920),
(38669,15444,49,'A definir','34','3292-4500','34','3292-4500','',8920),
(38670,15444,16,'Rodney Flávio Nastalli','34','3292-4500','34','3292-4500','rodney@mrv.com.br',8920),
(38671,15444,20,'Engº Leonardo Freitas','34','3292-4500','34','3292-4500','leonardof@mrv.com.br',8920),
(39096,15600,16,'Airton Cláudio','31','3291-7144','31','3291-7144','airton@asacop.com.br',8331),
(39097,15600,20,'Engº Ricardo Ribeiro de Andrade','31','3291-7144','31','3291-7144','ricardo@asacop.com.br',8331),
(39247,15660,49,'Engª Adriana Froes','31','3292-9700','31','3492-9700','comercial@muschioni.com.br',4826),
(39248,15660,20,'Vitória','31','3492-2996','31','3492-9700','comercial@muschioni.com.br',4826),
(39249,15660,16,'Rejane Farias','31','3492-2996','31','3492-9700','rejane@muschioni.com.br',4826),
(39362,15698,16,'Vitor Reginato','27','3329-6677','27','3329-6677','',5553),
(39363,15698,20,'Matilde Liberato','27','3329-6677','27','3329-6677','',5553),
(39364,15698,49,'A definir','27','3329-6677','27','3329-6677','',5553),
(40005,15929,16,'Célia Soares / Afonso Colaseri','19','3794-3300','19','3794-3339','afonsocolaseri@rossiresidencial.com.br',1683),
(40006,15929,49,'Engº Maurício','19','3272-6667','','','',1683),
(40007,15929,20,'Engº Maurício','19','3272-6667','','','',1683),
(40074,15955,16,'Roberto ou George','21','2531-7122','21','2531-7122','horm@gobo.com',9164),
(40075,15955,49,'Henrique Otávio','21','2531-7122','21','2531-7122','',9164),
(40076,15955,20,'Roberto','21','2531-7122','21','2531-7122','horm@globo.com',9164),
(40086,15960,20,'Engº Marco Antônio','82','3357-1444','82','3231-7300','placic88@ofm.com.br',9159),
(40087,15960,49,'Engº Marco Antônio','82','3357-1444','82','3231-7300','placic88@ofm.com.br',9159),
(40088,15960,16,'Engº Marco Antônio','82','3357-1444','82','3231-7300','placic88@ofm.com.br',9159),
(40128,15975,20,'Anderson Furlanetto','19','3903-4373','19','3903-4374','anderson_furlanetto@yahoo.com.br',9181),
(40135,15978,16,'Alex Ferreira Costa','17','3463-2937','17','9133-2627','fercancompra@terra.com.br',9184),
(40136,15978,49,'Maurício Américo','17','3463-2937','17','3463-2937','fercan@terra.com.br',9184),
(40137,15978,20,'Silvia','17','3463-2937','17','2463-2937','',9184),
(40138,15978,16,'Tiago Gentil','17','3463-2937','17','3463-2937','fercancompra@terra.com.br',9184),
(40227,16010,16,'Gustavo Santana','82','3336-2799','82','3336-2799','gustavo@tetoplanejamento.com.br',9202),
(40228,16010,20,'Joaquim Filho','82','3336-2799','82','3336-2799','',9202),
(40533,16118,16,'Luciane Mizhara','41','3352-5132','','','contato@invespark.com.br',9251),
(40534,16118,49,'Marlus César - (Escritório)','41','3013-2219','41','3013-2219','',15),
(40535,16118,20,'Claira - (Escritório)','41','3013-2219','41','3013-2219','',15),
(40536,16118,51,'Roberto','41','3013-5132','41','9943-8337','',15),
(40780,16208,16,'Aguinaldo Silva','21','2540-4664','21','2540-4669','aguinaldo.silva@grupoconcal.com.br',1528),
(40781,16208,49,'José Carlos','21','2512-5438','21','2540-4664','jose.carlos@gruoconcal.com.br',1528),
(40782,16208,20,'Hélio (Técnico de Edificações)','21','2512-5438','21','2540-4664','concal@grupoconcal.com.br',1528),
(40905,16253,16,'Patrícia','11','4825-8235','11','4825-8235','',9321),
(40906,16253,49,'Marcelo','11','4825-8235','11','4825-8235','',9321),
(40907,16253,20,'Celina','11','4825-8235','11','4825-8235','',9321),
(40908,16253,20,'Mara - (Imprensa)','12','3901-2150','12','3912-1664','',502),
(40911,16254,16,'Levi Xavier','11','3038-2000','11','3038-2029','levi@toledoferrari.com.br',1885),
(40912,16254,29,'José Eduardo Toledo Ferraz','11','3038-2000','11','3038-2029','joseeduardo@toledoferrari.com.br',1885),
(40913,16254,20,'Priscila Zucon (Projetos)','11','3038-2000','11','3038-2029','priscila@toledoferrari.com.br',1885),
(69914,16254,16,'Damião Sobrinho','11','3038-2000','11','3038-2029','damiao@toledoferrari.com.br',1885),
(40942,16264,16,'Emerson N. Pinheiros','15','3225-1246','','','',9334),
(40943,16264,49,'Dania Gabriele','15','3222-9957','15','9129-1760','dania@aeas.org.br',9335),
(40944,16264,20,'Emerson N. Pinheiro','15','3225-1246','','','',9334),
(40991,16284,16,'Cida Dias','11','3051-9999','11','3051-9998','cida@tiberio.com.br',1096),
(40992,16284,21,'Paulo Tibério','11','3051-9999','11','3051-9998','tiberio@tiberio.com.br',1096),
(40993,16284,20,'Beatriz (Comercial)','11','3051-9999','11','3051-9998','beatriz@tiberio.com.br',1096),
(41244,16394,20,'Shirley Esaki (Engenharia)','47','3471-0506','47','3471-0601','',9379),
(65987,16394,49,'Marcelo Farias','47','3471-0506','47','3471-0601','',9379),
(65988,16394,16,'Rosana Cunha','47','3471-0600','47','3471-0601','cunha@arcelormittal.com.br',9379),
(41248,16396,16,'Nelson Hirai','41','3332-8522','41','3332-8522','',9381),
(41249,16396,49,'Sérgio Akira','41','3332-8522','41','3332-8522','tese2005@brturbo.com.br',9381),
(41250,16396,20,'Engº Luis Bosa','41','3350-9654','','','bosa@smop.curitiba.pr.gov.br',3956),
(41307,16418,16,'Engº Sérgio Mester','11','3168-5900','11','3168-5900','sergio@seisa.com.br',2060),
(41308,16418,49,'Engº Sérgio Mester','11','3168-5900','11','3168-5900','sergio@seisa.com.br',2060),
(41309,16418,20,'Sr. Jorge','11','3168-5900','11','3168-5900','',9225),
(41328,16425,16,'Júlio César Hornos','11','3897-0700','11','3846-0628','julio.hornos@goldfarb.com.br',316),
(41329,16425,42,'Rui Kiyoshi Ishikawa','11','3897-0700','11','3897-0628','engenharia@goldfarb.com.br',316),
(41330,16425,20,'Sr. Guilherme Blumer - (Marketing)','11','3897-0700','11','3897-0628','guilherme.blumer@goldfarb.com.br',316),
(41507,16492,16,'Almiro','71','2106-2500','71','2106-2535','',1719),
(41508,16492,49,'Ricardo','71','3366-2507','71','2106-2500','',1719),
(41509,16492,20,'Carlos','71','3366-2507','71','2106-2500','cknelo@gafisa.com.br',433),
(42189,16770,16,'Siomara Lima / Paulo Suga','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(42190,16770,49,'Siomara Lima / Paulo Suga','44','3226-0909','44','3226-0901','engenhariaccv@bs2.com.br',9578),
(42191,16770,20,'Rodrigo Inácio (Marketing)','44','3226-0909','44','3226-0901','rodrigo.cidadeverde@hotmail.com',9578),
(42234,16785,20,'Viviane Gomes','31','3395-1802','38','3221-8205','comprasmocmca@yahoo.com.br',11861),
(55455,16785,123,'Jason Neto / Marcelino Pires','38','3221-8205','38','3221-8205','',11861),
(55456,16785,16,'Sra. Jeane Moura','38','3221-8205','38','3221-8205','',11861),
(42280,16806,16,'Melquíades','81','3242-5141','81','3242-5141','melquiades@exataengenharia.com.br',9589),
(42281,16806,49,'Sam James','81','3242-5141','81','3242-5141','exata@exataengenharia.com.br',9589),
(42282,16806,20,'Geovanna Albuquerque','81','3242-5141','81','3242-5141','geovanna@exataengenharia.com.br',9589),
(42364,16840,16,'Engº Adelino Lourenço Gomes','21','9962-3741','21','2606-3147','eng.adelino@gmail.com',487),
(42365,16840,49,'Engº Adelino Lourenço Gomes','21','9962-3741','21','2606-3147','eng.adelino@gmail.com',487),
(42366,16840,20,'Engº Adelino Lourenço Gomes','21','2606-3147','21','2606-3147','eng.adelino@gmail.com',487),
(42793,17010,16,'Paulo Silva / Juliana','11','5908-7922','11','5908-7922','compras@uniaoeng.com.br,paulosilva@uniaoeng.com.br',9664),
(42794,17010,49,'Guilherme Dissei','11','2061-4238','11','5908-7922','guilherme@uniaoeng.com.br',9664),
(42795,17010,20,'Débora (Engenharia)','11','2061-4238','11','5908-7922','debora@uniaoeng.com.br',9664),
(42869,17043,20,'Setor de Licitações','27','31321-8323','27','3380-3099','',6540),
(42912,17060,21,'Luis Carlos Kleinkauf','51','3341-4805','51','3341-4805','luis@termoprolzanotti.com.br',9707),
(49545,17060,16,'Sr. Levonir Martins','51','3341-4805','51','3341-4805','compras@termoprolzanotti.com.br',9707),
(73326,17060,20,'Fauzi Khalek (Comercial)','51','3341-4805','51','3341-4805','comercial@termoprol.com.br',9707),
(42974,17086,16,'Sérgio Campos / Sandra L. Campos','11','4524-8742','','','sandralimacampos@hotmail.com',9728),
(42975,17086,20,'Sandra Lima Campos','11','4524-8742','','','sandralimacampos@hotmail.com',9728),
(42979,17088,16,'Sr. Wilson','24','3322-1490','','','',9732),
(42980,17088,49,'Arq. Celso A. Senna','24','3322-1490','','','',9732),
(42981,17088,20,'Sr. Eustáquio','24','3322-1490','','','',9732),
(52021,17132,49,'Adriano Muzzi','98','8823-0434','85','4005-9053','adriano.petra.com.br',11334),
(52022,17132,16,'Adriano Muzzi','98','8823-0434','85','4005-9053','adriano@petra.com.br',11334),
(52037,17132,20,'Adriano Muzzi','85','4005-9053','85','4005-9053','adriano@petra.com.br',11334),
(43122,17154,20,'Vilma - (Licitação)','12','3123-2810','12','3123-2800','',9751),
(43125,17156,16,'Silvana Azevedo','84','3203-6000','84','3203-6001','suprimentos@delphiengenharia.com.br',9748),
(43126,17156,20,'Jamile Moura (Projetos)','84','3203-6000','84','3203-6001','jamile.moura@delphiengenharia.com.br',9748),
(60155,17156,21,'Engª Rosana Vieira','84','3203-6000','84','3203-6001','rosana.vieira@delphiengenharia.com.br',9748),
(43127,17157,16,'Silvana Azevedo','84','3203-6000','84','3203-6001','suprimentos@delphiengenharia.com.br',9748),
(43128,17157,49,'Ana Carolina','84','3203-6000','84','3203-6001','',9748),
(43129,17157,20,'Filipina Lázaro','84','3203-6000','84','3203-6001','filipina@delphiengenharia.com.br',9748),
(60156,17157,21,'Guido José Matokonovik','84','3203-6000','84','3202-6001','',9748),
(43135,17162,20,'Sr. Leandro - (Dir. Resp. pelo Projeto)','31','2125-1500','31','2125-1500','minaseta@gold.com.br',9754),
(51791,17162,16,'Geraldo Oliveira','31','2125-1500','31','2125-1500','geraldo.oliveira@londonmining.com.br',9754),
(51792,17162,20,'Sérgio Buarque - (Setor de Operações)','31','2125-1500','31','2125-1500','',9754),
(43217,17197,20,'Alex da Silva (Projetos)','45','3038-8054','','','alex@direzione.com.br',14395),
(43218,17197,21,'Ângelo Aurélio  (Coord. do Projeto)','45','9111-8006','45','3038-8054','angelo@direzione.com.br',14395),
(43241,17208,16,'Alessandra Pavanelli','11','2244-6511','11','3848-7179','alessandra@fiveengenharia.com.br',9042),
(43242,17208,49,'Sr. Marcelo','11','2244-6511','11','3848-7186/79','',9042),
(43243,17208,20,'Sra. Katia','11','2244-6511','11','3848-7179','',9042),
(43261,17216,16,'Rita de Cássia','17','3203-1800','17','3203-1810','rita@tarrafconstrutora.com.br',3213),
(43262,17216,49,'Roberto Sudo','17','3203-1800','17','3203-1810','',3213),
(43263,17216,20,'Renato Lemos','17','3203-1800','17','3203-1810','',3213),
(43455,17291,16,'Luciano','12','3621-4797','12','3621-4012','compras@araujosimao.com.br',6906),
(43456,17291,49,'Lamartine Xavier de Camargo','12','3621-4012','12','3621-4012','engenharia@araujosimao.com.br',6906),
(43457,17291,20,'Gabriel Machado (Engenharia)','12','3621-4012','12','3621-4012','engenharia@araujosimao.com.br',6906),
(43498,17310,20,'Sra. Nilza - (Licitações)','77','3464-2210','77','3464-2210','gabinete@mortugaba.com.br',9835),
(43536,17326,16,'Ovídio Segatin Júnior','14','3234-7102','14','3234-7102','contato@indusbank.com.br',9840),
(43537,17326,29,'Ovídio Segatin Júnior','14','3234-7102','14','3234-7102','contato@indusbank.com.br',9840),
(43538,17326,20,'Mizra Garcia (Atendimento)','14','3234-7102','14','3234-7102','contato@indusbank.com.br',9840),
(43584,17342,16,'João Batista Pinto','31','3025-6600','31','3025-6601','joao@construtoravisor.com.br',7457),
(43585,17342,20,'Gian Francisco','31','3025-6613','31','3025-6601','gian@construtoravisor.com.br',7457),
(43586,17342,49,'Gian Francisco','31','3025-6613','31','3025-6601','gian@construtoravisor.com.br',7457),
(57392,17346,21,'Pedro Andrade','11','5508-3300','11','5508-3316','pedro.andrade@cerona.com.br',11254),
(79059,17346,20,'Pedro Andrade','11','5508-3300','11','5508-3316','pedro.andrade@cerona.com.br',11254),
(43751,17409,16,'Gustavo de Ataide Lopes','31','3486-5686','31','3486-5686','fernaodiascompras@yahoo.com.br',9874),
(43752,17409,49,'Gustavo de Ataíde Lopes','31','3486-5686','31','3486-5686','fernaodiascompras@yahoo.com.br',9874),
(43753,17409,20,'Gustavo de Ataíde Lopes','31','3486-5686','31','3486-5686','fernaodiascompras@yahoo.com.br',9874),
(44022,17516,16,'Lupércio Marques','41','3320-8891','41','3320-8891','compras@tha.com.br',769),
(44023,17516,49,'Malek Smaniotto','41','3013-0397','41','3320-8800','malek@tha.com.br',769),
(44024,17516,20,'Malek Smaniotto','41','3013-0397','41','3320-8800','malek@tha.com.br',769),
(44152,17563,16,'Orlando Fregolente','14','3621-6848','14','3621-6846','hejau@netsite.com.br',9017),
(44153,17563,49,'Orlando Fregolente','14','3621-6848','14','3621-6846','hejau@netsite.com.br',9017),
(44154,17563,20,'Lúcia','14','3621-6848','14','3621-6846','',9017),
(44381,17660,16,'Raniere dos Santos Ferreira','16','3722-5955','16','3722-5955','raniere@cvlopes.com.br',10011),
(44382,17660,21,'Valdir Lopes','16','3722-5955','16','3722-5955','cvlopes@cvlopes.com.br',10011),
(107163,17660,20,'Raniere dos Santos Ferreira','16','3722-5955','16','3722-5955','raniere@cvlopes.com.br',10011),
(44398,17668,16,'Sidney','11','4158-6627','11','4158-6627','sid@fazer.eng.br',2629),
(44399,17668,49,'Fabiano Monegalia Polloni','11','4158-6627','11','4158-6627','',2629),
(44400,17668,20,'Ornella Polloni','11','4158-6627','11','4158-6627','',2629),
(44436,17683,16,'Vitor Grasselli','27','3227-3799','27','3227-3799','grasselli@grasselliengenharia.com.br',10016),
(44437,17683,49,'Vitor Grasselli','27','3324-4648','27','3227-3799','vitor@grasselliengenharia.com.br',10016),
(44438,17683,20,'Thiago Moura','27','3324-4648','27','3227-3799','',10016),
(44524,17727,20,'Merenock','47','3348-0129','47','3348-0129','',10029),
(44547,17740,20,'José Carlos Fagundes de S. Lima','22','9986-0827','','','falay@zipmail.com.br',5625),
(44807,17852,16,'Manoel Nunes e Silva Neto','98','3233-6792','98','3233-6792','manoel@lastroengenharia.com.br',8367),
(44808,17852,49,'Osvaldino Antônio Martins de Pinho','98','3233-6792','98','3233-6792','osvaldino@lastroengenharia.com.br',8367),
(44809,17852,20,'Sr. Ivan Pinheiros','98','3226-4378','98','3233-6792','',8367),
(44867,17881,20,'Engº Fernando','51','3330-2007','51','3327-0700','eng@formainc.com.br',10091),
(44892,17881,49,'Máreia Novetto','51','3327-2727','51','3327-2727','',10091),
(53271,17881,16,'Luiz Penha ou Claudiomiro Hart','51','3327-0700','51','3327-0700','compras@tedesco.com.br',6049),
(44871,17883,16,'Ricardo Pereira','27','3228-0801','27','3228-0801','compras@atlasengenharia.com.br',10092),
(44872,17883,49,'Sérgio / Jorge','27','3228-0801','27','3228-0801','',10092),
(44873,17883,20,'Jaila','27','3228-0801','27','3228-0801','',10092),
(44953,17912,16,'Arqª Rosângela M. S. Borges','21','2688-4301','21','2688-1533','arq.borges@gmail.com',10100),
(44954,17912,49,'Arqª Rosângela M. S. Borges','21','2688-4301','21','2688-1533','arq.borges@gmail.com',10100),
(44955,17912,20,'Jorge Roberto','21','2688-4301','21','2688-1533','',10100),
(44989,17926,20,'Sr. Mansur - (Assessoria de Imprensa)','21','3224-1306','21','3224-4477','mansur.protemp@petrobras.com.br',19),
(45192,18016,20,'Rosi Tavares','21','2601-2536','21','2725-0202','igreja@novavidacol.com.br',1207),
(52812,18016,49,'João Arede','21','2639-6766','21','2604-4794','joaoaredeengenharia@gmail.com',895),
(52813,18016,16,'Robson / Pastor Derocy','21','3247-6018','21','2204-4794','igreja@novavidacol.com.br',1207),
(45390,18097,16,'José Maria','91','3084-8406','91','3084-8406','disup@ckom.com.br',8841),
(45391,18097,49,'Glauber Melo','91','3084-8406','91','3084-8406','ckom@ckom.com.br',8841),
(45392,18097,20,'Aldenor Almeida (Gerente Técnico)','91','3084-8400','91','3084-8400','getec@ckom.com.br',8841),
(45433,18113,49,'Luciano da Silva','47','3276-4000','47','3276-4000','lucianods@weg.net',5431),
(54327,18113,20,'Mário Anzini (Contratos)','47','9921-7347','47','3276-5708','anzini@weg.net',5431),
(54328,18113,16,'Octávio Caetano Monteiro','11','5053-2340','11','5052-4223','octaviom@weg.net',6355),
(45463,18125,16,'João Carlos Godoy','48','3437-0166','48','3437-0166','pavei@pavei.com.br',5291),
(45464,18125,49,'Arilton Bisbate','48','9984-1893','48','3437-0166','pavei@pavei.com.br',5291),
(45465,18125,20,'Arilton Bisbate','48','9984-1893','48','3437-0166','pavei@pavei.com.br',5291),
(45496,18139,20,'Sérgio Teixeira de Freitas - (Ger. Industrial)','41','2104-5508','41','2104-5599','sergio@herbarium.net',10202),
(45497,18139,16,'Anderson Charles','41','3013-0078','41','3013-4080','vnengenharia@terra.com.br',11706),
(54495,18139,49,'Fernando Bolsi da Silva','41','3013-0078','41','3013-4080','vnengenharia@terra.com.br',11706),
(54497,18139,20,'Julio Carlins (Infra-estrutura)','41','2104-5594','41','2104-5599','julioc@herbarium.net',10202),
(49152,18140,20,'Jonatas Magalhães (Adm)','87','3771-2431 - R: 2974','87','3771-2431','',11916),
(55761,18140,49,'Rogério Novak','87','3771-2431 - R: 2974','87','3771-2431','',11916),
(55762,18140,16,'Sr. Miguel Marinho','87','3771-2431','87','3771-2431','miguel.marinho@serpal.com',11916),
(68364,18140,20,'Marcos Sirena (Engenharia)','87','3771-4070','87','3741-4070','',13653),
(45709,18247,16,'Carlos','31','3337-9189','31','3337-9189','oepengenharia@yahoo.com.br',7073),
(45710,18247,49,'Sérgio Zanforlin','31','3337-9189','31','3337-9189','',7073),
(45711,18247,20,'Frederico','31','3337-9189','31','3337-9189','oepengenharia@yahoo.com.br',7073),
(60976,18378,20,'Victor Marques (Produção)','66','3565-3759','66','3565-2713','vmarques@odebrecht.com',10295),
(46158,18419,16,'Cristiane Rocha','31','3282-5404','31','3287-2655','compras@parcanbh.com.br',4763),
(54759,18419,49,'Nestor Jorge Andrade','38','3526-1662','38','3526-1662','nestorjorgeandrade@yahoo.com.br',4763),
(54760,18419,20,'Daniel Costa','31','3282-5404','31','3287-2655','daniel@parcanbh.com.br',4763),
(46175,18427,16,'Janaina Majebesk','27','3329-3130','27','3329-3130','obras@decottingnies.com.br',10344),
(46176,18427,49,'Dionathan Santos Rodrigues','27','3329-3130','27','3329-3130','dionathan@hotmail.com',10344),
(46177,18427,20,'Dionathan Santos Rodrigues','27','3329-3130','27','3329-3130','dionathan@hotmail.com',10344),
(46178,18428,16,'Jairo','27','3329-3130','27','3329-3130','',10344),
(46179,18428,49,'Dionathan Santos Rodrigues','27','9996-3767','27','3329-3130','dionathan@hotmail.com',10344),
(46180,18428,20,'Dionathan Santos Rodrigues','27','9996-3767','27','3329-3130','dionathan@hotmail.com',10344),
(46202,18436,16,'Lúcia','11','3097-2700','11','3031-0544','lucia@godoi.com.br',576),
(46203,18436,49,'Engº André','11','3758-2551','11','3097-2700','andre@godoi.com.br',576),
(46204,18436,20,'Engº André','11','3758-2551','11','3097-2700','andre@godoi.com.br',576),
(46208,18438,16,'Rosana Aranha','11','3817-0043','11','3817-1795','rosana@mac.com.br',293),
(46209,18438,21,'André Denone','11','3817-0033','11','3817-1795','andre@mac.com.br',293),
(46210,18438,20,'Allan Ribeiro (Marketing)','11','3817-0043','11','3817-1795','allan@mac.com.br',293),
(46378,18507,16,'Oswaldo Floriano Vieira Júnior','11','4192-3437','11','4192-7972','oswaldofloriano@terra.com.br',1895),
(46379,18507,49,'Oswaldo Floriano Vieira Júnior','11','4192-3437','11','4192-7972','oswaldofloriano@terra.com.br',1895),
(46380,18507,20,'Sr. Gilberto - (Projetista)','11','4192-3437','11','4192-7972','oswaldofloriano@terra.com.br',1895),
(46473,18543,20,'Regiane Barbosa - (Licitação)','31','3288-1181','31','3288-1181','itamaraca@construtoraitamaraca.com.br',6853),
(56775,18543,49,'Engª Maria Estela','31','3288-1181','31','3288-1181','',6853),
(56776,18543,16,'Wellington','31','3288-1181','31','3288-1181','',6853),
(46475,18545,20,'Dener Carvalho','31','3235-6223','31','3235-6190','',2816),
(46507,18563,16,'Graça Matias','84','3203-3100','84','3203-3140','compras@capuche.com.br',2413),
(46508,18563,49,'Leonardo Assis','84','3203-3100','84','3203-3140','',2413),
(46509,18563,20,'Katarina Praxedes (Departamento de Qualidade)','84','3203-3100','84','3203-3140','katarina.praxedes@capuche.com.br',2413),
(46578,18594,16,'Alceu Farias','41','3243-1333','41','3243-1333','compras@hestia.com.br',3752),
(46579,18594,49,'Volmir Selig','41','3243-1333','41','3243-1333','hestia@hestia.com.br',3752),
(46580,18594,20,'Rogério Arno','41','3343-2555','41','3343-2555','rogerio@hestia.com.br',3752),
(46588,18598,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(46607,18609,20,'Michele - (Licitação)','41','3221-6117','41','3323-2018','',4155),
(46680,18641,16,'Leonardo Dellagiustina','47','3340-6151','47','3340-6151','l.franzmann@terra.com.br',10396),
(46681,18641,49,'Leonardo Dellagiustina','47','3340-6151','47','3340-6151','l.franzmann@terra.com.br',10396),
(46682,18641,20,'Leonardo Dellagiustina','47','3340-6151','47','3340-6151','l.franzmann@terra.com.br',10396),
(46685,18644,20,'José Anchieta (Administrativo)','11','3727-1690','11','3727-1690','casasesbp@usp.br',10398),
(46693,18649,16,'Mário de Figueiredo Pacheco','21','2122-1616','21','2122-1627','globo@globoconstrucoes.com.br',867),
(46694,18649,49,'Juan Manoel Silva Esteves','21','2122-1616','21','2122-1627','globo@globoconstrucoes.com.br',867),
(46695,18649,20,'Sirlene Pacheco','21','2122-1616','21','2122-1627','sirlene@globoconstrucoes.com.br',867),
(46760,18681,16,'Arq. Jorge Luiz Alves Pinto','21','2289-1043','21','2289-1043','',1194),
(46761,18681,7,'Arq. Jorge Luiz Alves Pinto','21','2289-1043','21','2289-1043','',1194),
(46762,18681,20,'Arq. Jorge Luiz Alves Pinto','21','2289-1043','21','2289-1043','',1194),
(46770,18684,16,'Rolf Bennreiter','11','3231-2442','11','3231-2442','rbr.suprimentos@paesdelima.com.br',2843),
(46771,18684,49,'Hélio','11','5058-0492','11','3231-2442','garden_jdbotanico@yahoo.com.br',2843),
(46772,18684,20,'Valmir (Depto. Administrativo)','11','5058-0492','11','3231-2442','garden@garden-sp.com.br',2843),
(46867,18718,16,'Claudete Souza','48','3247-9401','48','3247-9401','centaurusltda@bol.com.br',10434),
(46868,18718,49,'Marcos Souza','48','3247-9401','48','3247-9401','',10434),
(46869,18718,20,'Claudete Souza','48','3247-9401','48','3247-9401','centaurusltda@bol.com.br',10434),
(46870,18719,21,'Willian Sardinha','21','2220-5352','21','2220-5352 -Ramal 222','',10435),
(46871,18719,16,'Flávio Barbuy','65','3325-3143','65','3325-3144','flavio.barbuy@hochtief.com.br',11131),
(50899,18719,20,'Roney Fonsi - (Coordenador de Suprimentos)','65','3325-3143','65','3325-3144','roney.fonsi@hochtief.com.br',11131),
(46872,18720,21,'Sr. Pinheiro - (Projeto)','11','6197-5797','11','6197-5797','cordasfirmeza@uol.com.br',10436),
(46873,18720,49,'Gustavo Vieira','11','2111-7000','11','2111-7040','',10437),
(46874,18720,20,'Sr. Ademir','11','2111-7000','11','2111-7000','',10437),
(46875,18720,16,'Sr. Ademir','11','2111-7000','11','2111-7000','',10437),
(46876,18721,49,'Carlos Magno','12','9156-8079','11','5087-6550','carlos@serpal.com',1080),
(46877,18721,16,'Edson Correia','11','5087-6550','11','5087-6565','suprimentos@serpal.com',1080),
(54333,18721,20,'Carlos Magno','12','9156-8079','11','5087-6565','carlos@serpal.com',1080),
(46879,18722,16,'Marcos Ambrosoli','21','3639-0662','','','ambrosoli@globo.com',10440),
(46880,18722,49,'Engº Marcos Ambrosoli','21','3639-0662','','','ambrosoli@globo.com',10440),
(46881,18722,20,'Evandro Silveira','21','7821-8081','','','ambrosoli@globo.com',10440),
(46897,18734,16,'Cida Dias','11','3051-9999','11','3051-9998','cida@tiberio.com.br',1096),
(46898,18734,21,'Paulo Tibério','11','3051-9999','11','3051-9998','tiberio@tiberio.com.br',1096),
(46899,18734,20,'Priscila Andrade (Marketing)','11','3051-9999','11','3051-9998','pirscila.andrade@tiberio.com.br',1096),
(46931,18746,49,'Restrito','','','','','',1096),
(46932,18746,16,'Cida Dias','11','3051-9999','','','suprimentos@tiberio.com.br',1096),
(144870,18746,20,'Rafaela Martins Ventura (Sup. de Planejamento)','11','3051-9999','','','Restrito',1096),
(47000,18775,16,'Armando Marques','84','4009-3000','84','4009-3000','armando@ecocil.com.br',3858),
(47001,18775,20,'Lidimar Marques (Administrativo)','84','4009-3000','84','4009-3005','lidimar@ecocilengenharia.com.br',3858),
(47002,18775,49,'Heitor Dias','84','4009-3000','84','4009-3005','heitor@ecocilengenharia.com.br',3858),
(47240,18871,16,'Vitor Albernaz','31','3303-0303','31','3303-0303','suprimentos@construtoramodelo.com.br',3461),
(47241,18871,49,'Engº Victor E. C. Abreu','31','3484-8200','31','3303-0303','',3461),
(47242,18871,20,'Sr. Roberto','31','3484-8200','31','3303-0303','',3461),
(47312,18892,20,'Valéria Medina (Diretoria)','31','2551-5500','31','2551-5500','',824),
(47294,18894,20,'Ana Botinas (Administração)','11','3289-3954','11','3289-3954','ana.botinas@metacortex.com.br',10501),
(47295,18895,16,'Misael Barreto','85','4008-3322','85','4008-3378','misael@marquise.com.br',688),
(47296,18895,49,'Rogélio Linhares','11','2109-0218','11','3682-2004','rogelio@marquise.com.br',10504),
(47297,18895,20,'David Fonseca','11','2109-0218','11','3682-2004','davidfonseca@marquise.com.br',10504),
(47530,18990,16,'Sr. Táffner','61','3346-3057','61','2106-1801','compras@hcconstrutora.com.br',1386),
(47531,18990,20,'Juliana (Financeiro)','61','2106-1800','61','2106-1801','atendimento@hcconstrutora.com.br',1386),
(47532,18990,49,'Dário J. Campos Cardoso','61','2106-1800','61','2106-1801','',1386),
(47624,19029,20,'Laudicea Oliveira (Marketing)','11','3595-7944','11','3595-7949','laudicea@stuhlberger.com.br',388),
(54525,19029,16,'Roberta Rodrigues','11','3595-7944','11','3595-7949','roberta@stuhlberger.com.br',388),
(54526,19029,49,'Alessandro Rubini','11','3595-7944','11','3595-7949','alessandro@stuhlberger.com.br',388),
(47789,19101,20,'Juliana Barbosa (Comercial)','31','3333-8380','31','3333-8436','juliana.barbosa@cralmeida.com.br',12227),
(57967,19101,49,'Roberto Ubirajara','31','3333-8380','31','3333-8380','roberto.ubirajara@cralmeida.com.br',12227),
(57968,19101,16,'Nilson Souza (Administração)','31','3333-8436','31','3333-0436','nilson.souza@cralmeida.com.br',12227),
(47813,19113,16,'Sueli Nogueira Gomes','11','3171-1233','11','3171-2822','sueli@solidi.com.br',1378),
(69795,19113,21,'Rodrigo Carvalho (Engenharia)','11','3171-1233','11','3171-2822','rodrigo@solidi.com.br',1378),
(78056,19113,21,'Rodrigo Carvalho (Engenharia)','11','3171-1233','11','3171-2822','rodrigo@solidi.com.br',1378),
(47871,19138,16,'Engª Rosângela Frazão','22','2759-1210','22','2770-6767','rosangelafrazao@uol.com.br',7359),
(47872,19138,49,'Engª Rosângela Frazão','22','2759-1210','22','2770-6767','rosangelafrazao@uol.com.br',7359),
(47873,19138,20,'José Fardin','22','2759-1210','22','2770-6767','',7359),
(47877,19140,20,'José Carlos Fagundes','22','9986-0827','','','falay@zipmail.com.br',5625),
(47881,19144,20,'Lilian Curti (Engenharia)','17','3426-7500','17','3426-7500','lilian.curti@demop.com.br',12232),
(66197,19144,16,'Daniel Pagoto','17','3426-7500','17','3426-7500','daniel.pagoto@demop.com.br',12232),
(66198,19144,49,'Paulo César','17','3426-7500','17','3426-7500','paulocesar@demop.com.br',12232),
(47882,19145,20,'Silvana - (Licitação)','11','3311-1400','11','3311-0973','',550),
(47883,19146,20,'Silvana - (Licitação)','11','3311-1400','11','3311-0973','',550),
(47898,19153,16,'Tiago Arruda','21','2132-9066','21','2132-9033','tiago@dominus.com.br',6),
(47899,19153,49,'Felipe Leite','21','2601-1618','21','2132-9000','felipe@dominus.com.br',6),
(47990,19153,20,'Felipe Leite','21','2601-1618','21','2132-9000','felipe@dominus.com.br',6),
(47929,19164,42,'Sérgio Basse','11','3170-0000/0001','11','3147-0066','sergiobasse@trisul-sa.com.br',10099),
(47930,19164,20,'Alessandra Albuquerque (Marketing)','11','3147-0000/0001','11','3147-0066','alessandraalbuquerque@trisul.com.br',10099),
(81535,19164,70,'Roberto Júnior','11','3170-0000/0001','11','3147-0066','robertojunior@trisul-sa.com.br',10099),
(93208,19164,16,'Julio Silva (Gerente de Sup.)','11','3147-0111','11','3147-0066','juliosilva@trisul-sa.com.br',10099),
(47948,19170,20,'Josimar Melo (Almoxarifado)','69','3461-1700','69','3461-1554','',10598),
(47965,19180,16,'Engº Robson Santos de Melo','21','2661-0263','21','2661-0263','mpbastosconstrutora@yahoo.com.br',10590),
(47966,19180,49,'Engº Robson Santos de Melo','21','2661-0394','21','2661-0263','mpbastosconstrutora@yahoo.com.br',10590),
(47967,19180,20,'Sr. Marcos','21','2661-0394','21','2661-0263','',10590),
(47971,19182,16,'Ediméia Azevedo','31','3235-4600','31','3235-4646','compras@direcional.com.br',4566),
(47972,19182,20,'Leandro Elias Ribeiro','61','3435-0929','61','3322-9592','leandroelias@direcional.com.br',4616),
(47973,19182,49,'Wagner de Castro','61','3435-0929','61','3322-9592','direcional@direcional.com.br',4616),
(48000,19193,20,'Eugênio Buosi Filho','11','7818-4356','11','3743-9722','eugenio@projete.com.br',2199),
(54384,19193,16,'Eugênio Buosi Filho','11','7818-4356','11','3743-9722','eugenio@projete.com.br',2199),
(54385,19193,49,'Eugênio Buosi Filho','11','7818-4356','11','3743-9722','eugenio@projete.com.br',2199),
(48063,19222,16,'Francine Xavier','11','3198-8117','11','3702-1900','francinexavier@jhsf.com.br',5917),
(53432,19222,42,'Henrique Guatimosin','11','3198-8117','11','3702-1900','rogeriolopes@jhsf.com.br',5917),
(105103,19222,16,'Rogério Lopes','11','3198-8117','11','3702-1900','rogeriolopes@jhsf.com.br',5917),
(105687,19222,20,'Rogério Lopes','11','3198-8117','11','3702-1900','rogeriolopes@jhsf.com.br',5917),
(48074,19228,16,'Rafael Felix Cohen','21','2294-0094- R: 7','21','2239-8926','ciac@ciac-arquitetura.com.br',10624),
(48075,19228,20,'Rafael Cohen','21','2294-0094- R: 7','21','2239-8926','rafael@ciac-arquitetura.com.br',10624),
(48076,19228,49,'Rafael Felix Cohen','21','2294-0094- R:7','21','2239-8926','rafael@ciac-arquitetura.com.br',10624),
(48137,19253,20,'Rosângela Adenghi (Secretaria da Diretoria)','16','2105-4422','16','2105-4410','',10640),
(48156,19260,16,'Claudileni Sampaio Viana','11','3071-0011','11','3071-0011','claudileni@portoferraz.com.br',10653),
(65281,19260,49,'Márcio Batista','11','4614-0370','11','3071-0011','marcio@portoferraz.com.br',10653),
(65282,19260,20,'Adelson (Engenharia)','11','4614-0370','11','3071-0011','adelson@portoferraz.com.br',10653),
(48175,19269,16,'Francisco de Assis','11','6521-4766','11','6521-5637','obras.kamilos@terra.com.br',8348),
(48176,19269,49,'Antônio Lopes Névoa','11','6521-4766','11','6521-5637','',8348),
(48177,19269,20,'Antônio Lopes Névoa','11','6521-4766','11','6521-5637','',8348),
(48186,19273,1,'Jacques Gontijo','31','3249-3821','31','3249-3860','',2863),
(48208,19273,20,'Rodrigo Pereira (gerente do projeto)','31','3249-3719','31','3249-3860','rodrigopereira@itambe.com.br',2863),
(48189,19275,20,'Reinaldo Gomes (Incorporações)','62','8422-6282','62','3035-6000','reinaldo.gomide@primeconstrucoes.com.br',13439),
(48190,19275,16,'Sr. Emyus Moreira','61','3215-1754','61','3215-1754','emyus.moreira@primeconstrucoes.com.br',13439),
(48191,19275,106,'Wilton Silva','62','3215-1754','62','3215-1754','wilton.silva@primeconstrucoes.com.br',13439),
(48279,19313,16,'Márcio Luis Rodrigues','21','2507-1011','21','2220-9347','s.engenharia@projob.com.br',4052),
(48280,19313,7,'José Carlos Tuton Pereira','21','2224-5690','21','2220-9347','',4052),
(48281,19313,20,'Márcio Luís','21','2224-5690','21','2220-9347','',4052),
(48293,19320,16,'Simone Santos','11','3708-1444','11','3708-1000','simone.santos@tecnisa.com.br',444),
(48294,19320,20,'Simone Santos','11','3708-1444','11','3708-1000','simone.santos@tecnisa.com.br',444),
(153168,19320,49,'A definir','11','3708-1000','','','',444),
(48319,19331,16,'Sr. Cézar / Alexandre Ferreira','12','3951-5786','12','3951-5786','servico@construjak.com.br',10662),
(48320,19331,20,'Sr. Cézar','12','3951-5786','12','3951-5786','',10662),
(48353,19345,16,'Anderson Figueiredo','21','2221-8752','21','2221-8752','anderson@lopezmarinho.com.br',4722),
(48354,19345,49,'Gabriel Mosqueira Lopes','21','2221-8752','21','2221-8752','',4722),
(48355,19345,20,'Anderson Figueiredo','21','2221-8752','21','2221-8752','anderson@lopezmarinho.com.br',4722),
(48399,19363,20,'Silvia - (Administração)','51','3051-2255','51','3477-2255','lasa@lasadobrasil.com.br',10671),
(48569,19430,20,'Daniela Vendemiatti','19','3885-7000','19','3885-7000','ahespanhol@toyota.com.br',8755),
(48758,19502,49,'João Carlos Melo','81','3269-0118','81','3087-8000','engenhoguimaraes@mouradubeux.com.br',898),
(48759,19502,20,'José Francisco (Almoxarife)','81','3269-0118','81','3087-8000','engenhoguimaraes@mouradubeux.com.br',898),
(48760,19502,16,'Fabiano Escorel','81','3087-8000','81','3087-8056','engenhoguimaraes@mouradubeux.com.br',898),
(48791,19516,16,'José R. Rebello','11','4195-1522','','','rebello@br.inter.net',6100),
(48792,19516,49,'José R. Rebello','11','4195-1522','','','rebello@br.inter.net',6100),
(48793,19516,20,'Sra. Seli','11','4195-1522','','','',6100),
(48978,19589,16,'Sra. Kazue / Paulo','19','3867-3444','19','3867-3444','aikawa@aikawa.com.br',10780),
(48979,19589,21,'Reinaldo Aikawa','19','9649-7398','19','3867-3444','aikawa@aikawa.com.br',10780),
(48980,19589,21,'Paulo','19','3867-3444','19','3867-3444','',10780),
(48981,19589,20,'Reinaldo Aikawa','19','9649-7398','19','3867-3444','aikawa@aikawa.com.br',10780),
(49017,19600,20,'Luiz Eugênio','69','9987-9796','69','3222-0101','ampereconstru@ibest.com.br',12101),
(57054,19600,21,'Sérgio Augusto','69','3222-0101','69','3222-0101','ampereconstru@ibest.com.br',12101),
(57055,19600,16,'Sérgio Augusto','69','3222-0101','69','3222-0101','ampereconstru@ibest.com.br',12101),
(57056,19600,49,'Sérgio Augusto','69','3222-0101','69','3222-0101','ampereconstru@ibest.com.br',12101),
(49092,19629,21,'João Gabriel','31','3207-2125','31','3207-2088','',10803),
(49093,19629,21,'José Machado','31','3207-8800','31','3207-8800','josemachado@codemig.com.br',9925),
(73973,19629,20,'José Machado','31','3207-8800','31','3207-8800','josemachado@codemig.com.br',9925),
(49114,19638,16,'Sra. Ivani Dalla','11','4990-8484','11','4994-2258','ivani@dallaconstrutora.com.br',7697),
(49115,19638,7,'Rui Dalla','11','4990-8484','11','4994-2258','',7697),
(49116,19638,20,'Rui Dalla','11','4990-8484','11','4994-2258','',7697),
(49120,19640,20,'Ivoney Baluti','41','3364-9197','41','3364-9197','',6338),
(55833,19640,49,'Ivoney Baluti','41','3364-9197','41','3364-9197','',6338),
(55834,19640,45,'Luiz Henrique Panichi','41','3364-9197','41','3364-9197','',6338),
(55835,19640,16,'Waldemar Todesco Júnior','41','3364-9197','41','3364-9197','',6338),
(49257,19701,16,'Genivaldo Davanso','71','3273-6618','71','3273-6619','genivaldo@sertenge.com.br',6986),
(49258,19701,49,'Fábio / Bruno','71','3276-6600','71','3273-6633','',6986),
(49259,19701,20,'Diana Queiroz','71','3276-6600','71','3273-6633','dianaqueiroz@sertenge.com.br',6986),
(49295,19720,16,'Setor Compras','21','2667-3376','21','2667-3376','dimagem1@ig.com.br',10843),
(49296,19720,49,'Engº Humberto B. Palladino','21','9854-0079','21','3775-3121','corel.2006@hotmail.com',10834),
(49297,19720,20,'Sr. José','21','2667-3376','21','2667-3376','',10843),
(49314,19731,16,'Arq. Norton C. Maia Júnior','21','3396-0593','21','3975-0031','nortonarquitetos@uol.com.br',983),
(49315,19731,7,'Arq. Norton C. Maia Júnior','21','3396-0593','21','3975-0031','nortonarquitetos@uol.com.br',983),
(49316,19731,20,'Júlio César','21','3396-0593','21','3975-0031','',983),
(49322,19734,16,'Engº Viriato Augusto Batista','21','2767-7355','','','',10819),
(49323,19734,49,'Engº Viriato Augusto Batista','21','2767-7355','','','',10819),
(49324,19734,20,'Sr. Max','21','2767-7355','','','',10819),
(49377,19750,16,'Bruno','22','2622-4619','22','2622-4619','noriller@hotmail.com',10861),
(49378,19750,49,'Engº Sérgio O. Nogueira Silva','22','2622-4619','22','2622-4619','',10861),
(49379,19750,20,'Sr. Sérgio Ricardo','22','2622-4619','22','2622-4619','',10861),
(49385,19754,16,'Bragato','62','3945-7783','62','3945-7783','bragato@g3construtora.com.br',10858),
(49386,19754,49,'Roberto Renato Penna','62','3549-6593','62','3945-7783','',10858),
(49387,19754,20,'Rafael (Almoxarifado)','62','3549-6593','62','3945-7783','',10858),
(49422,19764,16,'Alexei Cardoso','11','3147-0000','11','3147-0403','alexeicardoso@trisul-sa.com.br',10099),
(49423,19764,29,'Sérgio Basse','11','3147-0000','11','3147-0071','sergiobasse@trisul-sa.com.br',10099),
(49424,19764,20,'Mariana Costa (Marketing)','11','3147-0000','11','3147-0071','marianacosta@trisul-sa.com.br',10099),
(49448,19773,20,'Menache Hamaoui - (Diretor)','11','3486-9040','','','menache@onixtur.com.br',10877),
(49480,19791,16,'Lúcia Ono / Kelly Guilherme','11','5589-6000','11','5589-6539','lucia@tarjab.com.br,kelly@tarjab.com.br',800),
(49481,19791,20,'Ricardo Campane (Marketing)','11','5589-6000','11','5589-6539','campane@tarjab.com.br',800),
(49482,19791,42,'Carlos Alberto Borges','11','5589-6000','11','5589-6539','carlos.borges@tarjab.com.br',800),
(49511,19802,20,'Presley (Contabilidade)','43','3315-5000','43','3315-5019','presley@catuaishopping.com.br',10446),
(63117,19802,16,'Andressa Sitta','43','3315-5005','43','3315-5113','compras@catuaishopping.com.br',10446),
(83617,19802,49,'A definir','43','3315-5000','43','3315-5019','',10446),
(49535,19817,20,'Silvio Barros (Manutenção)','91','4008-5860','91','4008-5855','silvio.barros@patiobelem.com.br',15653),
(49542,19821,16,'Luis Fabiane / Geraldo','43','3379-5000','43','3379-5005','geraldo@graunaconstrucoes.com.br',1956),
(49543,19821,49,'Gilberto e Gustavo','43','3379-5000','43','3379-5005','',1956),
(49544,19821,20,'Sr. Luis Fabiane','43','3379-5000','43','3379-5005','luisfabiane@graunaconstrucoes.com.br',1956),
(49562,19828,16,'Amarildo Carvalho','31','3348-7272','31','3348-7219','amarildo@mrv.com.br',3009),
(49563,19828,20,'Letícia Ramos','31','3348-7135','31','3348-7219','leticia.ramos@mrv.com.br',3009),
(49564,19828,20,'A definir','31','3348-7101','31','3348-7101','',3009),
(49608,19846,16,'Roberto Burttura','19','3512-1800/32','19','3512-1831','buttura@mrv.com.br',4066),
(49609,19846,20,'Letícia Ramos','31','3348-7135','31','3348-7219','leticia.ramos@mrv.com.br',3009),
(49690,19881,20,'Cláudia Martins (Gerente Comercial)','11','2196-0900','11','3253-0262','claudia.martins@interfaceflor.com',10898),
(49691,19881,21,'Claude Quimet (Vice Presidente)','11','2196-0900','11','3253-0262','',10898),
(49692,19882,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(49694,19884,20,'Setor de Licitação','41','3330-3636','41','3330-3344','',463),
(49777,19914,16,'Depto de Suprimentos','11','3847-3522','11','3847-3522','suprimentos@rma.com.br',10911),
(49778,19914,49,'Engª Adriana','11','3847-3522','11','3847-3522','',10911),
(49779,19914,20,'Eliane - (Suprimentos)','11','3847-3522','11','3847-3522','',10911),
(49780,19915,16,'Arq. Jacqueline S. Lacerda','21','2418-5802','21','2418-5802','arqline@uol.com.br',10908),
(49781,19915,7,'Arq. Jacqueline S. Lacerda','21','2418-5802','21','2418-5802','arqline@uol.com.br',10908),
(49782,19915,20,'Jacqueline S. Lacerda','21','2418-5802','21','2418-5802','arqline@uol.com.br',10908),
(49794,19919,29,'Fernando Pozetti','11','3897-0700','11','3846-0628','fernando.pozetti@goldfarb.com.br',316),
(49795,19919,16,'Ana Maria Ribeiro','11','3897-0700','11','3897-0743','anamaria.ribeiro@goldfarb.com.br',316),
(67753,19919,20,'Tatiane Prado (Marketing)','11','3897-0700','11','3846-0628','tatiane.prado@goldfarb.com.br',316),
(49815,19929,16,'Sr. Bruno / Gisela Portelo','21','3416-9001','21','2421-1346','compras@montserrat.com.br',3380),
(54956,19929,49,'Engº Camilo Rebelo Pinto','21','3416-9001','21','2421-1346','detec@montserrat.com.br',3380),
(54957,19929,20,'Isabel Cristina (Comercial)','21','3535-9797','21','3535-9797','comercial@calcada.com.br',1739),
(49859,19950,16,'Osmar de Oliveira','31','3296-8305','31','3296-8305','ciaobra@terra.com.br',4191),
(49860,19950,49,'Henrique Aliaga','31','3639-3949','31','3296-8305','chilealiaga@yahoo.com.br',4191),
(49861,19950,20,'Henrique Aliaga','31','3639-3949','31','3296-8305','chilealiaga@yahoo.com.br',4191),
(49877,19956,16,'Cláudio Porse','11','3021-9928','11','3021-9928','cporse@uol.com.br',10945),
(49878,19956,7,'Cláudio Porse','11','3021-9928','11','3021-9928','cporse@uol.com.br',10945),
(49879,19956,20,'Cláudio Porse','11','3021-9928','11','3021-9928','cporse@uol.com.br',10945),
(50018,20021,20,'Andréia - (Licitação)','21','3133-7469','21','3133-7471','',85),
(50039,20031,16,'Guilherme Nunes','43','3341-4000','43','3341-4000','compras@vectraconstrutora.com.br',5378),
(50040,20031,49,'Armando Cicareli','43','3341-4000','43','3341-4000','armando@vectraconstrutora.com.br',7398),
(50041,20031,20,'Celma (Recursos Humanos)','43','3341-4000','43','3341-4000','vectra@vectraconstrutora.com.br',5378),
(50116,20069,20,'Lúcio Coelho - (Impl. de Empreendim.)','21','2555-4057','21','2555-4035','lucio.coelho@mpx.com.br',2281),
(50310,20145,16,'Denise Vitor','11','3025-9000','11','3025-9111','dvitor@gafisa.com.br',433),
(50311,20145,49,'Oswaldo Oliverti Neto','11','3025-9000','11','3025-9111','ooliverti@gafisa.com.br',433),
(50312,20145,20,'Odair Sales (Adm.)','91','3229-1494','11','3025-9000','obra578900@gafisa.com.br',13251),
(50325,20150,16,'Arqª Vera Maria Leão','21','9196-3645','21','2668-5478','veraleao@uol.com.br',11016),
(50326,20150,7,'Arqª Vera Maria Leão','21','9196-3645','21','2668-5488','veraleao@uol.com.br',11016),
(50341,20150,20,'Mácio','21','2668-5478','21','2668-5478','',11016),
(50371,20161,16,'Waldenir dos Reis','21','2544-0752','21','2262-6186','waldenir@br4.com.br',4068),
(50372,20161,49,'Engº Maurício Veiga Soares de Brito','21','2544-0752','21','2262-6186','br4@br4.com.br',4068),
(50373,20161,20,'Engº Márcio Luis','21','2544-0752','21','2262-6186','eng.mome@gmail.com',4068),
(50419,20176,16,'Izânio Nunes','98','4009-2020','98','4009-2020','izanio@franere.com.br',6538),
(50420,20176,20,'Elisiane Barata','98','4009-2020','98','4009-2020','elisiane@franere.com.br',6538),
(50421,20176,21,'Gerardo Braquehais','98','4009-2020','98','4009-2020','gerardo@franere.com.br',6538),
(50443,20191,16,'Seno Luiz dos Santos','51','3382-7050','51','3382-7054','luiz@goldsztein.com.br',1026),
(50444,20191,20,'Márcio Fagundes','51','3382-7000','51','3382-7000','fagundes@goldsztein.com.br',1026),
(50445,20191,49,'Fernando Bernarde','51','3382-7000','51','3382-7000','',1026),
(50470,20200,20,'Elaine (Assess. de Comunicação)','11','2113-3888','11','2113-3673','',4930),
(66525,20200,67,'Kristhian Kaminski (Ger. Relações Instituc.)','11','2113-3888','11','2113-3673','kristhian.kaminski@sadia.com.br',4930),
(98776,20201,16,'Sra. Maely Oliveira / Givanildo Santos','81','3501-0200 R.0232','','','maely.oliveira@ccioffshore.com.br',6472),
(111998,20201,20,'Sra. Maely Oliveira / Givanildo Santos','81','3501-0200 R.0232','','','maely.oliveira@ccioffshore.com.br',6472),
(50507,20219,20,'Maurício Gonçalves - (Licitação)','31','3250-1607','31','3250-1607','',206),
(50530,20231,16,'Lindomar','22','2647-2100','22','2647-3491','lindomar@construtoramodular.com.br',1458),
(50531,20231,49,'Patrícia Caruso','22','2647-2100','22','2647-3491','patricia@construtoramodular.com.br',1458),
(56579,20231,20,'Patrícia Caruso','22','2647-2100','22','2647-3491','patricia@construtoramodular.com.br',1458),
(50651,20278,16,'Lindolfo da Silva','19','9795-1933','19','3845-3415','malinai@terra.com.br',11088),
(50652,20278,20,'Lindolfo da Silva','19','9795-1933','19','3845-3415','malinai@terra.com.br',11088),
(50661,20281,16,'Arq. Marco A. Valdeolivas','21','9699-1427','22','2771-2491','',11090),
(50662,20281,7,'Arq. Marco A. Valdeolivas','22','7835-2618','22','2771-2491','',11090),
(50663,20281,20,'Arq. Marco A. Valdeolivas','21','2771-2491','','','',11090),
(50767,20319,20,'Carlos Henrique (Diretor)','11','2638-0702','11','2638-0703','',13655),
(50883,20355,20,'Fábio Fernandes','31','3241-2427','31','3343-4588','fabio@premo.com.br',12649),
(60775,20355,49,'Fábio Fernandes','31','3241-2427','31','3343-4588','fabio@premo.com.br',12649),
(60776,20355,16,'Anderson Miranda','31','3343-4588','31','3343-4599','supri@premo.com.br',12649),
(50890,20359,16,'Michele de Freitas Neto','21','2491-3440','21','2491-3440','michele@construtoraharmonia.com.br',11121),
(50891,20359,49,'Clóvis Lima Rocha Bicalho','21','2491-3440','21','2491-3440','',11121),
(50892,20359,20,'Engº Jorge','21','2491-3440','21','2491-3440','',11121),
(50975,20394,16,'Masterson','21','3982-2433','21','3982-2433','comprasrj@celtaengenharia.com.br',10048),
(50976,20394,49,'Hildebert','21','3988-9698','21','3982-2433','beto@celtaengenharia.com.br',10048),
(79973,20394,20,'Atrinne (Compras)','21','3988-9698','21','3982-2433','comprasrj@celtaengenharia.com.br',10048),
(51081,20437,16,'Jânio Freitas','82','3338-3259','82','3338-3423','janio@contratoengenharia.com.br',6963),
(51082,20437,49,'Marcelo Melro','82','9974-6604','82','3338-3259','marcelo@contratoengenharia.com.br',6963),
(51083,20437,20,'Marcelo Melro','82','9974-6604','82','3338-3259','marcelo@contratoengenharia.com.br',6963),
(51084,20438,16,'Jânio Freitas','82','3338-3259','82','3338-3423','janio@contratoengenharia.com.br',6963),
(51085,20438,49,'Marcelo Melro','82','9974-6604','82','3338-3259','marcelo@contratoengenharia.com.br',6963),
(51086,20438,20,'Karine','82','3338-3259','82','3338-3423','contrato@contratoengenharia.com.br',6963),
(51087,20439,49,'Engº Otávio Ehrenfreund','11','5519-9743','11','5542-8933','drmengenharia@uol.com.br',11162),
(51088,20439,20,'Cardoso','11','5519-9743','11','5542-8933','drmengenharia@uol.com.br',11162),
(61764,20439,16,'Malu','11','5542-8933','11','5044-3667','maludrm@uol.com.br',11162),
(51105,20446,16,'Setor Compras','21','2542-2020','21','2542-2506','',5514),
(51106,20446,49,'Engº Carlos José Cunha','21','2542-2020','21','2542-2506','',5514),
(51107,20446,20,'Leonardo Barreto (Diretor Operacional)','21','2760-5344','21','2542-5344','',5514),
(51114,20449,121,'Adalberto Luiz Reno (Diretor)','13','3347-7200','13','3358-2748','alr@wilsonsons.com.br',3927),
(92117,20449,20,'Sr. Solon Pereira de Oliveira (Gerente de Obras)','13','8124-5108','13','3347-7200','spo@wilsonsons.com.br',3927),
(99356,20449,65,'Ana Paula Rodrigues','13','3347-7200 - R. 7208','13','3358-2748','apr@wilsonsons.com.br',3927),
(109660,20449,67,'José Carlos (Ger. Projetos)','13','3347-7200 - R. 7203','13','3347-2748','jca@wilsonsons.com.br',3927),
(51127,20455,16,'Nicolas Matias','21','3325-3826','21','3325-3826','nicolascrater@gmail.com',1742),
(51128,20455,49,'A definir','21','3325-3826','21','3325-3826','',1742),
(51129,20455,20,'Alice Moreira (Recepção)','21','3325-3826','21','3325-3826','alice@crater.com.br',1742),
(51130,20456,16,'Sr. Francisco Pimenta','31','3411-6045','31','3411-6045 - Rm 6','compras@construtoraagata.com.br',9856),
(51131,20456,49,'Engº Roberto Luciano Mendonça','31','3411-6045','31','8482-0954','',9856),
(51132,20456,20,'Sr. Francisco Pimenta','31','3411-6045','31','8282-0954','compras@construtoraagata.com.br',9856),
(51161,20469,16,'Engº Fábio / Cristiano / Marcos','11','2976-6787','11','2976-6787','henriques3@uol.com.br',11178),
(51162,20469,49,'Engº Antônio Henriques','11','2976-6787','11','2976-6787','henriques3@uol.com.br',11178),
(51163,20469,20,'Cristiano','13','3317-2590','11','2976-6787','henriques3@uol.com.br',11178),
(51329,20522,16,'Roberto Rodrigues da Silva','79','3216-5020','79','3216-5094','suprimentos@celi.com.br',427),
(51330,20522,49,'Fred Aoun','81','3339-1095','81','3471-1435','',427),
(51331,20522,20,'Sr. Antônio Melo Júnior','81','9259-0268','81','3471-1435','antoniomelojr@gmail.com',427),
(51345,20529,16,'Flávio Vitor','31','3408-4300','31','3408-4337','flavio.vitor@agnet.com.br',11211),
(51346,20529,49,'Bruno Vilane / Ailton','31','3408-4300','31','3408-4300','',11211),
(51347,20529,20,'Danielle Andrade','31','3408-4300','31','3408-4300','danielle.andrade@agnet.com.br',11211),
(51384,20541,16,'Edcarlos Silva','85','3312-9013','85','3312-9014','aquisicoes2@cameron.eng.br',6599),
(76462,20541,20,'Dalma Carvalho (Planejamento)','85','3312-9000','85','3312-9014','planejamento2@cameron.eng.br',6599),
(82561,20541,16,'Márcio Sobral','85','3312-9013','85','3312-9014','aquisicoes@cameron.eng.br',6599),
(82562,20541,21,'Daniel Farney','85','3312-9000','85','3312-9000','farney@cameron.eng.br',6599),
(51430,20560,20,'Sra. Niobe Cunha (Assessoria de Imprensa)','11','3748-9946','11','3748-0255','cunha.n@pg.com',11221),
(51460,20574,16,'Ramon Floriu','11','2972-8888','11','2972-8888','ramon@msm.eng.br',11237),
(51461,20574,49,'Reneé Peter','11','2972-8888','11','2972-8888','renee@msm.eng.br',11237),
(51462,20574,20,'Armando Rodrigues (RH)','11','2972-8888','11','2972-8888','armando@msm.eng.br',11237),
(59659,20585,20,'Fernando Ragasson','41','3338-6454','41','3338-6454','fernando@grantelengenharia.com.br',13286),
(65706,20585,16,'Fernando Ragasson','41','3338-6454','41','3338-6454','fernando@grantelengenharia.com.br',13286),
(77322,20585,49,'Fernando Ragasson','41','3338-6454','41','3338-6454','fernando@grantelengenharia.com.br',13286),
(51509,20593,16,'Abadias Gomes','66','3544-1113','66','3544-1113','predicon@construtorapredicon.com.br',1484),
(51510,20593,49,'Delmar Saul Salton','66','3544-1113','66','3544-1113','predicon@construtorapredicon.com.br',1484),
(51511,20593,20,'Ademar','66','3544-1113','66','3544-1113','predicon@construtorapredicon.com.br',1484),
(51679,20664,20,'Setor de Licitação','41','3330-3636','41','3330-3636','',463),
(51706,20677,16,'Marcelo Dourado','62','3095-4709','62','3095-4089','marcelodourado2002@@yahoo.com.br',11273),
(51707,20677,49,'Marcelo Dourado','62','3095-4709','62','3095-4089','marcelodourado2002@yahoo.com.br',11273),
(51708,20677,20,'Natália Silva (Compra)','62','3095-4709','62','3095-4089','souzadourado@terra.com.br',11273),
(51729,20685,16,'Fabio Humar','11','5574-5070','11','5574-5074 - R: 104','fabio@g9incorporadora.com.br',8058),
(51730,20685,49,'Durval Souza Filho','11','5574-5070','11','5574-5074 - R: 104','durval@g9incorporadora.com.br',8058),
(51731,20685,20,'Durval Souza Filho','11','5574-5070','11','5574-5070 - R: 104','durval@g9incorporadora.com.br',8058),
(51732,20686,16,'Adélia Pereira','11','3082-8285','11','3067-5922','compras@tcptecnicorp.com.br',1618),
(51733,20686,49,'Márcio Melaragno','11','3082-8285','11','3067-5922','marcio@tcptecnicorp.com.br',1618),
(51734,20686,20,'Márcio Melaragno','11','3082-8285','11','3067-5922','marcio@tcptecnicorp.com.br',1618),
(51736,20687,16,'Patrícia Daniela','84','3222-1000','84','3079-7609','compras@mouradubeux.com.br',11275),
(72967,20687,70,'José Freire Beltrão Neto','84','9143-6110','84','3222-1000','neto@mouradubeux.com.br',11275),
(79580,20687,49,'Diogo Barralo','84','3222-0642','84','3222-1000','hannasafieh@mouradubeux.com.br',11275),
(79581,20687,20,'Severino Júnior (Almoxarife)','84','3222-0642','84','3222-1000','hannasafieh@mouradubeux.com.br',11275),
(51758,20697,20,'Érika Sousa (Diretoria)','11','3819-1166','11','3813-3292','erika@jzm.com.br',2562),
(51759,20697,16,'Rodolfo Pereira','11','3819-1166','11','3813-3292','compras@jzm.com.br',2562),
(71005,20697,49,'José Martin','11','3819-1166','11','3813-3292','josemartin@jzm.com.br',2562),
(51779,20708,54,'Arão Rodrigues','34','3319-6400','34','3319-6400','',11289),
(51780,20708,20,'Araken Barbosa M. J. (Setor Financeiro)','34','3319-6400','34','3319-6400','',11289),
(51781,20708,56,'Bartolomeu Balbino','34','3319-6400','34','3319-6496','bartolomeub@gclnet.com.br',11289),
(51782,20709,54,'Arão Rodrigues','34','3319-6400','34','3319-6400','',11289),
(51783,20709,20,'Araken Barbosa M. J. (Setor Financeiro)','34','3319-6400','34','3319-6440','',11289),
(51784,20709,56,'Bartolomeu Balbino','34','3319-6400','34','3319-6496','bartolomeub@gclnet.com.br',11289),
(51785,20710,54,'Arão Rodrigues','34','3319-6400','34','3319-6400','',11289),
(51786,20710,20,'Araken Barbosa M. J. (Setor Financeiro)','34','3319-6400','34','3319-6400','',11289),
(51787,20710,56,'Bartolomeu Balbino','34','3319-6400','34','3319-6496','bartolomeub@gclnet.com.br',11289),
(51809,20718,16,'Alessandra Grell / Silvia Guastella','11','3127-9200','11','3127-9260','alessandra.grell@br.brookfield.com',430),
(51810,20718,20,'Ricardo Darcin (Comercial)','11','4994-8322','11','4994-8322','ricardo@grupogrotta.com.br',2117),
(51811,20718,49,'Cláudia Pisher','11','3127-9200','11','3127-9260','',430),
(51813,20719,16,'Fernando Luiz / Rita de Sá','21','3415-4248','21','3415-4248','aliadosempr@uol.com.br',4065),
(51814,20719,49,'Arq. Francisco Canário','21','3415-4248','21','3415-4248','aliadosempr@uol.com.br',4065),
(51815,20719,20,'Rita de Sá (Compras)','21','3415-4248','21','3415-4248','aliadosempr@uol.com.br',4065)


;

INSERT INTO #Obra
     ([Id_obra],[Obra])

VALUES

(26,'EC001607'),
(73,'CO143508'),
(74,'EC001728'),
(138,'BC001682'),
(139,'AB001495'),
(141,'BC001683'),
(287,'CC001057'),
(432,'CO148536'),
(479,'CO190436'),
(508,'FA000570'),
(535,'AB001716'),
(691,'EC002712'),
(692,'EC002713'),
(793,'CO191678'),
(892,'RE002861'),
(995,'CO192182'),
(1454,'CO192984'),
(1492,'DT000305'),
(1521,'RE004667'),
(1786,'AB001839'),
(1930,'RE004907'),
(2031,'SI000807'),
(2066,'NF000876'),
(2144,'EC003047'),
(2268,'RE006593'),
(2916,'MI000628'),
(3253,'RE007836'),
(3255,'RE007835'),
(3446,'RE008049'),
(3910,'PG001065'),
(4445,'EC003130'),
(4508,'RE008918'),
(4791,'RE009063'),
(5058,'EC003161'),
(5568,'EC003171'),
(5569,'EC003172'),
(5577,'EC003169'),
(5578,'EC003170'),
(5599,'CO195674'),
(5600,'CO195676'),
(5848,'BC002136'),
(6002,'RE010147'),
(6149,'EC003182'),
(6150,'EC003183'),
(6304,'RE010315'),
(6308,'EC003212'),
(6311,'EC003214'),
(6315,'EC003217'),
(6316,'EC003218'),
(6317,'EC003219'),
(6318,'EC003220'),
(6319,'EC003221'),
(6348,'CM000748'),
(7004,'RE010606'),
(7070,'RE010613'),
(7247,'RE010818'),
(7520,'SI000858'),
(7537,'RE010995'),
(7806,'RE011077'),
(7807,'RE011078'),
(8251,'AI000374'),
(8301,'RE011562'),
(8336,'RE011534'),
(8338,'RE011537'),
(8349,'RE011812'),
(8892,'CO199082'),
(8958,'RE011977'),
(9238,'RE011936'),
(9269,'RE011937'),
(9351,'RE011942'),
(9685,'RE012448'),
(9766,'CO197220'),
(9822,'EC003285'),
(9874,'EC003286'),
(9875,'EC003287'),
(9925,'RE012474'),
(9981,'MI000655'),
(10163,'EC003308'),
(10176,'RE012730'),
(10179,'RE012729'),
(10301,'RE012837'),
(10359,'CM000808'),
(10363,'EC003307'),
(10537,'CO197301'),
(10553,'EC003358'),
(10582,'EC003309'),
(11001,'RE013064'),
(11256,'RE013342'),
(11301,'RE013391'),
(11590,'CO197980'),
(11660,'RE013640'),
(11782,'RE013537'),
(12051,'CO197953'),
(12166,'BC002277'),
(12314,'RE013620'),
(12842,'SB004316'),
(12853,'RE014305'),
(12928,'CO198328'),
(12981,'RE014252'),
(13220,'EC003484'),
(13221,'EC003485'),
(13293,'RE014501'),
(13295,'RE014503'),
(13304,'BC002288'),
(13308,'EC003509'),
(13312,'EC003512'),
(13315,'EC003510'),
(13316,'EC003520'),
(13318,'EC003516'),
(13354,'EC003524'),
(13367,'EC003521'),
(13369,'EC003526'),
(13385,'EC003542'),
(13391,'EC003540'),
(13395,'EC003522'),
(13429,'EC003545'),
(13434,'EC003544'),
(13525,'EC003564'),
(13526,'EC003565'),
(13551,'EC003579'),
(13581,'EC003587'),
(13593,'EC003586'),
(13596,'EC003584'),
(13717,'CO198600'),
(13718,'CO198602'),
(13719,'CO198601'),
(13720,'CO198599'),
(13721,'CO198598'),
(13878,'RE014716'),
(13924,'RE014739'),
(13931,'RE014738'),
(13956,'RE014761'),
(13965,'RE014756'),
(14005,'CO198700'),
(14006,'RE014791'),
(14007,'CO198699'),
(14010,'CO198704'),
(14017,'CO198703'),
(14018,'CO198702'),
(14049,'RE014806'),
(14087,'RE014828'),
(14103,'RE014827'),
(14129,'RE014885'),
(14209,'CO198770'),
(14260,'CO198757'),
(14388,'EC003703'),
(14397,'RE014975'),
(14566,'RE015149'),
(14591,'RE015135'),
(14598,'RE015136'),
(14599,'RE015137'),
(14612,'CO198941'),
(14732,'CO198932'),
(14739,'QP001692'),
(14759,'SB004356'),
(14761,'MC000709'),
(14772,'CO198925'),
(14784,'BC002317'),
(14911,'AI000422'),
(14979,'BC002316'),
(14994,'RE015316'),
(15149,'RE015357'),
(15154,'SB004380'),
(15156,'RE015356'),
(15159,'RE015380'),
(15161,'RE015374'),
(15170,'RE015364'),
(15187,'RE015375'),
(15205,'RE015384'),
(15245,'RE015413'),
(15333,'CO199205'),
(15335,'RE015445'),
(15424,'RE015489'),
(15427,'CO199226'),
(15436,'MC000719'),
(15441,'RE015497'),
(15444,'CO199231'),
(15600,'AB002085'),
(15660,'NF000911'),
(15698,'FC001552'),
(15929,'RE015750'),
(15955,'RE015793'),
(15960,'RE015795'),
(15975,'CO199397'),
(15978,'RE015808'),
(16010,'RE015818'),
(16118,'RE015872'),
(16208,'SB004387'),
(16253,'RE015931'),
(16254,'RE015930'),
(16264,'RE015956'),
(16284,'BC002359'),
(16394,'CO199570'),
(16396,'CO199575'),
(16418,'CO199577'),
(16425,'RE016055'),
(16492,'RE016108'),
(16770,'RE016271'),
(16785,'CO199687'),
(16806,'CO199708'),
(16840,'FC001556'),
(17010,'RE016400'),
(17043,'AI000450'),
(17060,'RE016428'),
(17086,'AB002119'),
(17088,'RE016414'),
(17132,'FC001560'),
(17154,'BC002380'),
(17156,'BC002381'),
(17157,'BC002379'),
(17162,'BC002382'),
(17197,'BC002378'),
(17208,'RE016516'),
(17216,'AB002125'),
(17291,'RE016524'),
(17310,'RE016559'),
(17326,'CO199899'),
(17342,'PG001147'),
(17346,'RE016577'),
(17409,'RE016609'),
(17516,'CO199979'),
(17563,'RE016697'),
(17660,'RE016721'),
(17668,'RE016730'),
(17683,'RE016740'),
(17727,'RE016776'),
(17740,'RE016775'),
(17852,'RE016855'),
(17881,'RE016839'),
(17883,'RE016873'),
(17912,'BC002388'),
(17926,'RE016906'),
(18016,'EE000422'),
(18097,'RE017000'),
(18113,'RE017005'),
(18125,'RE016995'),
(18139,'RE017009'),
(18140,'RE017022'),
(18247,'RE017071'),
(18378,'RE017126'),
(18419,'CO200271'),
(18427,'RE017155'),
(18428,'CO200270'),
(18436,'CO200273'),
(18438,'CO200272'),
(18507,'BC002393'),
(18543,'RE017202'),
(18545,'BC002394'),
(18563,'CO200321'),
(18594,'RE017241'),
(18598,'RE017239'),
(18609,'RE017230'),
(18641,'RE017270'),
(18644,'RE017274'),
(18649,'RE017265'),
(18681,'CO200357'),
(18684,'SB004478'),
(18718,'CO200379'),
(18719,'CO200381'),
(18720,'CO200382'),
(18721,'CO200383'),
(18722,'CO200384'),
(18734,'CO200394'),
(18746,'RE017299'),
(18775,'CO200411'),
(18871,'CO200468'),
(18892,'RE017346'),
(18894,'RE017349'),
(18895,'RE017350'),
(18990,'RE017414'),
(19029,'RE017422'),
(19101,'RE017458'),
(19113,'RE017461'),
(19138,'RE017493'),
(19140,'RE017483'),
(19144,'RE017487'),
(19145,'RE017485'),
(19146,'RE017492'),
(19153,'RE017513'),
(19164,'RE017504'),
(19170,'RE017507'),
(19180,'RE017508'),
(19182,'RE017512'),
(19193,'RE017520'),
(19222,'AB002156'),
(19228,'AB002155'),
(19253,'RE017543'),
(19260,'RE017547'),
(19269,'RE017541'),
(19273,'PG001153'),
(19275,'RE017542'),
(19313,'CO200629'),
(19320,'PG001154'),
(19331,'RE017561'),
(19345,'AI000472'),
(19363,'BC002428'),
(19430,'CO200673'),
(19502,'RE017634'),
(19516,'AB002163'),
(19589,'RE017686'),
(19600,'BC002455'),
(19629,'CO200739'),
(19638,'AB002165'),
(19640,'MI000679'),
(19701,'RE017719'),
(19720,'AI000482'),
(19731,'CO200770'),
(19734,'RE017764'),
(19750,'RE017811'),
(19754,'RE017773'),
(19764,'RE017812'),
(19773,'CO200798'),
(19791,'RE017825'),
(19802,'CO200802'),
(19817,'RE017774'),
(19821,'RE017807'),
(19828,'RE017752'),
(19846,'CO200821'),
(19881,'CO200833'),
(19882,'RE017829'),
(19884,'RE017820'),
(19914,'AI000485'),
(19915,'AI000486'),
(19919,'RE017832'),
(19929,'RE017833'),
(19950,'RE017849'),
(19956,'RE017847'),
(20021,'CO200857'),
(20031,'CO200853'),
(20069,'RE017902'),
(20145,'RE017928'),
(20150,'CO200878'),
(20161,'RE017946'),
(20176,'CO200908'),
(20191,'FC001565'),
(20200,'RE017942'),
(20201,'RE017958'),
(20219,'PC000648'),
(20231,'RE017962'),
(20278,'EC003914'),
(20281,'EC003917'),
(20319,'CO200961'),
(20355,'CO200997'),
(20359,'CO200998'),
(20394,'RE018038'),
(20437,'QP001724'),
(20438,'QP001727'),
(20439,'RE018067'),
(20446,'RE018072'),
(20449,'RE018073'),
(20455,'RE018074'),
(20456,'RE028076'),
(20469,'RE018082'),
(20522,'RE018180'),
(20529,'RE018118'),
(20541,'CO201057'),
(20560,'BC002475'),
(20574,'CO201075'),
(20585,'CO201052'),
(20593,'RE018143'),
(20664,'RE018209'),
(20677,'RE018215'),
(20685,'RE018208'),
(20686,'RE018206'),
(20687,'RE018207'),
(20697,'RE018167'),
(20708,'CO201109'),
(20709,'CO201108'),
(20710,'CO201107'),
(20718,'CO201104'),
(20719,'CO201105')


;

select ' Projeto,Contato1,Cargo1,DDD1,Telefone1,DDDFax1,Fax1,Email1,Empresa01, Contato2,Cargo2,DDD2,Telefone2,DDDFax2,Fax2,Email2,Empresa02, Contato3,Cargo3,DDD3,Telefone3,DDDFax3,Fax3,Email3,Empresa03, Contato4,Cargo4,DDD4,Telefone4,DDDFax4,Fax4,Email4,Empresa04
Contato5,Cargo5,DDD5,Telefone5,DDDFax5,Fax5,Email5,Empresa05, Contato6,Cargo6,DDD6,Telefone6,DDDFax6,Fax6,Email6,Empresa06
Contato7,Cargo7,DDD7,Telefone7,DDDFax7,Fax7,Email7,Empresa07, Contato8,Cargo8,DDD8,Telefone8,DDDFax8,Fax8,Email8,Empresa08
' as 'linha' 
union all
 select o.Obra+','+
( 
  SELECT ContatoNome +','+id_cargo+','+ddd+','+telefone+','+dddfax+','+fax+','+email+',' AS 'data()' 
         FROM #Contato where id_obra = o.Id_obra FOR XML PATH('')
         )
from #Obra as o

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results