November 8, 2012 at 8:49 am
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0016050002', 'A', Null, 'TP7', Null, Null, Null, '3ª CONSERVATORIA DO REG.CIVIL DA COMARCA DE LUANDA', 'MAIANGA', Null, Null, '', '', '01', '', '4.01', '', Apr 26 2004 12:00AM, Nov 6 2012 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, 'S4.01-692161', 'A', Null, 'TP7', Null, Null, Null, '3ª.SECCAO DA SALA DE FAMILIA -TRIBUNAL PROV.LUANDA', 'RUA AMILCAR CABRAL, Nº.29- 5º.ANDAR', Null, Null, '912453984', '', '11', '', '4.01', '040101', Oct 3 2008 12:00AM, Nov 6 2012 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '85019998', 'I', Null, 'TP1', Null, Null, Null, 'MARIO JOSE LISBOA', 'RUA 12 CASA Nº27', Null, Null, '', '', '04', '', '4.01', '', Jan 3 2007 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267547', 'I', Null, 'TP1', Null, Null, Null, 'ANA CASSINDA', 'B' BOA VISTA CASA S/N'', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267553', 'I', Null, 'TP1', Null, Null, Null, 'ABILIO PUPANASSI', 'B' HOSPITAL CASA S/N'', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267560', 'I', Null, 'TP1', Null, Null, Null, 'ENOC ZEFERINO', 'B' NOVA PELE CASA S/N'', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267576', 'I', Null, 'TP1', Null, Null, Null, 'CONSTANCIA CHAPANGA', 'B' KATAPI CASA S/N' ZONA E', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267582', 'I', Null, 'TP1', Null, Null, Null, 'MARIANA ANGELICA NACALANDULA', 'B' CALUEIO CASA N'194', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267599', 'I', Null, 'TP1', Null, Null, Null, 'MARIA ANTONIA NAMATELE', 'AV' DA REPUBLICA CASA N'45', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267607', 'I', Null, 'TP1', Null, Null, Null, 'EVALINA FEBE SASSAMBA', 'B' KATAPI CASA S/N' ZONA B1', Null, Null, '', '', '', '', '4.01', '', Oct 18 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10407702', 'I', Null, 'TP1', Null, Null, Null, 'ELISA VUNGE', 'BAIRRO PANGUILA-CACUACO', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279579', 'I', Null, 'TP1', Null, Null, Null, 'NINITA GARCIA RALHA', 'BAIRRO CAOP-CASAS NOVAS', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279585', 'I', Null, 'TP1', Null, Null, Null, 'EVARISTO SAPIO SEGUNDA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10305574', 'I', Null, 'TP1', Null, Null, Null, 'ENGRACIA SEBASTIAO CAETANO DA SILVA', 'BAIRRO ECOCAMPO,CASA Nº77A', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279616', 'I', Null, 'TP1', Null, Null, Null, 'FRANCISCO SALVADOR JUNIOR', 'BºNGOLA KILUANJE,CASA Nº5-BV,Nº162,Z.16', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279600', 'I', Null, 'TP1', Null, Null, Null, 'ALZIRA CHOCONUMBI NEHEMA VENTURA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279622', 'I', Null, 'TP1', Null, Null, Null, 'TERESA DOMINGOS', 'BAIRRO NDALA MULEMBA', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279639', 'I', Null, 'TP1', Null, Null, Null, 'MERARI RODRIGUEZ CAPOBRES', 'Bº MACULUSSO, Rº KWAMME NKRUMAH, APTºB', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10312930', 'I', Null, 'TP1', Null, Null, Null, 'ANTUNES ALBERTO', 'BAIRRO DA CALEMBA-MAIANGA', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279645', 'I', Null, 'TP1', Null, Null, Null, 'EUSEBIO IVO', 'BAIRRO KICOLO-CACUACO', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279651', 'I', Null, 'TP1', Null, Null, Null, 'SABALO LUIS MIRANDA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', Dec 7 2005 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698129', 'I', Null, 'TP1', Null, Null, Null, 'TAVARES BERNARDO ANTONIO', 'BAIRRO DA CAOP PREDIO', Null, Null, '', '', '04', '', '4.01', '', Nov 2 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698141', 'I', Null, 'TP1', Null, Null, Null, 'HILDEBRANDE DE MELO ARAUJO', 'BAIRRO DA TECNOCARRO', Null, Null, '', '', '04', '', '4.01', '', Nov 2 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698135', 'I', Null, 'TP1', Null, Null, Null, 'ZEFERINO MARCIAL', 'BAIRRO KICOLO', Null, Null, '', '', '04', '', '4.01', '', Nov 2 2006 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112811000', 'i', Null, 'TP5', Null, Null, Null, 'MARIA JOAO DE OLIVEIRA', 'BAIRRO KASSEQUEL,ZONA 9,RUA 54,N.20', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112812007', 'i', Null, 'TP5', Null, Null, Null, 'LUZIA JOAO DOMINGOS', 'BAIRRO KASSEQUEL,ZONA 9,RUA 47,CASA N.24', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112815006', 'i', Null, 'TP5', Null, Null, Null, 'JOAO SIMAO MUHONGO', 'BAIRRO CAZENGA ZONA 18 CASA N.16', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112816002', 'i', Null, 'TP5', Null, Null, Null, 'MANUEL FRANCISCO JOAO LOURENCO', 'BAIRRO NEVES BENDINHA CASA N.27', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112818005', 'i', Null, 'TP5', Null, Null, Null, 'JOSEFA DOMINGOS', 'BAIRRO CALEMBA CASA N.1-CA-73', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112819001', 'i', Null, 'TP5', Null, Null, Null, 'FELISBINA M. ESPIRITO SANTO PEREIRA', 'BAIRRO N. BENDINHA,CASA N.35,R. VIOLETA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112822002', 'i', Null, 'TP5', Null, Null, Null, 'MADALENA JOAO', 'B.MACULUSSO RUA G.CARMONA Nº57', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112824005', 'i', Null, 'TP5', Null, Null, Null, 'MANUEL KIALA', 'BAIRRO N. BENDINHA ZONA 12 R.ODP N. 11', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112831001', 'i', Null, 'TP5', Null, Null, Null, 'SEBASTIAO NANI KUNZAILAO', 'B.KILAMBA KIAXI CASA S/N R.NGOLA MBANDI', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112842003', 'i', Null, 'TP5', Null, Null, Null, 'VICTORIA INACIO TEIXEIRA ALVES BEBIANO', 'RUA FERREIRA DE AMARAL Nº167 1ºANDAR', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112845002', 'i', Null, 'TP5', Null, Null, Null, 'SABINO CRISTOVAO', 'BAIRRO CAZENGA,ZONA 18,7.AV. CASA 85', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112846009', 'i', Null, 'TP5', Null, Null, Null, 'JOAO ANTONIO FRAGOSO', 'BAIRRO KILAMBA KIAXI,ZONA 20,CASA 55', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715760', 'I', Null, 'TP1', Null, Null, Null, 'LULEMBA SOFIA', 'BAIRRO KIKOLO CASA 119 RUA 119', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715813', 'I', Null, 'TP1', Null, Null, Null, 'JOANA PEREIRA DA SILVA JOAO', 'RUA CIRILIO DA CONCEICAO Nº 25', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715820', 'I', Null, 'TP1', Null, Null, Null, 'MARIA JOAO CARDEAU CARNEIRO LOPES ALVES', 'BAIRRO MAIANGA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715842', 'I', Null, 'TP1', Null, Null, Null, 'LUIS DOMINGOS VALENTE', 'Bº NELITO SOARES Z/14', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715871', 'I', Null, 'TP2', Null, Null, Null, 'JOSE JOAO MANGUEIRA VAN-DUNEM', 'RUA RAINHA GINGA Nº 9 5º ANDAR', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715894', 'I', Null, 'TP1', Null, Null, Null, 'ISIDRO MIGUEL JOAO', 'BAIRRO RANGEL CASA Nº 20', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04717858', 'I', Null, 'TP1', Null, Null, Null, 'ROSA GARCIA JOAO', 'BºMIRAMAR 12 ZONA 10', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718220', 'I', Null, 'TP1', Null, Null, Null, 'JOSE MANUEL DOS SANTOS MENDONCA GAMBOA', 'RUA MISES CAMILO 180-4º 42', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718237', 'I', Null, 'TP1', Null, Null, Null, 'DOMINGOS DOS SANTOS MARIA FERNANDES', 'INGOMBOTA RUA SEVEIRA PEREIRA N' 5 5.39', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718272', 'I', Null, 'TP1', Null, Null, Null, 'EDUARDO DA SILVA RIBEIRO', 'RUA FREDERICO WELWICHIA 11 B', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718540', 'I', Null, 'TP1', Null, Null, Null, 'RAIMUNDO ANDRE MANUEL', 'B'NELITO SOARES Z.11 RUA CZ CASA N.17', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718579', 'I', Null, 'TP1', Null, Null, Null, 'CANDIDO FORBS', 'BºSAMBIZANGA 5 BV-7', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718600', 'I', Null, 'TP1', Null, Null, Null, 'MPANZU FRANCOIS', 'Bº N.BENDINHA ZONA 12', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718881', 'I', Null, 'TP1', Null, Null, Null, 'MARIA EDUARDO', 'BAIRRO PATRICE LUMUMBA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718898', 'I', Null, 'TP1', Null, Null, Null, 'BARTOLOMEU JOAO DOS SANTOS', 'BAIRRO CAZENGA ZONA 18 SECTOR 14', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718964', 'I', Null, 'TP1', Null, Null, Null, 'JOSE MANUEL DEMBO', 'B' SAMBIZANGA 1/MO/363', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04719018', 'I', Null, 'TP1', Null, Null, Null, 'SACKHO BOUBACAR', 'Bº HOJI-YA-HENDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375632', 'I', Null, 'TP1', Null, Null, Null, 'PEDRO DA COSTA BOANA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375655', 'I', Null, 'TP1', Null, Null, Null, 'NELSON DIOGO FRANCISCO DE OLIVEIRA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375661', 'I', Null, 'TP1', Null, Null, Null, 'LINO JOAO DA COSTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375678', 'I', Null, 'TP1', Null, Null, Null, 'ANTONIO MIGUEL FASTUDO FERREIRA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375690', 'I', Null, 'TP1', Null, Null, Null, 'MANUEL GASPAR ANTONIO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375709', 'I', Null, 'TP1', Null, Null, Null, 'PAULO MANUEL NUNES SEBASTIAO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375738', 'I', Null, 'TP1', Null, Null, Null, 'CRISTINA NZAMBI', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375879', 'I', Null, 'TP1', Null, Null, Null, 'CLAUDIO ANTONIO LIMA ARTUR', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02376100', 'I', Null, 'TP1', Null, Null, Null, 'DOMBELE SILVA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377186', 'I', Null, 'TP1', Null, Null, Null, 'CRISTINA EMILIA SIMAO MANUEL', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377217', 'I', Null, 'TP1', Null, Null, Null, 'RODRIGO DA COSTA BATALHA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377223', 'I', Null, 'TP1', Null, Null, Null, 'JOSE JOAO FAZ CONTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Jun 11 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377230', 'I', Null, 'TP1', Null, Null, Null, 'JOSE FRANCISCO DA SILVA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377252', 'I', Null, 'TP1', Null, Null, Null, 'SEBASTIAO BENTO PEDRO DA COSTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377298', 'I', Null, 'TP1', Null, Null, Null, 'TALAMI GARCIA MIEZI', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377306', 'I', Null, 'TP1', Null, Null, Null, 'MIGUEL MAQUIESE QUINANGA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377312', 'I', Null, 'TP1', Null, Null, Null, 'MULANGUI FRANCO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377329', 'I', Null, 'TP1', Null, Null, Null, 'FERNANDO MIGUEL VAZ', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377370', 'I', Null, 'TP1', Null, Null, Null, 'MARIA CAROLINA GUERREIRO DA S.SALAVISA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377387', 'I', Null, 'TP1', Null, Null, Null, 'ALEXANDRE ALBERTO EDUARDO JOAQUIM', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01405940', 'i', Null, 'TP1', Null, Null, Null, 'CATARINA VALE MELO', 'RUA HOJY YA HENDA N:144', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01405957', 'i', Null, 'TP1', Null, Null, Null, 'JOAQUIM DE OLIVEIRA DOS SANTOS CEA', 'BAIRRO OPERARIO,RUA C N:67', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396796', 'I', Null, 'TP1', Null, Null, Null, 'VICENTE NOE ANTONIO SEBASTIAO', 'B. NGOLA KILUANGE', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396810', 'I', Null, 'TP1', Null, Null, Null, 'FRANCISCO JOAO CRISTOVAO NETO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396827', 'I', Null, 'TP1', Null, Null, Null, 'KINKADI JOAO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01399932', 'I', Null, 'TP1', Null, Null, Null, 'ALEXANDRE MANUEL NETO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054589002', 'i', Null, 'TP5', Null, Null, Null, 'VIS-A-VIS-COMER.GERAL AGRO-PECUARIA, LDA', 'Bº PALANCA ZONA 12', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054592003', 'i', Null, 'TP5', Null, Null, Null, 'DIENGA NSANGU LUIS', 'BºNEVES BENDINHA C.REGRESSADOS', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054593000', 'i', Null, 'TP5', Null, Null, Null, 'JOAO PEREIRA MASSAMO', 'BºPATRICE LUMUMBA R.TIMOR 40', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054594006', 'i', Null, 'TP5', Null, Null, Null, 'KUHENHA-SOCIEDADE DE COMERCIO GERAL, LDA', 'BºNEVES BENDINHA RUA DA GABELA Nº125', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '00546006', 'I', Null, 'TP1', Null, Null, Null, 'KIAMBI GRACA', 'BºNGOLA KILUANGE', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054627001', 'i', Null, 'TP5', Null, Null, Null, 'PEDRO JACINTO GUMBA', 'BAIRRO MARCAL', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054628008', 'i', Null, 'TP5', Null, Null, Null, 'VICTOR DA FONSECA FRANCISCO', 'BºP.LUMUMBA-PRAC.REI KATYAVALA R/C 1º 11', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054629004', 'i', Null, 'TP5', Null, Null, Null, 'ESTEVES ANTONIO', 'BAIRRO CAZENGA ZONA 18 CASA Nº 30', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054630002', 'i', Null, 'TP5', Null, Null, Null, 'AFONSO PEREIRA', 'BAIRRO HOJI YA HENDA Nº 15', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054631009', 'i', Null, 'TP5', Null, Null, Null, 'ARMANDO GONGO CASSANGE', 'KILAMBA KIAXI Nº 15-A', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054632005', 'i', Null, 'TP5', Null, Null, Null, 'PROMOCOES SEBRIN, LDA', 'AVªCDTE HOJI YA HENDA Nº 100 3ºE', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054634008', 'i', Null, 'TP5', Null, Null, Null, 'ADRIANO DOMINGOS DA SILVA', 'Bº KILAMBA KIAXI Nº 286', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054635004', 'i', Null, 'TP5', Null, Null, Null, 'RITA DO ROSARIO FERREIRA PEREIRA-RINEL', 'RUA LOPES DE LIMA Nº30', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054636000', 'i', Null, 'TP5', Null, Null, Null, 'CORDEIRO ERNESTO NZAKUNDOMBA', 'BºKILAMBA KIAXI Z.20 SUBZ.15 CASA Nº45', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054637007', 'i', Null, 'TP5', Null, Null, Null, 'VENTURA DOMINGOS FRANCISCO', 'Bº KASSEQUEL ZONA 9 CASA Nº 18', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054639000', 'i', Null, 'TP5', Null, Null, Null, 'PAULO JAIME SERGIO CAPELO', 'BAIRRO NELITO SOARES RUA DOURO Nº111/A', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054640008', 'i', Null, 'TP5', Null, Null, Null, 'ANDRE FRANCISCO', 'Bº GOLF MUNICIPIO KILAMBA KIAXI', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054641004', 'i', Null, 'TP5', Null, Null, Null, 'EXPROPEC-EXPLOR.AGRO-PECUARIA COM., LDA', 'Bº VALODIA PREDIO PREDIO 294 1º 11', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054642000', 'i', Null, 'TP5', Null, Null, Null, 'SOKWANZA-SOC.COM.PROD.QUIM.FARMAC., LDA', 'RUA HIGINO AIRES Nº 22 B', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054643007', 'i', Null, 'TP5', Null, Null, Null, 'MAVILDE DE FATIMA BESSA TEIXEIRA', 'VILA ALICE RUA EUGENIO DE CASTRO 45', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '03347537', 'I', Null, 'TP1', Null, Null, Null, 'DARIO ROBERTO MACHADO E SILVA', 'BºALVALADE', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
November 8, 2012 at 8:56 am
I will assume you didn't actually run these inserts. It is chock full of syntax errors. The dates don't have quotes around them and there appear to be lots of varchar values that don't have the quotes escaped. None of the lines have a closing ). Yes I could probably spend the next hour or so and clean this up but I would prefer to spend my time working on your problem instead of cleaning up this stuff.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 8, 2012 at 9:42 am
Sorry, let me see what is rong with my query.
November 8, 2012 at 9:43 am
all the lines have )
example:
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '03347537', 'I', Null, 'TP1', Null, Null, Null, 'DARIO ROBERTO MACHADO E SILVA', 'BºALVALADE', Null, Null, '', '', '04', '', '4.01', '', Apr 26 2004 12:00AM, Jan 1 1900 12:00AM, Jan 1 1900 12:00AM, Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
November 8, 2012 at 9:45 am
I think you are refering to my first post of inserts not my second post
November 8, 2012 at 9:51 am
Have a look at this third insert:
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0016050002', 'A', Null, 'TP7', Null, Null, Null, '3ª CONSERVATORIA DO REG.CIVIL DA COMARCA DE LUANDA', 'MAIANGA', Null, Null, '', '', '01', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Nov 6 2012 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, 'S4.01-692161', 'A', Null, 'TP7', Null, Null, Null, '3ª.SECCAO DA SALA DE FAMILIA -TRIBUNAL PROV.LUANDA', 'RUA AMILCAR CABRAL, Nº.29- 5º.ANDAR', Null, Null, '912453984', '', '11', '', '4.01', '040101', 'Oct 3 2008 12:00AM', 'Nov 6 2012 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '85019998', 'I', Null, 'TP1', Null, Null, Null, 'MARIO JOSE LISBOA', 'RUA 12 CASA Nº27', Null, Null, '', '', '04', '', '4.01', '', 'Jan 3 2007 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267547', 'I', Null, 'TP1', Null, Null, Null, 'ANA CASSINDA', 'B' BOA VISTA CASA S/N'', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267553', 'I', Null, 'TP1', Null, Null, Null, 'ABILIO PUPANASSI', 'B' HOSPITAL CASA S/N'', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267560', 'I', Null, 'TP1', Null, Null, Null, 'ENOC ZEFERINO', 'B' NOVA PELE CASA S/N'', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267576', 'I', Null, 'TP1', Null, Null, Null, 'CONSTANCIA CHAPANGA', 'B' KATAPI CASA S/N' ZONA E', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267582', 'I', Null, 'TP1', Null, Null, Null, 'MARIANA ANGELICA NACALANDULA', 'B' CALUEIO CASA N'194', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267599', 'I', Null, 'TP1', Null, Null, Null, 'MARIA ANTONIA NAMATELE', 'AV' DA REPUBLICA CASA N'45', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267607', 'I', Null, 'TP1', Null, Null, Null, 'EVALINA FEBE SASSAMBA', 'B' KATAPI CASA S/N' ZONA B1', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10407702', 'I', Null, 'TP1', Null, Null, Null, 'ELISA VUNGE', 'BAIRRO PANGUILA-CACUACO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279579', 'I', Null, 'TP1', Null, Null, Null, 'NINITA GARCIA RALHA', 'BAIRRO CAOP-CASAS NOVAS', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279585', 'I', Null, 'TP1', Null, Null, Null, 'EVARISTO SAPIO SEGUNDA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10305574', 'I', Null, 'TP1', Null, Null, Null, 'ENGRACIA SEBASTIAO CAETANO DA SILVA', 'BAIRRO ECOCAMPO,CASA Nº77A', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279616', 'I', Null, 'TP1', Null, Null, Null, 'FRANCISCO SALVADOR JUNIOR', 'BºNGOLA KILUANJE,CASA Nº5-BV,Nº162,Z.16', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279600', 'I', Null, 'TP1', Null, Null, Null, 'ALZIRA CHOCONUMBI NEHEMA VENTURA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279622', 'I', Null, 'TP1', Null, Null, Null, 'TERESA DOMINGOS', 'BAIRRO NDALA MULEMBA', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279639', 'I', Null, 'TP1', Null, Null, Null, 'MERARI RODRIGUEZ CAPOBRES', 'Bº MACULUSSO, Rº KWAMME NKRUMAH, APTºB', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10312930', 'I', Null, 'TP1', Null, Null, Null, 'ANTUNES ALBERTO', 'BAIRRO DA CALEMBA-MAIANGA', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279645', 'I', Null, 'TP1', Null, Null, Null, 'EUSEBIO IVO', 'BAIRRO KICOLO-CACUACO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279651', 'I', Null, 'TP1', Null, Null, Null, 'SABALO LUIS MIRANDA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698129', 'I', Null, 'TP1', Null, Null, Null, 'TAVARES BERNARDO ANTONIO', 'BAIRRO DA CAOP PREDIO', Null, Null, '', '', '04', '', '4.01', '', 'Nov 2 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698141', 'I', Null, 'TP1', Null, Null, Null, 'HILDEBRANDE DE MELO ARAUJO', 'BAIRRO DA TECNOCARRO', Null, Null, '', '', '04', '', '4.01', '', 'Nov 2 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84698135', 'I', Null, 'TP1', Null, Null, Null, 'ZEFERINO MARCIAL', 'BAIRRO KICOLO', Null, Null, '', '', '04', '', '4.01', '', 'Nov 2 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112811000', 'i', Null, 'TP5', Null, Null, Null, 'MARIA JOAO DE OLIVEIRA', 'BAIRRO KASSEQUEL,ZONA 9,RUA 54,N.20', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112812007', 'i', Null, 'TP5', Null, Null, Null, 'LUZIA JOAO DOMINGOS', 'BAIRRO KASSEQUEL,ZONA 9,RUA 47,CASA N.24', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112815006', 'i', Null, 'TP5', Null, Null, Null, 'JOAO SIMAO MUHONGO', 'BAIRRO CAZENGA ZONA 18 CASA N.16', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112816002', 'i', Null, 'TP5', Null, Null, Null, 'MANUEL FRANCISCO JOAO LOURENCO', 'BAIRRO NEVES BENDINHA CASA N.27', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112818005', 'i', Null, 'TP5', Null, Null, Null, 'JOSEFA DOMINGOS', 'BAIRRO CALEMBA CASA N.1-CA-73', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112819001', 'i', Null, 'TP5', Null, Null, Null, 'FELISBINA M. ESPIRITO SANTO PEREIRA', 'BAIRRO N. BENDINHA,CASA N.35,R. VIOLETA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112822002', 'i', Null, 'TP5', Null, Null, Null, 'MADALENA JOAO', 'B.MACULUSSO RUA G.CARMONA Nº57', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112824005', 'i', Null, 'TP5', Null, Null, Null, 'MANUEL KIALA', 'BAIRRO N. BENDINHA ZONA 12 R.ODP N. 11', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112831001', 'i', Null, 'TP5', Null, Null, Null, 'SEBASTIAO NANI KUNZAILAO', 'B.KILAMBA KIAXI CASA S/N R.NGOLA MBANDI', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112842003', 'i', Null, 'TP5', Null, Null, Null, 'VICTORIA INACIO TEIXEIRA ALVES BEBIANO', 'RUA FERREIRA DE AMARAL Nº167 1ºANDAR', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112845002', 'i', Null, 'TP5', Null, Null, Null, 'SABINO CRISTOVAO', 'BAIRRO CAZENGA,ZONA 18,7.AV. CASA 85', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0112846009', 'i', Null, 'TP5', Null, Null, Null, 'JOAO ANTONIO FRAGOSO', 'BAIRRO KILAMBA KIAXI,ZONA 20,CASA 55', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715760', 'I', Null, 'TP1', Null, Null, Null, 'LULEMBA SOFIA', 'BAIRRO KIKOLO CASA 119 RUA 119', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715813', 'I', Null, 'TP1', Null, Null, Null, 'JOANA PEREIRA DA SILVA JOAO', 'RUA CIRILIO DA CONCEICAO Nº 25', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715820', 'I', Null, 'TP1', Null, Null, Null, 'MARIA JOAO CARDEAU CARNEIRO LOPES ALVES', 'BAIRRO MAIANGA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715842', 'I', Null, 'TP1', Null, Null, Null, 'LUIS DOMINGOS VALENTE', 'Bº NELITO SOARES Z/14', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715871', 'I', Null, 'TP2', Null, Null, Null, 'JOSE JOAO MANGUEIRA VAN-DUNEM', 'RUA RAINHA GINGA Nº 9 5º ANDAR', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04715894', 'I', Null, 'TP1', Null, Null, Null, 'ISIDRO MIGUEL JOAO', 'BAIRRO RANGEL CASA Nº 20', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04717858', 'I', Null, 'TP1', Null, Null, Null, 'ROSA GARCIA JOAO', 'BºMIRAMAR 12 ZONA 10', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718220', 'I', Null, 'TP1', Null, Null, Null, 'JOSE MANUEL DOS SANTOS MENDONCA GAMBOA', 'RUA MISES CAMILO 180-4º 42', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718237', 'I', Null, 'TP1', Null, Null, Null, 'DOMINGOS DOS SANTOS MARIA FERNANDES', 'INGOMBOTA RUA SEVEIRA PEREIRA N' 5 5.39', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718272', 'I', Null, 'TP1', Null, Null, Null, 'EDUARDO DA SILVA RIBEIRO', 'RUA FREDERICO WELWICHIA 11 B', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718540', 'I', Null, 'TP1', Null, Null, Null, 'RAIMUNDO ANDRE MANUEL', 'B'NELITO SOARES Z.11 RUA CZ CASA N.17', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718579', 'I', Null, 'TP1', Null, Null, Null, 'CANDIDO FORBS', 'BºSAMBIZANGA 5 BV-7', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718600', 'I', Null, 'TP1', Null, Null, Null, 'MPANZU FRANCOIS', 'Bº N.BENDINHA ZONA 12', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718881', 'I', Null, 'TP1', Null, Null, Null, 'MARIA EDUARDO', 'BAIRRO PATRICE LUMUMBA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718898', 'I', Null, 'TP1', Null, Null, Null, 'BARTOLOMEU JOAO DOS SANTOS', 'BAIRRO CAZENGA ZONA 18 SECTOR 14', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04718964', 'I', Null, 'TP1', Null, Null, Null, 'JOSE MANUEL DEMBO', 'B' SAMBIZANGA 1/MO/363', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '04719018', 'I', Null, 'TP1', Null, Null, Null, 'SACKHO BOUBACAR', 'Bº HOJI-YA-HENDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375632', 'I', Null, 'TP1', Null, Null, Null, 'PEDRO DA COSTA BOANA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375655', 'I', Null, 'TP1', Null, Null, Null, 'NELSON DIOGO FRANCISCO DE OLIVEIRA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375661', 'I', Null, 'TP1', Null, Null, Null, 'LINO JOAO DA COSTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375678', 'I', Null, 'TP1', Null, Null, Null, 'ANTONIO MIGUEL FASTUDO FERREIRA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375690', 'I', Null, 'TP1', Null, Null, Null, 'MANUEL GASPAR ANTONIO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375709', 'I', Null, 'TP1', Null, Null, Null, 'PAULO MANUEL NUNES SEBASTIAO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375738', 'I', Null, 'TP1', Null, Null, Null, 'CRISTINA NZAMBI', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02375879', 'I', Null, 'TP1', Null, Null, Null, 'CLAUDIO ANTONIO LIMA ARTUR', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02376100', 'I', Null, 'TP1', Null, Null, Null, 'DOMBELE SILVA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377186', 'I', Null, 'TP1', Null, Null, Null, 'CRISTINA EMILIA SIMAO MANUEL', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377217', 'I', Null, 'TP1', Null, Null, Null, 'RODRIGO DA COSTA BATALHA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377223', 'I', Null, 'TP1', Null, Null, Null, 'JOSE JOAO FAZ CONTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Jun 11 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377230', 'I', Null, 'TP1', Null, Null, Null, 'JOSE FRANCISCO DA SILVA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377252', 'I', Null, 'TP1', Null, Null, Null, 'SEBASTIAO BENTO PEDRO DA COSTA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377298', 'I', Null, 'TP1', Null, Null, Null, 'TALAMI GARCIA MIEZI', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377306', 'I', Null, 'TP1', Null, Null, Null, 'MIGUEL MAQUIESE QUINANGA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377312', 'I', Null, 'TP1', Null, Null, Null, 'MULANGUI FRANCO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377329', 'I', Null, 'TP1', Null, Null, Null, 'FERNANDO MIGUEL VAZ', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377370', 'I', Null, 'TP1', Null, Null, Null, 'MARIA CAROLINA GUERREIRO DA S.SALAVISA', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '02377387', 'I', Null, 'TP1', Null, Null, Null, 'ALEXANDRE ALBERTO EDUARDO JOAQUIM', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01405940', 'i', Null, 'TP1', Null, Null, Null, 'CATARINA VALE MELO', 'RUA HOJY YA HENDA N:144', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01405957', 'i', Null, 'TP1', Null, Null, Null, 'JOAQUIM DE OLIVEIRA DOS SANTOS CEA', 'BAIRRO OPERARIO,RUA C N:67', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396796', 'I', Null, 'TP1', Null, Null, Null, 'VICENTE NOE ANTONIO SEBASTIAO', 'B. NGOLA KILUANGE', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396810', 'I', Null, 'TP1', Null, Null, Null, 'FRANCISCO JOAO CRISTOVAO NETO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01396827', 'I', Null, 'TP1', Null, Null, Null, 'KINKADI JOAO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '01399932', 'I', Null, 'TP1', Null, Null, Null, 'ALEXANDRE MANUEL NETO', 'LUANDA', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054589002', 'i', Null, 'TP5', Null, Null, Null, 'VIS-A-VIS-COMER.GERAL AGRO-PECUARIA, LDA', 'Bº PALANCA ZONA 12', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054592003', 'i', Null, 'TP5', Null, Null, Null, 'DIENGA NSANGU LUIS', 'BºNEVES BENDINHA C.REGRESSADOS', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054593000', 'i', Null, 'TP5', Null, Null, Null, 'JOAO PEREIRA MASSAMO', 'BºPATRICE LUMUMBA R.TIMOR 40', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054594006', 'i', Null, 'TP5', Null, Null, Null, 'KUHENHA-SOCIEDADE DE COMERCIO GERAL, LDA', 'BºNEVES BENDINHA RUA DA GABELA Nº125', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '00546006', 'I', Null, 'TP1', Null, Null, Null, 'KIAMBI GRACA', 'BºNGOLA KILUANGE', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054627001', 'i', Null, 'TP5', Null, Null, Null, 'PEDRO JACINTO GUMBA', 'BAIRRO MARCAL', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054628008', 'i', Null, 'TP5', Null, Null, Null, 'VICTOR DA FONSECA FRANCISCO', 'BºP.LUMUMBA-PRAC.REI KATYAVALA R/C 1º 11', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054629004', 'i', Null, 'TP5', Null, Null, Null, 'ESTEVES ANTONIO', 'BAIRRO CAZENGA ZONA 18 CASA Nº 30', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054630002', 'i', Null, 'TP5', Null, Null, Null, 'AFONSO PEREIRA', 'BAIRRO HOJI YA HENDA Nº 15', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054631009', 'i', Null, 'TP5', Null, Null, Null, 'ARMANDO GONGO CASSANGE', 'KILAMBA KIAXI Nº 15-A', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054632005', 'i', Null, 'TP5', Null, Null, Null, 'PROMOCOES SEBRIN, LDA', 'AVªCDTE HOJI YA HENDA Nº 100 3ºE', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054634008', 'i', Null, 'TP5', Null, Null, Null, 'ADRIANO DOMINGOS DA SILVA', 'Bº KILAMBA KIAXI Nº 286', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054635004', 'i', Null, 'TP5', Null, Null, Null, 'RITA DO ROSARIO FERREIRA PEREIRA-RINEL', 'RUA LOPES DE LIMA Nº30', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054636000', 'i', Null, 'TP5', Null, Null, Null, 'CORDEIRO ERNESTO NZAKUNDOMBA', 'BºKILAMBA KIAXI Z.20 SUBZ.15 CASA Nº45', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054637007', 'i', Null, 'TP5', Null, Null, Null, 'VENTURA DOMINGOS FRANCISCO', 'Bº KASSEQUEL ZONA 9 CASA Nº 18', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054639000', 'i', Null, 'TP5', Null, Null, Null, 'PAULO JAIME SERGIO CAPELO', 'BAIRRO NELITO SOARES RUA DOURO Nº111/A', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054640008', 'i', Null, 'TP5', Null, Null, Null, 'ANDRE FRANCISCO', 'Bº GOLF MUNICIPIO KILAMBA KIAXI', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054641004', 'i', Null, 'TP5', Null, Null, Null, 'EXPROPEC-EXPLOR.AGRO-PECUARIA COM., LDA', 'Bº VALODIA PREDIO PREDIO 294 1º 11', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054642000', 'i', Null, 'TP5', Null, Null, Null, 'SOKWANZA-SOC.COM.PROD.QUIM.FARMAC., LDA', 'RUA HIGINO AIRES Nº 22 B', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0054643007', 'i', Null, 'TP5', Null, Null, Null, 'MAVILDE DE FATIMA BESSA TEIXEIRA', 'VILA ALICE RUA EUGENIO DE CASTRO 45', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '03347537', 'I', Null, 'TP1', Null, Null, Null, 'DARIO ROBERTO MACHADO E SILVA', 'BºALVALADE', Null, Null, '', '', '04', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
November 8, 2012 at 10:33 am
Again I will assume you did NOT test what you posted. It is full of issues.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'BOA'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'HOSPITAL'.
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near 'NOVA'.
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near 'KATAPI'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'CALUEIO'.
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near 'DA'.
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near 'KATAPI'.
Msg 102, Level 15, State 1, Line 45
Incorrect syntax near '5'.
Msg 102, Level 15, State 1, Line 52
Incorrect syntax near 'SAMBIZANGA'.
Msg 132, Level 15, State 1, Line 75
The label 'N' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 105, Level 15, State 1, Line 100
Unclosed quotation mark after the character string ', null, ')
'.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 8, 2012 at 10:39 am
Sorry. I will check again.
Thanks.
November 8, 2012 at 10:44 am
I have no error with this:
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '0016050002', 'A', Null, 'TP7', Null, Null, Null, '3ª CONSERVATORIA DO REG.CIVIL DA COMARCA DE LUANDA', 'MAIANGA', Null, Null, '', '', '01', '', '4.01', '', 'Apr 26 2004 12:00AM', 'Nov 6 2012 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, 'S4.01-692161', 'A', Null, 'TP7', Null, Null, Null, '3ª.SECCAO DA SALA DE FAMILIA -TRIBUNAL PROV.LUANDA', 'RUA AMILCAR CABRAL, Nº.29- 5º.ANDAR', Null, Null, '912453984', '', '11', '', '4.01', '040101', 'Oct 3 2008 12:00AM', 'Nov 6 2012 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '85019998', 'I', Null, 'TP1', Null, Null, Null, 'MARIO JOSE LISBOA', 'RUA 12 CASA Nº27', Null, Null, '', '', '04', '', '4.01', '', 'Jan 3 2007 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267547', 'I', Null, 'TP1', Null, Null, Null, 'ANA CASSINDA', 'B BOA VISTA CASA S/N', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267553', 'I', Null, 'TP1', Null, Null, Null, 'ABILIO PUPANASSI', 'B HOSPITAL CASA S/N', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267560', 'I', Null, 'TP1', Null, Null, Null, 'ENOC ZEFERINO', 'B NOVA PELE CASA S/N', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267576', 'I', Null, 'TP1', Null, Null, Null, 'CONSTANCIA CHAPANGA', 'B KATAPI CASA S/N ZONA E', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267582', 'I', Null, 'TP1', Null, Null, Null, 'MARIANA ANGELICA NACALANDULA', 'B CALUEIO CASA N194', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267599', 'I', Null, 'TP1', Null, Null, Null, 'MARIA ANTONIA NAMATELE', 'AV DA REPUBLICA CASA N45', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84267607', 'I', Null, 'TP1', Null, Null, Null, 'EVALINA FEBE SASSAMBA', 'B KATAPI CASA S/N ZONA B1', Null, Null, '', '', '', '', '4.01', '', 'Oct 18 2006 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10407702', 'I', Null, 'TP1', Null, Null, Null, 'ELISA VUNGE', 'BAIRRO PANGUILA-CACUACO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279579', 'I', Null, 'TP1', Null, Null, Null, 'NINITA GARCIA RALHA', 'BAIRRO CAOP-CASAS NOVAS', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279585', 'I', Null, 'TP1', Null, Null, Null, 'EVARISTO SAPIO SEGUNDA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10305574', 'I', Null, 'TP1', Null, Null, Null, 'ENGRACIA SEBASTIAO CAETANO DA SILVA', 'BAIRRO ECOCAMPO,CASA Nº77A', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279616', 'I', Null, 'TP1', Null, Null, Null, 'FRANCISCO SALVADOR JUNIOR', 'BºNGOLA KILUANJE,CASA Nº5-BV,Nº162,Z.16', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279600', 'I', Null, 'TP1', Null, Null, Null, 'ALZIRA CHOCONUMBI NEHEMA VENTURA', 'BAIRRO DO KIKOLO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279622', 'I', Null, 'TP1', Null, Null, Null, 'TERESA DOMINGOS', 'BAIRRO NDALA MULEMBA', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279639', 'I', Null, 'TP1', Null, Null, Null, 'MERARI RODRIGUEZ CAPOBRES', 'Bº MACULUSSO, Rº KWAMME NKRUMAH, APTºB', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '10312930', 'I', Null, 'TP1', Null, Null, Null, 'ANTUNES ALBERTO', 'BAIRRO DA CALEMBA-MAIANGA', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
INSERT INTO CONTRIBUINTES VALUES ('7401010488',Null, '84279645', 'I', Null, 'TP1', Null, Null, Null, 'EUSEBIO IVO', 'BAIRRO KICOLO-CACUACO', Null, Null, '', '', '04', '', '4.01', '', 'Dec 7 2005 12:00AM', 'Jan 1 1900 12:00AM', 'Jan 1 1900 12:00AM', Null, Null, Null, Null, Null, Null, Null, null, 'CENTRAL', null, '')
November 8, 2012 at 11:05 am
That worked. Now of course all of this is because you don't seem to be able to test this. I am still confused how you think the trigger I posted will update the entire table. It does not.
alter trigger [dbo].[TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF]
on [dbo].[CONTRIBUINTES]
for update
as begin
update contribuintes
set nif = d.nif,
filial_number = d.filial_number
from contribuintes c
join inserted i on i.nif_antigo = c.nif_antigo
join deleted d on d.nif_antigo = i.nif_antigo
where i.numeroposto = 'Central'
--This select should not be in your final trigger but it will show you EXACTLY which rows will be updated
select *
from contribuintes c
join inserted i on i.nif_antigo = c.nif_antigo
join deleted d on d.nif_antigo = i.nif_antigo
where i.numeroposto = 'Central'
--want to see the contents of inserted?
select 'inserted', * from inserted
--how about deleted?
select 'deleted', * from deleted
end
Now try this...
update CONTRIBUINTES set [STATUS] = 'A' where NIF_ANTIGO in ('0016050002', 'S4.01-692161')
It does NOT update the entire table, it updates ONLY the rows in the update statement.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 10 posts - 31 through 39 (of 39 total)
You must be logged in to reply to this topic. Login to reply