1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 1)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (1, N'RESIDÊNCIA',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 2)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (2, N'EMPRESA',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 3)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (3, N'CONDOMÍNIO',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 4)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (4, N'RISCOS DIVERSOS',0.0738,1,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 5)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (5, N'AUTOMOVEL',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 6)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (6, N'VIDA INDIVIDUAL',0.0738,1,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 7)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (7, N'VG/APC',0.0738,1,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 8)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (8, N'TRANSPORTES',0.0738,1,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 14)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (14, N'DPVAT',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 15)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (15, N'FIANÇA LOCATÍCIA',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 18)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (18, N'IMOBILIÁRIO',0.0738,1,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 20)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (20, N'GRANIZO',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 23)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (23, N'SEGURO VIAGEM',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 24)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (24, N'SEGURO DE EVENTOS',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 25)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (25, N'AGRÍCOLA',0.0738,1,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 28)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (28, N'RC PROFISSIONAL',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 30)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (30, N'RC AMBIENTAL',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 31)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (31, N'ACIDENTES PESSOAIS',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 32)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (32, N'RESP. CIVIL GERAL',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 33)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (33, N'MULTIRISCO RURAL',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 34)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (34, N'ANIMAIS',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 37)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (37, N'RESP. CIVIL ÔNIBUS',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 38)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (38, N'SEGURO GARANTIA',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 39)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (39, N'RISCOS DE ENGENHARIA',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 41)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (41, N'ACIDENTES PESSOAIS COLETIVOS',0.0738,0,1);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 44)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (44, N'PENHOR RURAL',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 49)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (49, N'RCTR-C',0.0738,1,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 54)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (54, N'BENFEITORIA RURAL',0.0738,0,0);
END
IF NOT EXISTS(SELECT 1 FROM [dbo].[ramo] WHERE [IDRAMO] = 56)
BEGIN
INSERT INTO [dbo].[ramo] ([IDRAMO],[NOME],[IOF],[FATURA],[ATIVO]) VALUES (56, N'RC PRESTAÇÃO DE SERVIÇO',0.0738,0,1);
END
|
