path: root/Decompiler/Gestor.Application.Migration.Files.20200219_03.SQL

IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 1)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (1,1, N'BANCO DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 10)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (10,41, N'BANCO DO ESTADO DO RIO GRANDE DO SUL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 100)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (100,738, N'BANCO MORADA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 101)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (101,739, N'BANCO BGN S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 102)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (102,740, N'BANCO BARCLAYS S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 103)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (103,741, N'BANCO RIBEIRAO PRETO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 104)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (104,743, N'BANCO EMBLEMA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 105)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (105,745, N'BANCO CITIBANK S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 106)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (106,746, N'BANCO MODAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 107)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (107,747, N'BANCO RABOBANK INTERNATIONAL BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 108)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (108,748, N'BANCO COOPERATIVO SICREDI S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 109)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (109,749, N'BANCO SIMPLES S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 11)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (11,44, N'BANCO BVA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 110)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (110,751, N'DRESDNER BANK BRASIL S.A. BANCO MULTIPLO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 111)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (111,752, N'BANCO BNP PARIBAS BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 112)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (112,753, N'NBC BANK BRASIL S. A. - BANCO M?LTIPLO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 113)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (113,756, N'BANCO COOPERATIVO DO BRASIL S.A. - BANCOOB');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 114)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (114,757, N'BANCO KEB DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 115)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (115,0, N'NENHUM');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 116)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (116,85, N'BANCO CECRED');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 117)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (117,290, N'PAGSEGURO INTERNET S.A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 12)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (12,45, N'BANCO OPPORTUNITY S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 13)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (13,47, N'BANCO DO ESTADO DE SERGIPE S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 14)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (14,62, N'HIPERCARD BANCO M?LTIPLO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 15)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (15,63, N'BANCO IBI S.A. - BANCO M?LTIPLO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 16)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (16,65, N'BANCO LEMON S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 17)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (17,66, N'BANCO MORGAN STANLEY S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 18)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (18,69, N'BPN BRASIL BANCO M?LTIPLO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 19)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (19,70, N'BRB - BANCO DE BRASILIA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 2)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (2,3, N'BANCO DA AMAZONIA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 20)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (20,72, N'BANCO RURAL MAIS S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 21)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (21,73, N'BB BANCO POPULAR DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 22)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (22,74, N'BANCO J. SAFRA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 23)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (23,75, N'BANCO CR2 S/A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 24)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (24,76, N'BANCO KDB DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 25)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (25,77, N'BANCO INTERMEDIUM S/A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 26)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (26,79, N'JBS BANCO S/A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 27)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (27,81, N'CONC?RDIA BANCO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 28)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (28,96, N'BANCO BM&F DE SERVI?OS DE LIQUIDA??O E CUST?DIA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 29)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (29,104, N'CAIXA ECONOMICA FEDERAL');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 3)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (3,4, N'BANCO DO NORDESTE DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 30)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (30,107, N'BANCO BBM S/A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 31)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (31,151, N'BANCO NOSSA CAIXA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 32)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (32,208, N'BANCO UBS PACTUAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 33)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (33,212, N'BANCO MATONE S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 34)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (34,213, N'BANCO ARBI S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 35)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (35,214, N'BANCO DIBENS S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 36)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (36,217, N'BANCO JOHN DEERE S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 37)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (37,218, N'BANCO BONSUCESSO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 38)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (38,222, N'BANCO CALYON BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 39)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (39,224, N'BANCO FIBRA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 4)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (4,19, N'BANCO AZTECA DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 40)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (40,225, N'BANCO BRASCAN S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 41)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (41,229, N'BANCO CRUZEIRO DO SUL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 42)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (42,230, N'UNICARD BANCO M?LTIPLO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 43)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (43,233, N'BANCO GE CAPITAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 44)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (44,237, N'BANCO BRADESCO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 45)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (45,241, N'BANCO CLASSICO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 46)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (46,243, N'BANCO M?XIMA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 47)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (47,246, N'BANCO ABC BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 48)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (48,248, N'BANCO BOAVISTA INTERATLANTICO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 49)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (49,249, N'BANCO INVESTCRED UNIBANCO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 5)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (5,21, N'BANESTES S.A. BANCO DO ESTADO DO ESPIRITO SANTO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 50)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (50,250, N'BANCO SCHAHIN S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 51)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (51,254, N'PARAN? BANCO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 52)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (52,263, N'BANCO CACIQUE S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 53)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (53,265, N'BANCO FATOR S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 54)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (54,266, N'BANCO CEDULA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 55)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (55,300, N'BANCO DE LA NACION ARGENTINA');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 56)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (56,318, N'BANCO BMG S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 57)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (57,341, N'BANCO ITAU S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 58)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (58,356, N'BANCO ABN AMRO REAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 59)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (59,366, N'BANCO SOCIETE GENERALE BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 6)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (6,25, N'BANCO ALFA S.A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 60)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (60,370, N'BANCO WESTLB DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 61)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (61,376, N'BANCO J.P. MORGAN S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 62)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (62,389, N'BANCO MERCANTIL DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 63)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (63,394, N'BANCO FINASA BMC S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 64)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (64,399, N'HSBC BANK BRASIL S.A. - BANCO MULTIPLO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 65)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (65,409, N'UNIBANCO-UNIAO DE BANCOS BRASILEIROS S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 66)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (66,412, N'BANCO CAPITAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 67)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (67,422, N'BANCO SAFRA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 68)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (68,453, N'BANCO RURAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 69)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (69,456, N'BANCO DE TOKYO-MITSUBISHI UFJ BRASIL S/A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 7)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (7,33, N'BANCO SANTANDER BANESPA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 70)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (70,464, N'BANCO SUMITOMO MITSUI BRASILEIRO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 71)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (71,477, N'CITIBANK N.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 72)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (72,487, N'DEUTSCHE BANK S.A. - BANCO ALEMAO');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 73)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (73,488, N'JPMORGAN CHASE BANK, NATIONAL ASSOCIATION');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 74)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (74,492, N'ING BANK N.V.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 75)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (75,494, N'BANCO DE LA REPUBLICA ORIENTAL DEL URUGUAY');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 76)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (76,495, N'BANCO DE LA PROVINCIA DE BUENOS AIRES');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 77)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (77,505, N'BANCO CREDIT SUISSE (BRASIL) S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 78)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (78,600, N'BANCO LUSO BRASILEIRO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 79)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (79,604, N'BANCO INDUSTRIAL DO BRASIL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 8)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (8,37, N'BANCO DO ESTADO DO PAR? S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 80)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (80,610, N'BANCO VR S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 81)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (81,611, N'BANCO PAULISTA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 82)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (82,612, N'BANCO GUANABARA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 83)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (83,613, N'BANCO PECUNIA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 84)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (84,623, N'BANCO PANAMERICANO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 85)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (85,626, N'BANCO FICSA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 86)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (86,630, N'BANCO INTERCAP S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 87)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (87,633, N'BANCO RENDIMENTO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 88)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (88,634, N'BANCO TRIANGULO S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 89)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (89,637, N'BANCO SOFISA S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 9)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (9,40, N'BANCO CARGILL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 90)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (90,638, N'BANCO PROSPER S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 91)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (91,643, N'BANCO PINE S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 92)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (92,653, N'BANCO INDUSVAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 93)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (93,654, N'BANCO A.J. RENNER S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 94)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (94,655, N'BANCO VOTORANTIM S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 95)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (95,707, N'BANCO DAYCOVAL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 96)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (96,719, N'BANIF - BANCO INTERNACIONAL DO FUNCHAL (BRASIL), S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 97)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (97,721, N'BANCO CREDIBEL S.A.');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 98)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (98,734, N'BANCO GERDAU S.A');
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[CODIGOBANCO] WHERE [IDCODIGOBANCO] = 99)
BEGIN
	INSERT INTO [dbo].[CODIGOBANCO] ([IDCODIGOBANCO],[CODIGO],[NOMEBANCO]) VALUES (99,735, N'BANCO POTTENCIAL S.A.');
END