
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 22)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (22, 'Regioni')


if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 23)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (23, 'Raggruppamenti 1 cliente')

if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 24)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (24, 'Raggruppamenti 2 cliente')

if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 25)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (25, 'Raggruppamenti 3 cliente')

if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 26)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (26, 'Gruppi fiscali')
	
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 27)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (27, 'Marche')
	
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 28)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (28, 'Gruppi statistici 1')
	
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 29)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (29, 'Gruppi statistici 2')
	
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 30)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (30, 'Gruppi statistici 3')
	
if not exists (select top 1 1 from GT00_TIPITRASCODIFICHE where GT00_TIPO = 31)
	insert into GT00_TIPITRASCODIFICHE (GT00_TIPO, GT00_DESCRIZIONE) values (31, 'Gruppi statistici 4')


	
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'A')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'A',1,'PIEMONTE')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'B')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'B',1,'VAL D''AOSTA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'C')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'C',1,'LOMBARDIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'D')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'D',1,'VENETO')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'E')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'E',1,'TRENTINO')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'F')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'F',1,'FRIULI')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'G')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'G',1,'LIGURIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'H')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'H',1,'EMILIA ROMAGNA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'I')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'I',1,'TOSCANA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'K')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'K',1,'MARCHE')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'L')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'L',1,'UMBRIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'M')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'M',1,'LAZIO')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'N')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'N',1,'ABRUZZO')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'P')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'P',1,'MOLISE')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'Q')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'Q',1,'CAMPANIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'R')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'R',1,'PUGLIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'S')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'S',1,'BASILICATA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'T')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'T',1,'CALABRIA')
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'U')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'U',1,'SICILIA')	
if not exists (select top 1 1 from GT01_TRASCODIFICHE where GT01_TIPO = 22 AND GT01_CODICEGE = 'V')
	insert into GT01_TRASCODIFICHE (GT01_TIPO, GT01_CODICEGE, GT01_SYNCTU, GT01_DESCRIZIONE) 
		values (22,'V',1,'SARDEGNA')	


