
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='TIPOAZIONE' AND Codice='VEN')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'TIPOAZIONE','VEN','VENDITA',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='TIPOAZIONE' AND Codice='RES')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'TIPOAZIONE','RES','RESO',1,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='TIPOAZIONE' AND Codice='OMG')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'TIPOAZIONE','OMG','OAGGIO',2,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')

IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONECOMM' AND Codice='PE')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONECOMM','PE','Primavera Estate',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')

IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONECOMM' AND Codice='AI')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONECOMM','AI','Autunno Inverno',1,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')

IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONEMETEO' AND Codice='A')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONEMETEO','A','Autunno',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONEMETEO' AND Codice='I')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONEMETEO','I','Inverno',1,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONEMETEO' AND Codice='P')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONEMETEO','P','Primavera',2,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='STAGIONEMETEO' AND Codice='E')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'STAGIONEMETEO','E','Estate',3,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')

IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='MAR' AND Codice='')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'MAR','','* SENZA MARCHIO *',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='FAM' AND Codice='')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'FAM','','* SENZA FAMIGLIA *',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='GRP' AND Codice='')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'GRP','','* SENZA GRUPPO *',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='SES' AND Codice='')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'SES','','* SENZA SESSO *',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
IF NOT EXISTS (SELECT ID FROM DesVar WHERE Chiave='FAS' AND Codice='')
INSERT INTO [Desvar] ([Chiave],[Codice],[Descrizione],[Sequenza],[UserIns],[DataIns],[UserMod],[DataMod],[Lingue],[Note]) VALUES ( 'FAS','','* SENZA FASCIA *',0,'Ots','20080101 00:00:00','Ots','20080101 00:00:00',NULL,'')
