Trasferimento dati da MS-Access:Labaia.mdb ==> MSSQL:MSSql162519     18/05/2025 10:17:34

---

AUTHORIZE
INSERT INTO AUTHORIZE VALUES ('SYS','ADM','Data Base Administrator');
INSERT INTO AUTHORIZE VALUES ('BOOKRS','ANNA18','SIG.RA ANNA');

---

CAMERE
INSERT INTO CAMERE VALUES ('101','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('102','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('103','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('104','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('105','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('106','STD','Standard');
INSERT INTO CAMERE VALUES ('107','ECO','Economy');
INSERT INTO CAMERE VALUES ('108','ECO','Economy');
INSERT INTO CAMERE VALUES ('201','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('202','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('203','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('204','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('205','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('206','STD','Standard');
INSERT INTO CAMERE VALUES ('207','ECO','Economy');
INSERT INTO CAMERE VALUES ('208','ECO','Economy');
INSERT INTO CAMERE VALUES ('301','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('302','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('303','VMB','Vista Mare Balcone');
INSERT INTO CAMERE VALUES ('304','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('305','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('306','VM','Vista Mare');
INSERT INTO CAMERE VALUES ('307','STD','Standard');
INSERT INTO CAMERE VALUES ('308','STD','Standard');
INSERT INTO CAMERE VALUES ('309','TVM','Tripla Vista Mare');
INSERT INTO CAMERE VALUES ('310','TVM','Tripla Vista Mare');

---

DISDETTA
INSERT INTO DISDETTA VALUES (103,CONVERT(datetime,'20-04-2025',103),CONVERT(datetime,'22-04-2025',103),2,0,0,0,'GIUSEPPE LIMONE','GIUSEPPE LIMONE',CONVERT(datetime,'08-04-2025',103));
INSERT INTO DISDETTA VALUES (103,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'AVV. BARRA CARRACCIO','AVV. BARRA CARRACCIOLO',CONVERT(datetime,'11-05-2025',103));
INSERT INTO DISDETTA VALUES (102,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'REDI','REDI',CONVERT(datetime,'05-05-2025',103));
INSERT INTO DISDETTA VALUES (202,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'ELSA E MASSIMO','ELSA E MASSIMO',CONVERT(datetime,'08-04-2025',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'REDI','REDI',CONVERT(datetime,'05-05-2025',103));
INSERT INTO DISDETTA VALUES (101,CONVERT(datetime,'28-06-2025',103),CONVERT(datetime,'06-07-2025',103),2,0,0,0,'ANNA','ANNA',CONVERT(datetime,'22-04-2025',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'CARLA MARONI DE STEF','CARLA MARONI DE STEFANO',CONVERT(datetime,'12-04-2025',103));
INSERT INTO DISDETTA VALUES (301,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'GRAZIELLA BERNASCONI','GRAZIELLA BERNASCONI',CONVERT(datetime,'15-03-2025',103));
INSERT INTO DISDETTA VALUES (302,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'GRAZIELLA BERNASCONI','GRAZIELLA BERNASCONI',CONVERT(datetime,'15-03-2025',103));

---

LISTINO
INSERT INTO LISTINO VALUES (150,140,130,120,170,150,140,130,200,190,170,150,240,220,190,180,0,0,0,0,0,CONVERT(datetime,'10-04-2025',103),CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'08-09-2025',103),CONVERT(datetime,'30-10-2025',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'01-06-2025',103),CONVERT(datetime,'25-06-2025',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'10-08-2025',103),CONVERT(datetime,'23-08-2025',103),CONVERT(datetime,'31-08-2025',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'22-08-2025',103),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,190,220,260,280);
INSERT INTO LISTINO VALUES (150,140,130,120,170,150,140,130,200,190,170,150,240,220,190,180,0,0,0,0,0,CONVERT(datetime,'10-04-2025',103),CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'08-09-2025',103),CONVERT(datetime,'30-10-2025',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'01-06-2025',103),CONVERT(datetime,'25-06-2025',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'10-08-2025',103),CONVERT(datetime,'23-08-2025',103),CONVERT(datetime,'31-08-2025',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'22-08-2025',103),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,190,220,260,280);

---

PRENOTAZIONE
INSERT INTO PRENOTAZIONE VALUES (101,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'SORRICCHIO GUIDO','SORRICCHIO GUIDO','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (102,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'CARBONE BENEDETTO','CARBONE BENEDETTO','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'SCHIFONI MARCELLO','SCHIFONI MARCELLO','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (104,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'MURA PRIANO','MURA PRIANO','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (105,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'FRANCESCO GESUALDI ','FRANCESCO GESUALDI','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (107,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'CATALIN','CATALIN','-','-','-','-','-','-','-',240,240,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (108,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'ANGELA MANCINI','ANGELA MANCINI','-','-','-','-','-','-','-',240,240,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'FILIPPO APOLLONI ','FILIPPO APOLLONI','-','-','-','-','-','3488057210','-',300,300,150,CONVERT(datetime,'13-03-2025',103),1,0,0,'150 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'M CEREA','M CEREA','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'GRUPO ANIENI 150','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'CARFAGNI DARIO','CARFAGNI DARIO','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'150 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (204,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'REGIS','REGIS','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',300,368,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'184','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PATRIARCA GESUALDI','PATRIARCA GESUALDI','-','-','-','-','-','-','-',260,260,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (207,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'GUIDO CHOEN ','GUIDO CHOEN ','-','-','-','-','-','-','-',240,240,120,CONVERT(datetime,'07-05-2025',103),1,0,0,'120 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'13-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'LORENZO PORZIO','LORENZO PORZIO','-','-','-','-','-','-','-',240,240,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'MARIO MAZANTI','MARIO MAZZANTI','GRUPPO COLLI ANIENI','-','-','-','-','3299432824','-',300,320,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'160','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'COGNETTI FRANCESCO','COGNETTI FRANCESCO','-','-','-','-','-','-','-',300,320,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'160 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'SANDRO CEREA','SANDRO CEREA','-','-','-','-','-','-','-',300,320,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'160 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',280,300,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',280,336,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'168','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (306,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'ALBINI OLIVIERO','ALBINI OLIVIERO','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'MAROCCO MARCO','MAROCCO MARCO','-','-','-','-','-','-','-',260,260,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'VITTORIA CARLI LUCARELLI','VITTORIA CARLI LUCARELLI','-','-','-','-','-','-','-',260,260,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'29-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'DANIELA ZANZURI','DANIELA ZANZURI','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'17-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'10-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (101,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'GRUPPO MUSTO','GRUPPO MUSTO','-','-','-','-','-','-','-',470,470,0,CONVERT(datetime,'22-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'15-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (102,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'GRUPPO MUSTO','GRUPPO MUSTO','-','-','-','-','-','-','-',470,470,0,CONVERT(datetime,'22-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'15-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'GRUPPO MUSTO','GRUPPO MUSTO','-','-','-','-','-','-','-',470,470,0,CONVERT(datetime,'22-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'15-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'PIERLUIGI VINGOLO','PIERLUIGI VINGOLO','-','-','-','-','-','-','-',450,450,0,CONVERT(datetime,'11-05-2025',103),0,0,1,'BOOKING CARTA DI CREDITO','BOOKRS','0',CONVERT(datetime,'05-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'GRUPPO MUSTO','GRUPPO MUSTO','-','-','-','-','-','-','-',470,470,0,CONVERT(datetime,'22-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'15-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),2,0,0,0,'PAUL HOLT','PAUL HOLT','-','-','-','-','-','-','-',1150,1190,357,CONVERT(datetime,'14-05-2025',103),1,0,0,'170 A NOTTE OK BONIFICO','BOOKRS','0',CONVERT(datetime,'11-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'GIOVAGNOLI FIGLIO','GIOVAGNOLI FIGLIO','-','-','-','-','-','-','-',450,450,570,CONVERT(datetime,'10-05-2025',103),1,1,0,'190','BOOKRS','0',CONVERT(datetime,'19-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,1,0,0,'CORRADO ANDREAN','CORRADO ANDREAN','-','-','-','-','-',' (+39) 348 0705494','-',470,630,210,CONVERT(datetime,'17-04-2025',103),1,0,0,'210 CAMERA VISTA MARE CON BALCONE','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),2,0,0,0,'RAFFAELE BASSI','RAFFAELE BASSI','-','-','-','-','-','-','-',880,800,240,CONVERT(datetime,'19-03-2025',103),1,0,0,'800 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'15-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (204,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'03-06-2025',103),2,0,0,0,'ANGELICA TERREZZA','ANGELICA TERREZZA','-','-','-','-','-','-','-',440,518,0,CONVERT(datetime,'12-05-2025',103),0,0,1,'BOOKING','BOOKRS','0',CONVERT(datetime,'05-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'ELEONARA NOTARI','ELEONARO NOTARI','-','-','-','-','-','-','-',270,270,0,CONVERT(datetime,'25-05-2025',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'18-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,0,0,0,'ELEONORA NOTARI','ELEONORA NOTARI','-','-','-','-','-','-','-',270,270,0,CONVERT(datetime,'25-05-2025',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'18-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'LINDA STEFANETTI','LINDA STEFANETTI','-','-','-','-','-','-','-',340,340,340,CONVERT(datetime,'18-04-2025',103),1,1,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),2,0,0,0,'FRANCESCO PALMEGGIANI','FRANCESCO PALMEGGIANI','-','-','-','-','-','-','-',510,510,340,CONVERT(datetime,'18-04-2025',103),1,1,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),2,0,0,0,'LUIGI CERONI','LUIGI CERONI','-','-','-','-','-','-','-',510,510,340,CONVERT(datetime,'18-04-2025',103),1,1,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'MARIA LAURA DE GENNARO ','MARIA LAURA DE GENNARO ','-','-','-','-','-','-','-',280,280,140,CONVERT(datetime,'18-04-2025',103),1,0,0,'140 STANDARD OK ACCONTO','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),2,0,0,0,'ANNALISA ALCESTE','ANNALISA ALCESTE','-','-','-','-','-','-','-',340,320,0,CONVERT(datetime,'12-04-2025',103),0,0,0,'160','BOOKRS','0',CONVERT(datetime,'05-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),2,0,0,0,'MIEDICO ANTONIO','MIEDICO ANTONIO','-','-','-','-','-','-','-',680,600,180,CONVERT(datetime,'25-03-2025',103),1,0,0,'150','BOOKRS','0',CONVERT(datetime,'24-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,'LUDOVICA ( EDOARDO STANISCIA )','LUDOVICA ( EDOARDO STANISCIA )','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'170','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,'EDOARDO STANISCIA','EDOARDO STANISCIA','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'NON HO DETTO IL PREZZO','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,'EDOARDO STANISCIA','EDOARDO STANISCIA','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'NONN HO DETTO IL PREZZO','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,' ANTONIO DEL MANSO',' ANTONIO DEL MANSO','-','-','-','-','-',' 3465145407','-',340,340,170,CONVERT(datetime,'04-05-2025',103),1,0,0,'170 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'29-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),2,1,0,0,'FRANCESCO ROMANI','FRANCESCO ROMANI','-','-','-','-','-','-','-',510,720,240,CONVERT(datetime,'24-03-2025',103),1,0,0,'240 TRIPLA CON TERRAZZA','BOOKRS','0',CONVERT(datetime,'24-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (101,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,510,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,510,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),2,0,0,0,'PIERLUIGI PALMIGIANI','PIERLUIGI PALMIGIANI','-','-','-','-','-','-','-',1020,1020,306,CONVERT(datetime,'04-05-2025',103),1,0,0,'170 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'30-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'ELSA E MASSIMO','ELSA E MASSIMO','-','-','-','-','-','-','-',510,510,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'180','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),2,0,0,0,'AUGUSTO CHIOSI','AUGUSTO CHIOSI ','-','-','-','-','-','-','-',680,760,0,CONVERT(datetime,'19-05-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'12-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PIRRO/FABENI ','PIRRO/FABENI ','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PORTANOVA/PICHILLI','PORTANOVA/PICHILLI','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),2,0,0,0,'GIORGIO GHIRELLI','GIORGIO GHIRELLI','-','-','-','-','-','-','-',680,680,0,CONVERT(datetime,'12-04-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'05-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'21-06-2025',103),CONVERT(datetime,'23-06-2025',103),2,1,0,0,'MARCO DOMINICI','MARCO DOMINICI','-','-','-','-','-','-','-',280,440,0,CONVERT(datetime,'01-03-2025',103),0,0,0,'220 TRIPLA ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'22-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'26-06-2025',103),2,0,0,0,'MANUELA ED ENRICO','MANUELA ED ENRICO','-','-','-','-','-','-','-',510,510,0,CONVERT(datetime,'17-05-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'10-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),2,0,0,0,'AMICO MARIO COLATEI','AMICO MARIO COLATEI','-','-','-','-','-','-','-',1190,1190,0,CONVERT(datetime,'05-05-2025',103),0,0,0,'160 A NOTTE','BOOKRS','0',CONVERT(datetime,'28-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),2,0,0,0,'MARIO COLATEI','MARIO COLATEI','-','-','-','-','-','-','-',1310,1120,0,CONVERT(datetime,'05-05-2025',103),0,0,0,'160 A NOTTE','BOOKRS','0',CONVERT(datetime,'28-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),2,0,0,0,'RAFFAELE TARTAGLIONE','RAFFAELE TARTAGLIONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'CAMERA SUPERIOR 210 ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'07-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),2,0,0,0,'RAFFAELE TARTAGLIONE AMICI','IODICE AMALIA','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'14-05-2025',103),1,0,0,'210 ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'27-06-2025',103),CONVERT(datetime,'30-06-2025',103),2,0,0,0,'MARIO SCHIAROLI','MARIO SCHIAROLI ','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'14-05-2025',103),0,0,0,'200 AMICO COLATEI','BOOKRS','0',CONVERT(datetime,'07-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),2,0,0,0,'ANDREA GIOVAGNOLI','ANDREA GIOVAGNOLI','-','-','-','-','-','-','-',600,660,220,CONVERT(datetime,'15-04-2025',103),1,0,0,'220 SUPERIOR OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'04-07-2025',103),CONVERT(datetime,'06-07-2025',103),2,0,0,0,'FEDERICO GABRIELE','FEDERICO GABRIELE','-','-','-','-','-','-','-',400,440,0,CONVERT(datetime,'06-05-2025',103),0,0,0,'220','BOOKRS','0',CONVERT(datetime,'29-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'VALERIA COSENTINO ALESI','VALERIA COSENTINO ALESI','VISA N. 4025 4724 6457 1599 SCAD 06/26','-','-','-','-','3355975763','-',400,400,0,CONVERT(datetime,'11-03-2025',103),0,0,1,'190 GRUPPO PROSPERI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'MARCO MARRANA','MARCO MARRANA','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'BOOKING 162 DA PRELEVARE','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'MARCO VISCOGLIOSI','MARCO VISCOGLIOSI','INTESA SAN PAOLO N. 4471 4931 0432 4958 SCAD. 12/2','-','-','-','-','3930692400','-',200,200,0,CONVERT(datetime,'11-03-2025',103),0,0,1,'190 GRUPPO PROSPERI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'RIZZA STEFANO E FEDERICA','RIZZA STEFANO E FEDERICA','AMERICAN EXPRESS: N 375288071412009 SCADENZA12/25.','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'12-03-2025',103),0,0,1,'190','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'ENZA BURATO E CIRO TAMBURELLA','ENZA BURATO E CIRO TAMBURELLA','-','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'PROSPERO DANIELA E CRISTINA COSTANZO','PROSPERO DANIELA E CRISTINA COSTANZO','GRUPPO PROSPERO','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'NOTAIO CERASO','NOTAIO CERASO','-','-','-','-','-','-','-',1200,1140,450,CONVERT(datetime,'04-04-2025',103),1,0,0,'190','BOOKRS','0',CONVERT(datetime,'27-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'09-07-2025',103),2,0,0,0,'MONTELLA AMICO CESARO','MONTELLA AMICI CESARO','-','-','-','-','-','-','-',400,400,210,CONVERT(datetime,'04-04-2025',103),1,0,0,'210 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'PROF. PIGNALOSA','PROF. PIGNALOSA','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'25-04-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'18-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'PROF. PIGNALOSA','PROF. PIGNALOSA','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'25-04-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'18-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'09-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'GIUSEPPE MURENA','GIUSEPPE MURENA','AMICO CESARO','-','-','-','-','3487081901','-',800,800,252,CONVERT(datetime,'04-04-2025',103),1,0,0,'210 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'15-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'MAURIZIO DOMENICI','MAURIZIO DOMENICI','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'02-05-2025',103),0,0,0,'PAPA NOTAIO DOMENICI','BOOKRS','0',CONVERT(datetime,'25-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'ALESSANDRO PANSA ','ALESSNDRO PANDA AMICO NOTAIO CESARO','-','-','-','-','-','-','-',600,600,210,CONVERT(datetime,'11-03-2025',103),1,0,0,'210 ATTESA BONIFICO ','BOOKRS','0',CONVERT(datetime,'10-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'FARINA','FARINA','-','-','-','-','-','0765 30018','-',510,570,0,CONVERT(datetime,'21-05-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'14-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'FARINA','FARINA','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'21-05-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'14-05-2025',103));
INSERT INTO PRENOTAZIONE VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,1,0,0,'EMANUELA GEROSA','EMANUELA GEROSA','-','-','-','-','-','-','-',800,1080,0,CONVERT(datetime,'10-03-2025',103),0,0,0,'270','BOOKRS','0',CONVERT(datetime,'03-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210 BONIFICO 630 X 3 CAMERE','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),2,0,0,0,'ELENA PETRALIA ','ELENA PETRALIA','-','-','-','-','-','-','-',600,660,220,CONVERT(datetime,'15-04-2025',103),1,0,0,'220 SUPERIOR OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,0,0,0,'VALENTINA BRIZIARELLI','VALENTINA BRIZIARELLI','ELEONORA NALDINI (MIA FIGLIA) E NINA DE PASQUALE','-','-','-','-','-','-',600,680,204,CONVERT(datetime,'12-03-2025',103),1,0,0,'170 CAMERA ECONOMY VERIFICARE ACCONTO','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,1,0,0,'VALENTINA BRIZIARELLI','VALENTINA BRIZIARELLI','ELEONORA D’OSTUNI, VALERIA BRANDOLO E AGATA ARCUDI','-','-','-','-','-','-',600,960,288,CONVERT(datetime,'13-03-2025',103),1,0,0,'240 CAMERA TRIPLA ECONOMY','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,0,0,0,'GIORGIA BARBARULO','GIORGIA BARBARULO','CODICE FISCALE BRBGRG72R44F839V','ROMA 00161 VIA PADOVA 53','-','-','-','3200132390','-',680,720,216,CONVERT(datetime,'13-03-2025',103),1,0,0,'180 CAMERA STANDARD 3 PIANO','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),2,1,0,0,'ALESSANDRO OLIVA','ALESSANDRO OLIVA','EFFETTUATO BONIFICO DI EURO 810 X LE DUE CAMERE','-','-','-','-','-','-',1140,1560,700,CONVERT(datetime,'16-02-2025',103),1,0,0,'N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190','BOOKRS','0',CONVERT(datetime,'13-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),2,0,0,0,'ALESSANDRO OLIVA','ALESSANDRO OLIVA','-','-','-','-','-','-','-',1140,1140,110,CONVERT(datetime,'16-02-2025',103),1,0,0,'N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190','BOOKRS','0',CONVERT(datetime,'13-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'12-08-2025',103),CONVERT(datetime,'16-08-2025',103),2,0,0,0,'DANIELA FRATESI','DANIELA FRATESI','-','-','-','-','-','-','danielafratesi6@gmail.com',960,960,288,CONVERT(datetime,'04-05-2025',103),1,0,0,'240 OK ','BOOKRS','0',CONVERT(datetime,'25-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),2,0,0,0,'DONATELLA PAI','DONATELLA PAI','-','-','-','-','-','-','-',1600,1470,0,CONVERT(datetime,'28-01-2025',103),0,0,0,'210','BOOKRS','0',CONVERT(datetime,'21-01-2025',103));

---

LOG
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),101,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (101,"23/05/2025","25/05/2025",2,0,0,0,"SORRICCHIO GUIDO","SORRICCHIO GUIDO","","","","","","","",300.00,300.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-05-2025',103),101,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (101,"30/05/2025","02/06/2025",2,0,0,0,"GRUPPO MUSTO","GRUPPO MUSTO","","","","","","","",470.00,470.00,0,"22/05/2025",0,0,0,"","BOOKRS",0,"15/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),102,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (102,"23/05/2025","25/05/2025",2,0,0,0,"CARBONE BENEDETTO","CARBONE BENEDETTO","","","","","","","",300.00,300.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-05-2025',103),102,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (102,"30/05/2025","02/06/2025",2,0,0,0,"GRUPPO MUSTO","GRUPPO MUSTO","","","","","","","",470.00,470.00,0,"22/05/2025",0,0,0,"","BOOKRS",0,"15/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),103,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (103,"13/06/2025","15/06/2025",2,0,0,0,"LUDOVICA ( EDOARDO STANISCIA )","LUDOVICA ( EDOARDO STANISCIA )","","","","","","","",340.00,340.00,0,"14/05/2025",0,0,0,"170","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),103,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (103,"23/05/2025","25/05/2025",2,0,0,0,"SCHIFONI MARCELLO","SCHIFONI MARCELLO","","","","","","","",300.00,300.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-04-2025',103),103,'10/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (103,"10/07/2025","13/07/2025",2,0,0,0,"MAURIZIO DOMENICI","MAURIZIO DOMENICI","","","","","","","",600.00,600.00,0,"02/05/2025",0,0,0,"PAPA NOTAIO DOMENICI","BOOKRS",0,"25/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-05-2025',103),103,'23/06/2025 - 26/06/2025','INSERT INTO PRENOTAZIONE VALUES (103,"23/06/2025","26/06/2025",2,0,0,0,"MANUELA ED ENRICO","MANUELA ED ENRICO","","","","","","","",510.00,510.00,0,"17/05/2025",0,0,0,"","BOOKRS",0,"10/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),103,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=103, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=103 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-05-2025',103),103,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (103,"30/05/2025","02/06/2025",2,0,0,0,"GRUPPO MUSTO","GRUPPO MUSTO","","","","","","","",470.00,470.00,0,"22/05/2025",0,0,0,"","BOOKRS",0,"15/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),103,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (103,"19/06/2025","22/06/2025",2,0,0,0,"ELSA E MASSIMO","ELSA E MASSIMO","","","","","","","",510.00,510.00,0,"11/04/2025",0,0,0,"180","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),104,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (104,"23/05/2025","25/05/2025",2,0,0,0,"MURA PRIANO","MURA PRIANO","","","","","","","",280.00,280.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),105,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (105,"23/05/2025","25/05/2025",2,0,0,0,"FRANCESCO GESUALDI ","FRANCESCO GESUALDI","","","","","","","",280.00,280.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),107,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="VALENTINA BRIZIARELLI", COGNOME="VALENTINA BRIZIARELLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 CAMERA ECONOMY", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=680.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=107 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),107,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (107,"23/05/2025","25/05/2025",2,0,0,0,"CATALIN","CATALIN","","","","","","","",240.00,240.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-03-2025',103),107,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="VALENTINA BRIZIARELLI", COGNOME="VALENTINA BRIZIARELLI", INDIRIZZO="", RAGSOC="ELEONORA NALDINI (MIA FIGLIA) E NINA DE PASQUALE", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 CAMERA ECONOMY VERIFICARE ACCONTO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=680.00, ACCONTO=204.00, ENTROIL="12/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=107 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),107,'23/07/2025 - 27/07/2025','INSERT INTO PRENOTAZIONE VALUES (107,"23/07/2025","27/07/2025",2,0,0,0,"VALENTINA BRIZIARELLI","VALENTINA BRIZIARELLI","","","","","","","",600.00,600.00,0,"18/03/2025",0,0,0,"170 CAMERA ECONOMY","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),108,'23/07/2025 - 27/07/2025','INSERT INTO PRENOTAZIONE VALUES (108,"23/07/2025","27/07/2025",2,1,0,0,"VALENTINA BRIZIARELLI","VALENTINA BRIZIARELLI","","","","","","","",600.00,600.00,0,"18/03/2025",0,0,0,"240 CAMERA TRIPLA ECONOMY","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),108,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="VALENTINA BRIZIARELLI", COGNOME="VALENTINA BRIZIARELLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="240 CAMERA TRIPLA ECONOMY", NB=1, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=960.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=108 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),108,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (108,"23/05/2025","25/05/2025",2,0,0,0,"ANGELA MANCINI","ANGELA MANCINI","","","","","","","",240.00,240.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),108,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="VALENTINA BRIZIARELLI", COGNOME="VALENTINA BRIZIARELLI", INDIRIZZO="", RAGSOC="ELEONORA D’OSTUNI, VALERIA BRANDOLO E AGATA ARCUDI", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="240 CAMERA TRIPLA ECONOMY", NB=1, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=960.00, ACCONTO=288.00, ENTROIL="13/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=108 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),201,'04/07/2025 - 06/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"04/07/2025","06/07/2025",2,0,0,0,"FEDERICO GABRIELE","FEDERICO GABRIELE","","","","","","","",400.00,400.00,0,"06/05/2025",0,0,0,"220","BOOKRS",0,"29/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),201,'04/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="FEDERICO GABRIELE", COGNOME="FEDERICO GABRIELE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220", NB=0, NA=2, MPA=0, MPB=0, TOTALE=400.00, CONCORDATO=440.00, ACCONTO=0.00, ENTROIL="06/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="29/04/2025" where num=201 and DAL=#07/04/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="VALERIA COSENTINO ALESI", COGNOME="VALERIA COSENTINO ALESI", INDIRIZZO="", RAGSOC="VISA N. 4025 4724 6457 1599 SCAD 06/26", CAP="", CITTA="", PROV="", TEL="3355975763", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'28-04-2025',103),201,'23/06/2025 - 30/06/2025','UPDATE PRENOTAZIONE SET NOME="AMICO MARIO COLATEI", COGNOME="AMICO MARIO COLATEI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 A NOTTE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1310.00, CONCORDATO=1120.00, ACCONTO=0.00, ENTROIL="05/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="28/04/2025" where num=201 and DAL=#06/23/2025# and AL=#06/30/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'30-04-2025',103),201,'18/06/2025 - 24/06/2025','UPDATE PRENOTAZIONE SET NOME="PIERLUIGI PALMIGIANI", COGNOME="PIERLUIGI PALMIGIANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1020.00, CONCORDATO=1020.00, ACCONTO=306.00, ENTROIL="30/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="30/04/2025" where num=201 and DAL=#06/18/2025# and AL=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),201,'18/06/2025 - 24/06/2025','UPDATE PRENOTAZIONE SET NOME="PIERLUIGI PALMIGIANI", COGNOME="PIERLUIGI PALMIGIANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1020.00, CONCORDATO=1020.00, ACCONTO=306.00, ENTROIL="04/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="30/04/2025" where num=201 and DAL=#06/18/2025# and AL=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'19-03-2025',103),201,'09/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="GIUSEPPE MURENA", COGNOME="GIUSEPPE MURENA", INDIRIZZO="", RAGSOC="AMICO CESARO", CAP="", CITTA="", PROV="", TEL="3487081901", EMAIL="", NOTEP="210 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=800.00, CONCORDATO=800.00, ACCONTO=252.00, ENTROIL="19/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/03/2025" where num=201 and DAL=#07/09/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (201,"23/05/2025","25/05/2025",2,0,0,0,"FILIPPO APOLLONI ","FILIPPO APOLLONI","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"150 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),201,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"13/06/2025","15/06/2025",2,0,0,0,"EDOARDO STANISCIA","EDOARDO STANISCIA","","","","","","","",340.00,340.00,0,"11/04/2025",0,0,0,"NON HO DETTO IL PREZZO","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),201,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 BONIFICO 630 X 3 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=201 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),201,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-03-2025',103),201,'09/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"09/07/2025","13/07/2025",2,0,0,0,"GIUSEPPE MURENA","GIUSEPPE MURENA","AMICO CESARO","","","","","3487081901","",800.00,800.00,0,"22/03/2025",0,0,0,"210","BOOKRS",0,"15/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),201,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="FILIPPO APOLLONI ", COGNOME="FILIPPO APOLLONI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3488057210", EMAIL="", NOTEP="150 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=300.00, ACCONTO=150.00, ENTROIL="13/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-04-2025',103),201,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="ELSA E MASSIMO", COGNOME="ELSA E MASSIMO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="180", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=540.00, ACCONTO=0.00, ENTROIL="11/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="04/04/2025" where num=201 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="FILIPPO APOLLONI ", COGNOME="FILIPPO APOLLONI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3488057210", EMAIL="", NOTEP="150 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=300.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'28-04-2025',103),201,'23/06/2025 - 30/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"23/06/2025","30/06/2025",2,0,0,0,"AMICO MARIO COLATEI","AMICO MARIO COLATEI","","","","","","","",1310.00,1310.00,0,"05/05/2025",0,0,0,"160 A NOTTE","BOOKRS",0,"28/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="VALERIA COSENTINO ALESI", COGNOME="VALERIA COSENTINO ALESI", INDIRIZZO="", RAGSOC="VISA N. 4025 4724 6457 1599 SCAD 06/26", CAP="", CITTA="", PROV="", TEL="3355975763", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="11/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'30-04-2025',103),201,'18/06/2025 - 24/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"18/06/2025","24/06/2025",2,0,0,0,"PIERLUIGI PALMIGIANI","PIERLUIGI PALMIGIANI","","","","","","","",1020.00,1020.00,0,"07/05/2025",0,0,0,"170","BOOKRS",0,"30/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),201,'07/07/2025 - 09/07/2025','UPDATE PRENOTAZIONE SET NOME="MONTELLA AMICO CESARO", COGNOME="MONTELLA AMICI CESARO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=400.00, CONCORDATO=420.00, ACCONTO=210.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/03/2025" where num=201 and DAL=#07/07/2025# and AL=#07/09/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'10/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO PANSA ", COGNOME="ALESSNDRO PANDA AMICO NOTAIO CESARO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO ", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="11/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="10/03/2025" where num=201 and DAL=#07/10/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),201,'09/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="GIUSEPPE MURENA", COGNOME="GIUSEPPE MURENA", INDIRIZZO="", RAGSOC="AMICO CESARO", CAP="", CITTA="", PROV="", TEL="3487081901", EMAIL="", NOTEP="210 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=800.00, CONCORDATO=840.00, ACCONTO=252.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/03/2025" where num=201 and DAL=#07/09/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),201,'08/07/2025 - 11/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"08/07/2025","11/07/2025",2,0,0,0,"PROF. PIGNALOSA","PROF. PIGNALOSA","","","","","","","",600.00,600.00,0,"25/04/2025",0,0,0,"","BOOKRS",0,"18/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),201,'07/07/2025 - 09/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"07/07/2025","09/07/2025",2,0,0,0,"MONTELLA AMICO CESARO","MONTELLA AMICI CESARO","","","","","","","",400.00,400.00,0,"20/03/2025",0,0,0,"210","BOOKRS",0,"13/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="VALERIA COSENTINO ALESI", COGNOME="VALERIA COSENTINO ALESI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-03-2025',103),201,'10/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO PANSA ", COGNOME="ALESSNDRO PANDA AMICO NOTAIO CESARO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO ", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=600.00, ACCONTO=0.00, ENTROIL="17/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="10/03/2025" where num=201 and DAL=#07/10/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),201,'27/06/2025 - 30/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"27/06/2025","30/06/2025",2,0,0,0,"MARIO SCHIAROLI","MARIO SCHIAROLI ","","","","","","","",600.00,600.00,0,"14/05/2025",0,0,0,"200 AMICO COLATEI","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),201,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=201, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=201 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="VALERIA COSENTINO ALESI", COGNOME="VALERIA COSENTINO ALESI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3355975763", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=201 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),201,'18/06/2025 - 21/06/2025','UPDATE PRENOTAZIONE SET NOME="FERNANDO MIRAGLIA", COGNOME="FERNANDO MIRAGLIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="180 CAMERA VISTA MARE BALCONE 2 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=540.00, ACCONTO=180.00, ENTROIL="27/01/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=201 and DAL=#06/18/2025# and AL=#06/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-03-2025',103),201,'10/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"10/07/2025","13/07/2025",2,0,0,0,"ALESSANDRO PANSA ","ALESSNDRO PANDA AMICO NOTAIO CESARO","","","","","","","",600.00,600.00,0,"17/03/2025",0,0,0,"210","BOOKRS",0,"10/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),201,'18/06/2025 - 21/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"18/06/2025","21/06/2025",2,0,0,0,"FERNANDO MIRAGLIA","FERNANDO MIRAGLIA","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"180 CAMERA VISTA MARE BALCONE 2 CAMERE","BOOKRS",0,"27/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"06/07/2025","07/07/2025",2,0,0,0,"VALERIA COSENTINO ALESI","VALERIA COSENTINO ALESI","","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190 GRUPPO PROSPERI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="MARCO VISCOGLIOSI", COGNOME="MARCO VISCOGLIOSI", INDIRIZZO="", RAGSOC="INTESA SAN PAOLO N. 4471 4931 0432 4958 SCAD. 12/29", CAP="", CITTA="", PROV="", TEL="3930692400", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=202 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="MARCO VISCOGLIOSI", COGNOME="MARCO VISCOGLIOSI", INDIRIZZO="", RAGSOC="INTESA SAN PAOLO N. 4471 4931 0432 4958 SCAD. 12/2", CAP="", CITTA="", PROV="", TEL="3930692400", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="11/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="11/03/2025" where num=202 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),202,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=202 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),202,'08/07/2025 - 11/07/2025','INSERT INTO PRENOTAZIONE VALUES (202,"08/07/2025","11/07/2025",2,0,0,0,"PROF. PIGNALOSA","PROF. PIGNALOSA","","","","","","","",600.00,600.00,0,"25/04/2025",0,0,0,"","BOOKRS",0,"18/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-04-2025',103),202,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (202,"19/06/2025","22/06/2025",2,0,0,0,"REDI","REDI","","","","","","","",510.00,510.00,0,"02/05/2025",0,0,0,"","BOOKRS",0,"25/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-04-2025',103),202,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="REDI", COGNOME="REDI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="02/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="25/04/2025" where num=202 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-05-2025',103),202,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (202,"30/05/2025","02/06/2025",2,0,0,0,"GRUPPO MUSTO","GRUPPO MUSTO","","","","","","","",470.00,470.00,0,"22/05/2025",0,0,0,"","BOOKRS",0,"15/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),202,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="M CEREA", COGNOME="M CEREA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="GRUPO ANIENI 150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=300.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=202 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),202,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (202,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),202,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=202, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=202 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="MARCO VISCOGLIOSI", COGNOME="MARCO VISCOGLIOSI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3930692400", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=202 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (202,"06/07/2025","07/07/2025",2,0,0,0,"MARCO VISCOGLIOSI","MARCO VISCOGLIOSI","","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190 GRUPPO PROSPERI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),202,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (202,"13/06/2025","15/06/2025",2,0,0,0,"EDOARDO STANISCIA","EDOARDO STANISCIA","","","","","","","",340.00,340.00,0,"11/04/2025",0,0,0,"NONN HO DETTO IL PREZZO","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (202,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"GRUPO ANIENI 150","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=450.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=0.00, ENTROIL="06/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-02-2025',103),203,'07/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (203,"07/07/2025","13/07/2025",2,0,0,0,"NOTAIO CERASO","NOTAIO CERASO","","","","","","","",1200.00,1200.00,0,"06/03/2025",0,0,0,"","BOOKRS",0,"27/02/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-05-2025',103),203,'19/06/2025 - 23/06/2025','UPDATE PRENOTAZIONE SET NOME="AUGUSTO CHIOSI", COGNOME="AUGUSTO CHIOSI ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=0.00, ENTROIL="19/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="12/05/2025" where num=203 and DAL=#06/19/2025# and AL=#06/23/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),203,'12/06/2025 - 16/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"12/06/2025","16/06/2025",2,0,0,0,"MIEDICO ANTONIO","MIEDICO ANTONIO","","","","","","","",680.00,680.00,0,"31/03/2025",0,0,0,"150","BOOKRS",0,"24/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),203,'12/06/2025 - 16/06/2025','UPDATE PRENOTAZIONE SET NOME="MIEDICO ANTONIO", COGNOME="MIEDICO ANTONIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=600.00, ACCONTO=0.00, ENTROIL="31/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=203 and DAL=#06/12/2025# and AL=#06/16/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-05-2025',103),203,'19/06/2025 - 23/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"19/06/2025","23/06/2025",2,0,0,0,"AUGUSTO CHIOSI","AUGUSTO CHIOSI ","","","","","","","",680.00,680.00,0,"19/05/2025",0,0,0,"190","BOOKRS",0,"12/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),203,'18/06/2025 - 21/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"18/06/2025","21/06/2025",2,0,0,0,"FERNANDO MIRAGLIA","FERNANDO MIRAGLIA","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"180 CAMERA VISTA MARE BALCONE","BOOKRS",0,"27/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),203,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (203,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),203,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=203 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-03-2025',103),203,'12/06/2025 - 16/06/2025','UPDATE PRENOTAZIONE SET NOME="MIEDICO ANTONIO", COGNOME="MIEDICO ANTONIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=600.00, ACCONTO=180.00, ENTROIL="25/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=203 and DAL=#06/12/2025# and AL=#06/16/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'28-04-2025',103),203,'23/06/2025 - 30/06/2025','UPDATE PRENOTAZIONE SET NOME="MARIO COLATEI", COGNOME="MARIO COLATEI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 A NOTTE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1310.00, CONCORDATO=1120.00, ACCONTO=0.00, ENTROIL="05/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="28/04/2025" where num=203 and DAL=#06/23/2025# and AL=#06/30/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-05-2025',103),203,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="PIERLUIGI VINGOLO", COGNOME="PIERLUIGI VINGOLO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING CARTA DI CREDITO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=558.90, ACCONTO=0.00, ENTROIL="12/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/05/2025" where num=203 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'21-01-2025',103),203,'18/08/2025 - 25/08/2025','INSERT INTO PRENOTAZIONE VALUES (203,"18/08/2025","25/08/2025",2,0,0,0,"DONATELLA PAI","DONATELLA PAI","","","","","","","",1600.00,1600.00,0,"28/01/2025",0,0,0,"210","BOOKRS",0,"21/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),203,'06/06/2025 - 08/06/2025','UPDATE PRENOTAZIONE SET NOME="ANNALISA ALCESTE", COGNOME="ANNALISA ALCESTE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="12/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/04/2025" where num=203 and DAL=#06/06/2025# and AL=#06/08/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'21-01-2025',103),203,'18/08/2025 - 25/08/2025','UPDATE PRENOTAZIONE SET NOME="DONATELLA PAI", COGNOME="DONATELLA PAI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1600.00, CONCORDATO=1470.00, ACCONTO=0.00, ENTROIL="28/01/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="21/01/2025" where num=203 and DAL=#08/18/2025# and AL=#08/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="CARLA MARONI DE STEFANO", COGNOME="CARLA MARONI DE STEFANO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3398522244", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="CARLA MARONI DE STEFANO", COGNOME="CARLA MARONI DE STEFANO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3398522244", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=190.00, ENTROIL="11/03/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (203,"06/07/2025","07/07/2025",2,0,0,0,"CARLA MARONI DE STEFANO","CARLA MARONI DE STEFANO","","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190 GRUPPO PROSPERI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),203,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="CARFAGNI DARIO", COGNOME="CARFAGNI DARIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=300.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),203,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="CARLA MARONI DE STEFANO", COGNOME="CARLA MARONI DE STEFANO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3398522244", EMAIL="", NOTEP="190 GRUPPO PROSPERI OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=190.00, ENTROIL="13/03/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'28-04-2025',103),203,'23/06/2025 - 30/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"23/06/2025","30/06/2025",2,0,0,0,"MARIO COLATEI","MARIO COLATEI","","","","","","","",1310.00,1310.00,0,"05/05/2025",0,0,0,"","BOOKRS",0,"28/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (203,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"150 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="CARLA MARONI DE STEFANO", COGNOME="CARLA MARONI DE STEFANO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),203,'18/06/2025 - 21/06/2025','UPDATE PRENOTAZIONE SET NOME="FERNANDO MIRAGLIA", COGNOME="FERNANDO MIRAGLIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="180 CAMERA VISTA MARE BALCONE 2 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=540.00, ACCONTO=180.00, ENTROIL="27/01/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=203 and DAL=#06/18/2025# and AL=#06/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-05-2025',103),203,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="PIERLUIGI VINGOLO", COGNOME="PIERLUIGI VINGOLO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING CARTA DI CREDITO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=558.90, ACCONTO=0.00, ENTROIL="11/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="05/05/2025" where num=203 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-05-2025',103),203,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"30/05/2025","02/06/2025",2,0,0,0,"PIERLUIGI VINGOLO","PIERLUIGI VINGOLO","","","","","","","",470.00,470.00,0,"12/05/2025",0,0,0,"BOOKING CARTA DI CREDITO","BOOKRS",0,"05/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=450.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),203,'06/06/2025 - 08/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"06/06/2025","08/06/2025",2,0,0,0,"ANNALISA ALCESTE","ANNALISA ALCESTE","","","","","","","",340.00,340.00,0,"12/04/2025",0,0,0,"160","BOOKRS",0,"05/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-05-2025',103),204,'31/05/2025 - 03/06/2025','UPDATE PRENOTAZIONE SET NOME="ANGELICA TERREZZA", COGNOME="ANGELICA TERREZZA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING", NB=0, NA=2, MPA=0, MPB=0, TOTALE=440.00, CONCORDATO=517.50, ACCONTO=0.00, ENTROIL="12/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="05/05/2025" where num=204 and DAL=#05/31/2025# and AL=#06/03/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),204,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (204,"23/05/2025","25/05/2025",2,0,0,0,"REGIS","REGIS","","","","","","","",280.00,280.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-05-2025',103),204,'31/05/2025 - 03/06/2025','UPDATE PRENOTAZIONE SET NOME="ANGELICA TERREZZA", COGNOME="ANGELICA TERREZZA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING", NB=0, NA=2, MPA=0, MPB=0, TOTALE=440.00, CONCORDATO=517.50, ACCONTO=0.00, ENTROIL="12/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/05/2025" where num=204 and DAL=#05/31/2025# and AL=#06/03/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-05-2025',103),204,'31/05/2025 - 03/06/2025','INSERT INTO PRENOTAZIONE VALUES (204,"31/05/2025","03/06/2025",2,0,0,0,"ANGELICA TERREZZA","ANGELICA TERREZZA","","","","","","","",440.00,440.00,0,"12/05/2025",0,0,0,"BOOKING","BOOKRS",0,"05/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2025',103),205,'16/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (205,"16/07/2025","20/07/2025",2,1,0,0,"EMANUELA GEROSA","EMANUELA GEROSA","","","","","","","",800.00,800.00,0,"10/03/2025",0,0,0,"270","BOOKRS",0,"03/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),205,'17/06/2025 - 20/06/2025','UPDATE PRENOTAZIONE SET NOME="FRANCESCO ROMANI", COGNOME="FRANCESCO ROMANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="240 TRIPLA CON TERRAZZA", NB=1, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=720.00, ACCONTO=240.00, ENTROIL="24/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=205 and DAL=#06/17/2025# and AL=#06/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),205,'17/06/2025 - 20/06/2025','UPDATE PRENOTAZIONE SET NOME="FRANCESCO ROMANI", COGNOME="FRANCESCO ROMANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="240 TRIPLA CON TERRAZZA", NB=1, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=720.00, ACCONTO=0.00, ENTROIL="31/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=205 and DAL=#06/17/2025# and AL=#06/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),205,'17/06/2025 - 20/06/2025','INSERT INTO PRENOTAZIONE VALUES (205,"17/06/2025","20/06/2025",2,1,0,0,"FRANCESCO ROMANI","FRANCESCO ROMANI","","","","","","","",510.00,510.00,0,"31/03/2025",0,0,0,"240 TRIPLA CON TERRAZZA","BOOKRS",0,"24/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),205,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (205,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",300.00,300.00,0,"14/04/2025",0,0,0,"184","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),205,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="184", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=368.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=205 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2025',103),205,'16/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="EMANUELA GEROSA", COGNOME="EMANUELA GEROSA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="270", NB=1, NA=2, MPA=0, MPB=0, TOTALE=800.00, CONCORDATO=1080.00, ACCONTO=0.00, ENTROIL="10/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2025" where num=205 and DAL=#07/16/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'16-02-2025',103),206,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO OLIVA", COGNOME="ALESSANDRO OLIVA", INDIRIZZO="", RAGSOC="EFFETTUATO BONIFICO DI EURO 810 X LE DUE CAMERE", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190", NB=1, NA=2, MPA=0, MPB=0, TOTALE=1140.00, CONCORDATO=1560.00, ACCONTO=700.00, ENTROIL="16/02/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/02/2025" where num=206 and DAL=#08/11/2025# and AL=#08/17/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),206,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (206,"23/05/2025","25/05/2025",2,0,0,0,"PATRIARCA GESUALDI","PATRIARCA GESUALDI","","","","","","","",260.00,260.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'22-02-2025',103),206,'21/06/2025 - 23/06/2025','INSERT INTO PRENOTAZIONE VALUES (206,"21/06/2025","23/06/2025",2,1,0,0,"MARCO DOMINICI","MARCO DOMINICI","","","","","","","",280.00,280.00,0,"01/03/2025",0,0,0,"220 TRIPLA ","BOOKRS",0,"22/02/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'16-02-2025',103),206,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO OLIVA", COGNOME="ALESSANDRO OLIVA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190", NB=1, NA=2, MPA=0, MPB=0, TOTALE=1140.00, CONCORDATO=1560.00, ACCONTO=700.00, ENTROIL="16/02/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/02/2025" where num=206 and DAL=#08/11/2025# and AL=#08/17/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),206,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO OLIVA", COGNOME="ALESSANDRO OLIVA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190", NB=1, NA=2, MPA=0, MPB=0, TOTALE=1140.00, CONCORDATO=1560.00, ACCONTO=0.00, ENTROIL="20/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="13/02/2025" where num=206 and DAL=#08/11/2025# and AL=#08/17/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),206,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NUM=206, DAL=#08/11/2025#, AL=#08/17/2025#, TOTALE=1140.00, CONCORDATO=1140.00 WHERE NUM=206 AND dal=#08/10/2025# and al=#08/11/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),206,'10/08/2025 - 11/08/2025','INSERT INTO PRENOTAZIONE VALUES (206,"10/08/2025","11/08/2025",2,1,0,0,"ALESSANDRO OLIVA","ALESSANDRO OLIVA","","","","","","","",170.00,170.00,0,"20/02/2025",0,0,0,"N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190","BOOKRS",0,"13/02/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'22-02-2025',103),206,'21/06/2025 - 23/06/2025','UPDATE PRENOTAZIONE SET NOME="MARCO DOMINICI", COGNOME="MARCO DOMINICI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 TRIPLA ATTESA BONIFICO", NB=1, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=440.00, ACCONTO=0.00, ENTROIL="01/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="22/02/2025" where num=206 and DAL=#06/21/2025# and AL=#06/23/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),207,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="GUIDO COEN ", COGNOME="GUIDO COEN ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="120 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=240.00, CONCORDATO=240.00, ACCONTO=120.00, ENTROIL="13/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/03/2025" where num=207 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),207,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="GUIDO CHOEN ", COGNOME="GUIDO CHOEN ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="120 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=240.00, CONCORDATO=240.00, ACCONTO=120.00, ENTROIL="07/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/03/2025" where num=207 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),207,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (207,"23/05/2025","25/05/2025",2,0,0,0,"GUIDO COEN ","GUIDO COEN ","","","","","","","",240.00,240.00,0,"20/03/2025",0,0,0,"120 GRUPPO ANIENI","BOOKRS",0,"13/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-04-2025',103),208,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=300.00, CONCORDATO=300.00 WHERE NUM=208 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),208,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=300.00, CONCORDATO=300.00 WHERE NUM=208 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),208,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=150.00, CONCORDATO=150.00 WHERE NUM=208 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),208,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (208,"06/07/2025","07/07/2025",2,0,0,0,"MARCO MARRANA","MARCO MARRANA","","","","","","","",150.00,150.00,0,"18/03/2025",0,0,0,"BOOKING 162 DA PRELEVARE","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),208,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="MARCO MARRANA", COGNOME="MARCO MARRANA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING 162 DA PRELEVARE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=150.00, CONCORDATO=162.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=208 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),208,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (208,"23/05/2025","25/05/2025",2,0,0,0,"LORENZO PORZIO","LORENZO PORZIO","","","","","","","",240.00,240.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),301,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NOME="LINDA STEFANETTI", COGNOME="LINDA STEFANETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=340.00, ENTROIL="18/04/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=301 and DAL=#06/05/2025# and AL=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),301,'13/06/2025 - 15/06/2025','UPDATE PRENOTAZIONE SET NOME=" ANTONIO DEL MANSO", COGNOME=" ANTONIO DEL MANSO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" 3465145407", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=170.00, ENTROIL="29/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="29/04/2025" where num=301 and DAL=#06/13/2025# and AL=#06/15/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),301,'13/06/2025 - 15/06/2025','UPDATE PRENOTAZIONE SET NOME=" ANTONIO DEL MANSO", COGNOME=" ANTONIO DEL MANSO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" 3465145407", EMAIL="", NOTEP="170 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=170.00, ENTROIL="04/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="29/04/2025" where num=301 and DAL=#06/13/2025# and AL=#06/15/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),301,'13/06/2025 - 15/06/2025','UPDATE PRENOTAZIONE SET NOME=" ANTONIO DEL MANSO", COGNOME=" ANTONIO DEL MANSO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" 3465145407", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=0.00, ENTROIL="06/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="29/04/2025" where num=301 and DAL=#06/13/2025# and AL=#06/15/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),301,'13/06/2025 - 15/06/2025','UPDATE PRENOTAZIONE SET NOME=" ANTONIO DEL MANSO", COGNOME=" ANTONIO DEL MANSO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" 3465145407", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=0.00, ENTROIL="06/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="29/04/2025" where num=301 and DAL=#06/13/2025# and AL=#06/15/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'29-04-2025',103),301,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"13/06/2025","15/06/2025",2,0,0,0," ANTONIO DEL MANSO"," ANTONIO DEL MANSO","","","","","","","",340.00,340.00,0,"06/05/2025",0,0,0,"170","BOOKRS",0,"29/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-04-2025',103),301,'12/08/2025 - 16/08/2025','INSERT INTO PRENOTAZIONE VALUES (301,"12/08/2025","16/08/2025",2,0,0,0,"DANIELA FRATESI","DANIELA FRATESI","","","","","","","danielafratesi6@gmail.com",960.00,960.00,0,"02/05/2025",0,0,0,"240","BOOKRS",0,"25/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'19-04-2025',103),301,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"30/05/2025","02/06/2025",2,0,0,0,"GIOVAGNOLI FIGLIO","GIOVAGNOLI FIGLIO","","","","","","","",470.00,470.00,0,"26/04/2025",0,0,0,"190","BOOKRS",0,"19/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),301,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="RIZZA STEFANO E FEDERICA", COGNOME="RIZZA STEFANO E FEDERICA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=301 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-03-2025',103),301,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="RIZZA STEFANO E FEDERICA", COGNOME="RIZZA STEFANO E FEDERICA", INDIRIZZO="", RAGSOC="AMERICAN EXPRESS: N 375288071412009 SCADENZA12/25.", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="12/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="11/03/2025" where num=301 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'19-04-2025',103),301,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="GIOVAGNOLI FIGLIO", COGNOME="GIOVAGNOLI FIGLIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="26/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="19/04/2025" where num=301 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),301,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="MARIO MAZANTI", COGNOME="MARIO MAZZANTI", INDIRIZZO="", RAGSOC="GRUPPO COLLI ANIENI", CAP="", CITTA="", PROV="", TEL="3299432824", EMAIL="", NOTEP="160", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=301 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),301,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (301,"23/05/2025","25/05/2025",2,0,0,0,"MARIO MAZANTI","MARIO MAZZANTI","GRUPPO COLLI ANIENI","","","","","3299432824","",300.00,300.00,0,"18/03/2025",0,0,0,"160","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-05-2025',103),301,'29/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"29/05/2025","02/06/2025",2,0,0,0,"DANIELA ZANZURI","DANIELA ZANZURI","","","","","","","",620.00,620.00,0,"17/05/2025",0,0,0,"","BOOKRS",0,"10/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),301,'12/08/2025 - 16/08/2025','UPDATE PRENOTAZIONE SET NOME="DANIELA FRATESI", COGNOME="DANIELA FRATESI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="danielafratesi6@gmail.com", NOTEP="240 OK ", NB=0, NA=2, MPA=0, MPB=0, TOTALE=960.00, CONCORDATO=960.00, ACCONTO=288.00, ENTROIL="04/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="25/04/2025" where num=301 and DAL=#08/12/2025# and AL=#08/16/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),301,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (301,"06/07/2025","07/07/2025",2,0,0,0,"RIZZA STEFANO E FEDERICA","RIZZA STEFANO E FEDERICA","","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-05-2025',103),301,'30/05/2025 - 06/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"30/05/2025","06/06/2025",2,0,0,0,"PAUL HOLT","PAUL HOLT","","","","","","","",1150.00,1150.00,0,"18/05/2025",0,0,0,"","BOOKRS",0,"11/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-05-2025',103),301,'30/05/2025 - 06/06/2025','UPDATE PRENOTAZIONE SET NOME="PAUL HOLT", COGNOME="PAUL HOLT", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 A NOTTE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1150.00, CONCORDATO=1190.00, ACCONTO=0.00, ENTROIL="18/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/05/2025" where num=301 and DAL=#05/30/2025# and AL=#06/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-03-2025',103),301,'26/06/2025 - 29/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"26/06/2025","29/06/2025",2,0,0,0,"RAFFAELE TARTAGLIONE","RAFFAELE TARTAGLIONE","","","","","","","",600.00,600.00,0,"14/03/2025",0,0,0,"CAMERA SUPERIOR 210 ATTESA BONIFICO","BOOKRS",0,"07/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-05-2025',103),301,'30/05/2025 - 06/06/2025','UPDATE PRENOTAZIONE SET NOME="PAUL HOLT", COGNOME="PAUL HOLT", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 A NOTTE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1150.00, CONCORDATO=1190.00, ACCONTO=357.00, ENTROIL="12/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/05/2025" where num=301 and DAL=#05/30/2025# and AL=#06/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),301,'30/05/2025 - 06/06/2025','UPDATE PRENOTAZIONE SET NOME="PAUL HOLT", COGNOME="PAUL HOLT", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 A NOTTE OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1150.00, CONCORDATO=1190.00, ACCONTO=357.00, ENTROIL="14/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/05/2025" where num=301 and DAL=#05/30/2025# and AL=#06/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),301,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="PIRRO/FABENI ", COGNOME="PIRRO/FABENI ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 CAMERA SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="03/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=301 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),301,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"19/06/2025","22/06/2025",2,0,0,0,"PIRRO/FABENI ","PIRRO/FABENI ","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"190 CAMERA SUPERIOR","BOOKRS",0,"27/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-05-2025',103),301,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="GIOVAGNOLI FIGLIO", COGNOME="GIOVAGNOLI FIGLIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=570.00, ACCONTO=570.00, ENTROIL="10/05/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="19/04/2025" where num=301 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#06/05/2025#, AL=#06/07/2025#, TOTALE=340.00, CONCORDATO=340.00 WHERE NUM=301 AND dal=#06/06/2025# and al=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),301,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONE", COGNOME="RAFFAELE TARTAGLIONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="CAMERA SUPERIOR 210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="07/03/2025" where num=301 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'03/07/2025 - 06/07/2025','INSERT INTO PRENOTAZIONE VALUES (301,"03/07/2025","06/07/2025",2,0,0,0,"ANDREA GIOVAGNOLI","ANDREA GIOVAGNOLI","","","","","","","",600.00,600.00,0,"20/04/2025",0,0,0,"220 SUPERIOR","BOOKRS",0,"13/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="13/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=600.00, ACCONTO=220.00, ENTROIL="13/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'06/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"06/06/2025","07/06/2025",2,0,0,0,"LINDA STEFANETTI","LINDA STEFANETTI","","","","","","","",170.00,170.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=0.00, ENTROIL="20/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),301,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=301 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),301,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=301 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','INSERT INTO PRENOTAZIONE VALUES (301,"18/07/2025","21/07/2025",2,0,0,0,"ELENA PETRALIA ","ELENA PETRALIA","","","","","","","",600.00,600.00,0,"20/04/2025",0,0,0,"220 SUPERIOR","BOOKRS",0,"13/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),302,'26/06/2025 - 29/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"26/06/2025","29/06/2025",2,0,0,0,"RAFFAELE TARTAGLIONEAMICI","RAFFAELE TARTAGLIONE AMICI","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210 ATTESA BONIFICO","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),302,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONEAMICI", COGNOME="RAFFAELE TARTAGLIONE AMICI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="08/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=302 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),302,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONEAMICI", COGNOME="IODICE PASQUALE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=302 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),302,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=302, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=302 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),302,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (302,"06/07/2025","07/07/2025",2,0,0,0,"ENZA BURATO E CIRO TAMBURELLA","ENZA BURATO E CIRO TAMBURELLA","","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),302,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="ENZA BURATO E CIRO TAMBURELLA", COGNOME="ENZA BURATO E CIRO TAMBURELLA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 CAMERA SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=302 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),302,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONE AMICI", COGNOME="IODICE AMALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="14/05/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=302 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),302,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=302, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=302 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),302,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="SANDRO CEREA", COGNOME="SANDRO CEREA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=302 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),302,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="COGNETTI FRANCESCO", COGNOME="COGNETTI FRANCESCO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=302 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),302,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="PORTANOVA/PICHILLI", COGNOME="PORTANOVA/PICHILLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 CAMERA SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="03/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=302 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),302,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"19/06/2025","22/06/2025",2,0,0,0,"PORTANOVA/PICHILLI","PORTANOVA/PICHILLI","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"190 CAMERA SUPERIOR","BOOKRS",0,"27/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),302,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NOME="FRANCESCO PALMEGGIANI", COGNOME="FRANCESCO PALMEGGIANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=340.00, ENTROIL="18/04/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=302 and DAL=#06/05/2025# and AL=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),302,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"05/06/2025","07/06/2025",2,0,0,0,"FRANCESCO PALMEGGIANI","FRANCESCO PALMEGGIANI","","","","","","","",340.00,340.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),302,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (302,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"160 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),302,'05/06/2025 - 08/06/2025','UPDATE PRENOTAZIONE SET NUM=302, DAL=#06/05/2025#, AL=#06/08/2025#, TOTALE=510.00, CONCORDATO=510.00 WHERE NUM=302 AND dal=#06/05/2025# and al=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),303,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=303 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'17-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" (+39) 348 0705494", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="17/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),303,'19/06/2025 - 23/06/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#06/19/2025#, AL=#06/23/2025#, TOTALE=680.00, CONCORDATO=680.00 WHERE NUM=303 AND dal=#06/20/2025# and al=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),303,'20/06/2025 - 24/06/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIO GHIRELLI", COGNOME="GIORGIO GHIRELLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=0.00, ENTROIL="12/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/04/2025" where num=303 and DAL=#06/20/2025# and AL=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),303,'20/06/2025 - 24/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"20/06/2025","24/06/2025",2,0,0,0,"GIORGIO GHIRELLI","GIORGIO GHIRELLI","","","","","","","",680.00,680.00,0,"12/04/2025",0,0,0,"190","BOOKRS",0,"05/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" (+39) 348 0705494", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="22/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),303,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=303 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),303,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NOME="LUIGI CERONI", COGNOME="LUIGI CERONI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=340.00, ACCONTO=340.00, ENTROIL="18/04/2025", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#06/05/2025# and AL=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"30/05/2025","02/06/2025",2,1,0,0,"CORRADO ANDREAN","CORRADO ANDREAN","","","","","","","",470.00,470.00,0,"22/04/2025",0,0,0,"210 CAMERA VISTA MARE CON BALCONE","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),303,'06/07/2025 - 07/07/2025','INSERT INTO PRENOTAZIONE VALUES (303,"06/07/2025","07/07/2025",2,0,0,0,"PROSPERO DANIELA E CRISTINA COSTANZO","PROSPERO DANIELA E CRISTINA COSTANZO","GRUPPO PROSPERO","","","","","","",200.00,200.00,0,"18/03/2025",0,0,0,"190","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"05/06/2025","07/06/2025",2,0,0,0,"LUIGI CERONI","LUIGI CERONI","","","","","","","",340.00,340.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),303,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (303,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"160 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="22/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),303,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="SANDRO CEREA", COGNOME="SANDRO CEREA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 GRUPPO ANIENI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=303 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),303,'05/06/2025 - 08/06/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#06/05/2025#, AL=#06/08/2025#, TOTALE=510.00, CONCORDATO=510.00 WHERE NUM=303 AND dal=#06/05/2025# and al=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-03-2025',103),304,'30/05/2025 - 05/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE BASSI", COGNOME="RAFFAELE BASSI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="800", NB=0, NA=2, MPA=0, MPB=0, TOTALE=880.00, CONCORDATO=800.00, ACCONTO=240.00, ENTROIL="15/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/03/2025" where num=304 and DAL=#05/30/2025# and AL=#06/05/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-03-2025',103),304,'30/05/2025 - 05/06/2025','INSERT INTO PRENOTAZIONE VALUES (304,"30/05/2025","05/06/2025",2,0,0,0,"RAFFAELE BASSI","RAFFAELE BASSI","","","","","","","",880.00,880.00,0,"22/03/2025",0,0,0,"800","BOOKRS",0,"15/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'19-03-2025',103),304,'30/05/2025 - 05/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE BASSI", COGNOME="RAFFAELE BASSI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="800 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=880.00, CONCORDATO=800.00, ACCONTO=240.00, ENTROIL="19/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/03/2025" where num=304 and DAL=#05/30/2025# and AL=#06/05/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),304,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=300.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=304 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),304,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (304,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",280.00,280.00,0,"14/04/2025",0,0,0,"150","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),305,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (305,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",280.00,280.00,0,"14/04/2025",0,0,0,"168","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),305,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="168", NB=0, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=336.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=305 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),306,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (306,"23/05/2025","25/05/2025",2,0,0,0,"ALBINI OLIVIERO","ALBINI OLIVIERO","","","","","","","",280.00,280.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),307,'10/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="FARINA", COGNOME="FARINA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="0765 30018", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="21/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="14/05/2025" where num=307 and DAL=#07/10/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),307,'10/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (307,"10/07/2025","13/07/2025",2,0,0,0,"FARINA","FARINA","","","","","","0765 30018","",510.00,510.00,0,"21/05/2025",0,0,0,"190","BOOKRS",0,"14/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),307,'23/07/2025 - 27/07/2025','INSERT INTO PRENOTAZIONE VALUES (307,"23/07/2025","27/07/2025",2,0,0,0,"GIORGIA BARBARULO","GIORGIA BARBARULO","CODICE FISCALE BRBGRG72R44F839V","ROMA 00161 VIA PADOVA 53","","","","3200132390","",680.00,680.00,0,"18/03/2025",0,0,0,"180","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),307,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIA BARBARULO", COGNOME="GIORGIA BARBARULO", INDIRIZZO="ROMA 00161 VIA PADOVA 53", RAGSOC="CODICE FISCALE BRBGRG72R44F839V", CAP="", CITTA="", PROV="", TEL="3200132390", EMAIL="", NOTEP="180 CAMERA STANDARD 3 PIANO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=680.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=307 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),307,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIA BARBARULO", COGNOME="GIORGIA BARBARULO", INDIRIZZO="ROMA 00161 VIA PADOVA 53", RAGSOC="CODICE FISCALE BRBGRG72R44F839V", CAP="", CITTA="", PROV="", TEL="3200132390", EMAIL="", NOTEP="180 CAMERA STANDARD 3 PIANO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=720.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=307 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-05-2025',103),307,'31/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (307,"31/05/2025","02/06/2025",2,0,0,0,"ELEONARA NOTARI","ELEONARO NOTARI","","","","","","","",270.00,270.00,0,"25/05/2025",0,0,0,"150","BOOKRS",0,"18/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),307,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIA BARBARULO", COGNOME="GIORGIA BARBARULO", INDIRIZZO="ROMA 00161 VIA PADOVA 53", RAGSOC="CODICE FISCALE BRBGRG72R44F839V", CAP="", CITTA="", PROV="", TEL="3200132390", EMAIL="", NOTEP="180 CAMERA STANDARD 3 PIANO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=720.00, ACCONTO=216.00, ENTROIL="13/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=307 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),307,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (307,"23/05/2025","25/05/2025",2,0,0,0,"MAROCCO MARCO","MAROCCO MARCO","","","","","","","",260.00,260.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-04-2025',103),308,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NOME="MARIA LAURA DE GENNARO ", COGNOME="MARIA LAURA DE GENNARO ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="140 STANDARD OK ACCONTO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=280.00, ACCONTO=140.00, ENTROIL="18/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=308 and DAL=#06/05/2025# and AL=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),308,'10/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="FARINA", COGNOME="FARINA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="21/05/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="14/05/2025" where num=308 and DAL=#07/10/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'14-05-2025',103),308,'10/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (308,"10/07/2025","13/07/2025",2,0,0,0,"FARINA","FARINA","","","","","","","",510.00,510.00,0,"21/05/2025",0,0,0,"190","BOOKRS",0,"14/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'16-02-2025',103),308,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NOME="ALESSANDRO OLIVA", COGNOME="ALESSANDRO OLIVA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1140.00, CONCORDATO=1140.00, ACCONTO=110.00, ENTROIL="16/02/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/02/2025" where num=308 and DAL=#08/11/2025# and AL=#08/17/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-05-2025',103),308,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NUM=308, DAL=#06/05/2025#, AL=#06/07/2025#, TOTALE=280.00, CONCORDATO=280.00 WHERE NUM=308 AND dal=#06/05/2025# and al=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-05-2025',103),308,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (308,"23/05/2025","25/05/2025",2,0,0,0,"VITTORIA CARLI LUCARELLI","VITTORIA CARLI LUCARELLI","","","","","","","",260.00,260.00,0,"14/05/2025",0,0,0,"","BOOKRS",0,"07/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),308,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (308,"05/06/2025","07/06/2025",2,0,0,0,"MARIA LAURA DE GENNARO ","MARIA LAURA DE GENNARO ","","","","","","","",280.00,280.00,0,"22/04/2025",0,0,0,"140 STANDARD","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'18-05-2025',103),308,'31/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (308,"31/05/2025","02/06/2025",2,0,0,0,"ELEONORA NOTARI","ELEONORA NOTARI","","","","","","","",270.00,270.00,0,"25/05/2025",0,0,0,"150","BOOKRS",0,"18/05/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),308,'11/08/2025 - 17/08/2025','INSERT INTO PRENOTAZIONE VALUES (308,"11/08/2025","17/08/2025",2,0,0,0,"ALESSANDRO OLIVA","ALESSANDRO OLIVA","","","","","","","",1140.00,1140.00,0,"20/02/2025",0,0,0,"N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190","BOOKRS",0,"13/02/2025");');

---

TEMPORARY
INSERT INTO TEMPORARY VALUES (101,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (101,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (101,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (101,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (101,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (102,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (102,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (102,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (102,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (102,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'26-06-2025',103),'MS','23/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'26-06-2025',103),'MS','25/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','12/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'26-06-2025',103),'MS','24/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (104,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (104,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (105,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (105,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','23/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','24/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','25/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','26/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','26/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','25/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','23/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','24/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','08/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'04-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','04/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'04-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','23/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','09/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'27-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','29/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'27-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','28/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'27-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','27/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','08/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'08-07-2025',103),CONVERT(datetime,'11-07-2025',103),'AS','09/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','22/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AS','24/08/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AS','23/08/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','21/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','15/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','18/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','19/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','20/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','07/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','12/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'MS','25/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','07/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','08/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','09/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','12/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','29/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','28/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','26/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'MS','24/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'MS','23/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-06-2025',103),CONVERT(datetime,'30-06-2025',103),'AS','27/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'03-06-2025',103),'MS','01/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'03-06-2025',103),'BS','31/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'03-06-2025',103),'MS','02/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),'MS','17/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','16/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','15/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','11/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','16/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'10-08-2025',103),CONVERT(datetime,'11-08-2025',103),'AS','10/08/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'21-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','22/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','12/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','14/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','13/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'21-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','21/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',120,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','27/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','26/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','28/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'MS','04/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'MS','02/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','03/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','04/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'12-08-2025',103),CONVERT(datetime,'16-08-2025',103),'AA','12/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','20/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'MS','03/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'06-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'12-08-2025',103),CONVERT(datetime,'16-08-2025',103),'AA','13/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'12-08-2025',103),CONVERT(datetime,'16-08-2025',103),'AA','14/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'12-08-2025',103),CONVERT(datetime,'16-08-2025',103),'AA','15/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','26/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','07/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','27/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','28/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','07/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','23/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'BS','30/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','04/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','03/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','02/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','01/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'BS','31/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (306,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (306,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','24/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','12/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','25/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','26/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','23/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','13/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','12/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'31-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'10-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','12/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','14/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','15/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','16/08/2025',190,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),'AA','11/08/2025',190,0,0,0,0);

---

Num.Prenotazioni: 91
Num.Disdette: 9

---

18/05/2025 10:17:35
TRASFERIMENTO ESEGUITO.   Tempo: 1 s

---

BookHLB - H.LaBaia. REPORT ANNO 2025.  Incasso	18/05/2025

mese	101	102	103	104	105	106	107	108	201	202	203	204	205	206	207	208	301	302	303	304	305	306	307	308	309	310	Tot
Aprile	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Maggio	770	770	770	280	280	0	240	240	750	770	900	798	368	260	240	240	1510	770	950	1100	336	280	530	530	0	0	13682
Giugno	510	0	1360	0	0	0	0	0	1960	2380	2800	0	720	440	0	0	1540	1710	1190	0	0	0	0	280	0	0	14890
Luglio	0	0	600	0	0	0	680	960	1870	1230	2170	0	1080	0	0	300	2120	200	1400	0	0	0	1290	570	0	0	14470
Agosto	0	0	0	0	0	0	0	0	0	0	1470	0	0	1560	0	0	960	0	0	0	0	0	0	1140	0	0	5130
Settembre	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Ottobre	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
.	1280	770	2730	280	280	0	920	1200	4580	4380	7340	798	2168	2260	240	540	6130	2680	3540	1100	336	280	1820	2520	0	0	48172

Riepilogo Euro

Aprile	0
Maggio	13682
Giugno	14890
Luglio	14470
Agosto	5130
Settembre	0
Ottobre	0

Mese	Stanze	Adulti	Bambini
Aprile	0	0	0
Maggio	36	72	1
Giugno	26	52	2
Luglio	25	50	2
Agosto	4	8	1
Settembre	0	0	0
Ottobre	0	0	0

Riepilogo Presenze       =N.Stanze    =N.Adulti    =N.Bambini

Aprile	0/0/0
Maggio	36/72/1
Giugno	26/52/2
Luglio	25/50/2
Agosto	4/8/1
Settembre	0/0/0
Ottobre	0/0/0

D:\inetpub\webs\bookrsit\1\Report-2025.txt