Trasferimento dati da MS-Access:Labaia.mdb ==> MSSQL:MSSql162519     10/03/2026 11:12:38
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 (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'08-06-2026',103),2,0,0,0,'MARINA D''AMELIA','MARIA D''AMELIA',CONVERT(datetime,'09-03-2026',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'08-06-2026',103),2,0,0,0,'MARINA D''AMELIA','MARINA D''AMELIA',CONVERT(datetime,'09-03-2026',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),2,0,0,0,'GIORGIA GENGHINI','GIORGIA GENGHINI',CONVERT(datetime,'08-03-2026',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),2,0,0,0,'LINO PIRRO','LINO PIRRO',CONVERT(datetime,'02-03-2026',103));
INSERT INTO DISDETTA VALUES (303,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),2,0,0,0,'GIORGIO GHIRELLI','GIORGIO GHIRELLI',CONVERT(datetime,'02-03-2026',103));
INSERT INTO DISDETTA VALUES (103,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),2,0,0,0,'REDI','REDI',CONVERT(datetime,'02-03-2026',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),2,0,0,0,'REDI','REDI',CONVERT(datetime,'02-03-2026',103));
LISTINO
INSERT INTO LISTINO VALUES (160,150,140,130,170,160,140,130,230,220,190,180,240,230,200,190,0,0,0,0,0,CONVERT(datetime,'01-04-2026',103),CONVERT(datetime,'31-05-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'30-06-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'01-07-2026',103),CONVERT(datetime,'04-08-2026',103),CONVERT(datetime,'26-08-2026',103),CONVERT(datetime,'30-09-2026',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'05-08-2026',103),CONVERT(datetime,'25-08-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,220,240,290,290);
INSERT INTO LISTINO VALUES (160,150,140,130,170,160,140,130,230,220,190,180,240,230,200,190,0,0,0,0,0,CONVERT(datetime,'01-04-2026',103),CONVERT(datetime,'31-05-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'30-06-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,CONVERT(datetime,'01-07-2026',103),CONVERT(datetime,'04-08-2026',103),CONVERT(datetime,'26-08-2026',103),CONVERT(datetime,'30-09-2026',103),NULL,NULL,NULL,NULL,CONVERT(datetime,'05-08-2026',103),CONVERT(datetime,'25-08-2026',103),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,220,240,290,290);
PRENOTAZIONE
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'01-05-2026',103),CONVERT(datetime,'03-05-2026',103),2,0,0,0,'‪‪‪‪‪‪‪&','‪‪‪‪‪‪‪&','GIULIA MARCHETTI','-','-','-','-','-','-',300,280,140,CONVERT(datetime,'08-03-2026',103),1,0,0,'140 VERIFICARE BONIFICO','BOOKRS','0',CONVERT(datetime,'08-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (207,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',260,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',260,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'140','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (306,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',300,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'140','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),2,0,0,0,'UMBERTO MIGLIACCIO','UMBERTO MIGLIACCIO','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'05-03-2026',103),0,0,0,'140','BOOKRS','0',CONVERT(datetime,'26-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),2,0,0,0,'IACOVELLI ANTONELLA','IACOVELLI ANTONELLA','-','-','-','-','-','-','-',490,570,190,CONVERT(datetime,'20-01-2026',103),1,0,0,'190 BONIFICO 570 X 3 CAMERE','BOOKRS','0',CONVERT(datetime,'20-01-2026',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),2,0,0,0,'IACOVELLI ANTONELLA','IACOVELLI ANTONELLA','-','-','-','-','-','-','-',490,570,190,CONVERT(datetime,'20-01-2026',103),1,0,0,'190','BOOKRS','0',CONVERT(datetime,'20-01-2026',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),2,0,0,0,'IACOVELI ANTONELLA','IACOVELLI ANTONELLA','-','-','-','-','-','-','-',460,570,190,CONVERT(datetime,'20-01-2026',103),1,0,0,'190','BOOKRS','0',CONVERT(datetime,'20-01-2026',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),2,0,0,0,'MARINA D''AMELIA','MARIA D''AMELIA','-','-','-','-','-','-','-',1360,1260,0,CONVERT(datetime,'16-03-2026',103),0,0,0,'160','BOOKRS','0',CONVERT(datetime,'09-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),2,0,0,0,'MARINA D''AMELIA','MARINA D''AMELIA','-','-','-','-','-','-','-',1360,1360,0,CONVERT(datetime,'16-03-2026',103),0,0,0,'160 1 PERSONA PER OGNI CAMERA','BOOKRS','0',CONVERT(datetime,'09-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),2,0,0,0,'GIORGIA GENGHINI','GIORGIA GENGHINI','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'15-03-2026',103),0,0,0,'170 NIPOTE PROF. PIGNALOSA','BOOKRS','0',CONVERT(datetime,'08-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (204,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),2,0,0,0,'LUDOVICA GARBARINO','LUDOVICA GARBARINO','-','-','-','-','-','-','-',320,320,160,CONVERT(datetime,'24-02-2026',103),1,0,0,'160 BONIFICO OK','BOOKRS','0',CONVERT(datetime,'24-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),2,0,0,0,'GIAN MARCO GARBARINO','GIN MARCO GARBARINO','-','-','-','-','-','-','-',320,320,0,CONVERT(datetime,'28-02-2026',103),0,0,0,'BOOKING CARTA DI CREDITO EURO 320','BOOKRS','0',CONVERT(datetime,'21-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),2,0,0,0,'CHRISTEL HORRAS','CHRISTEL HORRAS','-','-','-','-','-','-','-',1020,960,960,CONVERT(datetime,'25-02-2026',103),1,1,0,'160 VERIFICA BONIFICO','BOOKRS','0',CONVERT(datetime,'25-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),2,0,0,0,'MICCONE','MICCONE',' LE ISOLE D’ITALIA TOUR OPERATOR','-','-','-','-','-','-',960,960,288,CONVERT(datetime,'03-03-2026',103),1,0,0,'160 OKBONIFICO FARE FATTURA','BOOKRS','0',CONVERT(datetime,'24-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),2,0,0,0,'SIMONETTA CERVELLINI','SIMONETTA CERVELLINI','-','-','-','-','-','-','-',650,650,0,CONVERT(datetime,'15-03-2026',103),0,0,0,'130','BOOKRS','0',CONVERT(datetime,'08-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),2,0,0,0,'SIMONETTA CERVELLINI','SIMONETTA CERVELLINI','-','-','-','-','-','-','-',650,650,0,CONVERT(datetime,'15-03-2026',103),0,0,0,'130','BOOKRS','0',CONVERT(datetime,'08-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),2,0,0,0,'VIRGINIE BAEHR','VIRGINIE BAEHR','-','-','-','-','-','-','-',1700,1900,0,CONVERT(datetime,'06-03-2026',103),0,0,1,'BOOKING CARTA DI CREDITO','BOOKRS','0',CONVERT(datetime,'06-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),2,0,0,0,'GIORGIO GHIRELLI','GIORGIO GHIRELLI','-','-','-','-','-','-','-',680,760,0,CONVERT(datetime,'09-03-2026',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'02-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),2,0,0,0,'LINO PIRRO','LINO PIRRO','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'09-02-2026',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'02-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),2,0,0,0,'LINO PIRRO','LINO PIRRO','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'09-02-2026',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'02-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),2,0,0,0,'LINO PIRRO','LINO PIRRO','-','-','-','-','-','-','-',510,510,0,CONVERT(datetime,'09-03-2026',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'02-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),2,0,0,0,'REDI','REDI','-','-','-','-','-','-','-',510,510,170,CONVERT(datetime,'03-03-2026',103),1,0,0,'170 BONIFICO OK EURO 510 X 3 CAMERE FARE FATTURA','BOOKRS','0',CONVERT(datetime,'25-02-2026',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),2,0,0,0,'REDI','REDI','-','-','-','-','-','-','-',510,510,170,CONVERT(datetime,'03-03-2026',103),1,0,0,'170','BOOKRS','0',CONVERT(datetime,'02-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),2,0,0,0,'REDI','REDI','-','-','-','-','-','-','-',510,510,170,CONVERT(datetime,'03-03-2026',103),1,0,0,'170','BOOKRS','0',CONVERT(datetime,'02-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'25-06-2026',103),CONVERT(datetime,'29-06-2026',103),2,0,0,0,'EMANUELA GOZZI','EMANUELA GOZZI','-','-','-','-','-','-','-',680,760,230,CONVERT(datetime,'06-03-2026',103),1,0,0,'190 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'03-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (107,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),2,0,0,0,'CONDELLO','CONDELLO','-','-','-','-','-','-','-',390,390,0,CONVERT(datetime,'16-03-2026',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'09-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (108,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),2,0,0,0,'CONDELLO','CONDELLO','-','-','-','-','-','-','-',390,390,0,CONVERT(datetime,'16-03-2026',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'09-03-2026',103));
INSERT INTO PRENOTAZIONE VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),2,0,0,0,' ANTOINETTE MCTERNAN',' ANTOINETTE MCTERNAN','ANTOINETTE MCTERNAN VISA: 4147 2026 8554 4171','06/29','-','-','-','-','-',1090,1350,0,CONVERT(datetime,'23-01-2026',103),0,0,1,'270 CARTA DI CREDITO ','BOOKRS','0',CONVERT(datetime,'20-01-2026',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'02-07-2026',103),CONVERT(datetime,'05-07-2026',103),2,0,0,0,'GIOVANNI VARZI','GIOVANNI VARZI','-','-','-','-','-','-','-',690,660,220,CONVERT(datetime,'20-01-2026',103),1,0,0,'220','BOOKRS','0',CONVERT(datetime,'20-01-2026',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'12-07-2026',103),CONVERT(datetime,'13-07-2026',103),2,0,0,0,'MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI','MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI','-','-','-','-','-','-','-',230,200,200,CONVERT(datetime,'06-03-2026',103),1,1,0,'200 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'03-03-2026',103));
LOG
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'06-03-2026',103),103,'19/06/2026 - 29/06/2026','INSERT INTO PRENOTAZIONE VALUES (103,"19/06/2026","29/06/2026",2,0,0,0,"VIRGINIE BAEHR","VIRGINIE BAEHR","","","","","","","",1700.00,1700.00,0,"13/03/2026",0,0,0,"BOOKING CARTA DI CREDITO","BOOKRS",0,"06/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'06-03-2026',103),103,'19/06/2026 - 29/06/2026','UPDATE PRENOTAZIONE SET NOME="VIRGINIE BAEHR", COGNOME="VIRGINIE BAEHR", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING CARTA DI CREDITO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1700.00, CONCORDATO=1900.00, ACCONTO=0.00, ENTROIL="06/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="06/03/2026" where num=103 and DAL=#06/19/2026# and AL=#06/29/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'09-03-2026',103),107,'26/06/2026 - 29/06/2026','INSERT INTO PRENOTAZIONE VALUES (107,"26/06/2026","29/06/2026",2,0,0,0,"CONDELLO","CONDELLO","","","","","","","",390.00,390.00,0,"16/03/2026",0,0,0,"150","BOOKRS",0,"09/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'09-03-2026',103),108,'26/06/2026 - 29/06/2026','INSERT INTO PRENOTAZIONE VALUES (108,"26/06/2026","29/06/2026",2,0,0,0,"CONDELLO","CONDELLO","","","","","","","",390.00,390.00,0,"16/03/2026",0,0,0,"150","BOOKRS",0,"09/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),201,'25/06/2026 - 29/06/2026','INSERT INTO PRENOTAZIONE VALUES (201,"25/06/2026","29/06/2026",2,0,0,0,"EMANUELA GOZZI","EMANUELA GOZZI","","","","","","","",680.00,680.00,0,"10/03/2026",0,0,0,"190 ATTESA BONIFICO","BOOKRS",0,"03/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'09-03-2026',103),201,'01/06/2026 - 09/06/2026','UPDATE PRENOTAZIONE SET NOME="MARINA D""AMELIA", COGNOME="MARIA D""AMELIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1360.00, CONCORDATO=1260.00, ACCONTO=0.00, ENTROIL="16/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="09/03/2026" where num=201 and DAL=#06/01/2026# and AL=#06/09/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'09-03-2026',103),201,'01/06/2026 - 09/06/2026','INSERT INTO PRENOTAZIONE VALUES (201,"01/06/2026","09/06/2026",2,0,0,0,"MARINA D""AMELIA","MARIA D""AMELIA","","","","","","","",1360.00,1360.00,0,"16/03/2026",0,0,0,"160","BOOKRS",0,"09/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),201,'22/06/2026 - 25/06/2026','UPDATE PRENOTAZIONE SET NOME="REDI", COGNOME="REDI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 BONIFICO DA VERIFICARE EURO 510 X 3 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=510.00, ACCONTO=170.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="25/02/2026" where num=201 and DAL=#06/22/2026# and AL=#06/25/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),201,'25/06/2026 - 29/06/2026','UPDATE PRENOTAZIONE SET NOME="EMANUELA GOZZI", COGNOME="EMANUELA GOZZI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 VERIFICA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=230.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2026" where num=201 and DAL=#06/25/2026# and AL=#06/29/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),201,'22/06/2026 - 25/06/2026','UPDATE PRENOTAZIONE SET NOME="REDI", COGNOME="REDI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170 BONIFICO OK EURO 510 X 3 CAMERE FARE FATTURA", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=510.00, ACCONTO=170.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="25/02/2026" where num=201 and DAL=#06/22/2026# and AL=#06/25/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),201,'25/06/2026 - 29/06/2026','UPDATE PRENOTAZIONE SET NOME="EMANUELA GOZZI", COGNOME="EMANUELA GOZZI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=0.00, ENTROIL="10/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2026" where num=201 and DAL=#06/25/2026# and AL=#06/29/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'06-03-2026',103),201,'25/06/2026 - 29/06/2026','UPDATE PRENOTAZIONE SET NOME="EMANUELA GOZZI", COGNOME="EMANUELA GOZZI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=230.00, ENTROIL="06/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2026" where num=201 and DAL=#06/25/2026# and AL=#06/29/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-02-2026',103),201,'22/06/2026 - 25/06/2026','INSERT INTO PRENOTAZIONE VALUES (201,"22/06/2026","25/06/2026",2,0,0,0,"REDI","REDI","","","","","","","",510.00,510.00,0,"04/03/2026",0,0,0,"170","BOOKRS",0,"25/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),202,'05/06/2026 - 07/06/2026','INSERT INTO PRENOTAZIONE VALUES (202,"05/06/2026","07/06/2026",2,0,0,0,"GIORGIA GENGHINI","GIORGIA GENGHINI","","","","","","","",340.00,340.00,0,"15/03/2026",0,0,0,"170 NIPOTE PROF. PIGNALOSA","BOOKRS",0,"08/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-03-2026',103),203,'19/06/2026 - 23/06/2026','INSERT INTO PRENOTAZIONE VALUES (203,"19/06/2026","23/06/2026",2,0,0,0,"GIORGIO GHIRELLI","GIORGIO GHIRELLI","","","","","","","",680.00,680.00,0,"09/03/2026",0,0,0,"190","BOOKRS",0,"02/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),203,'02/07/2026 - 05/07/2026','INSERT INTO PRENOTAZIONE VALUES (203,"02/07/2026","05/07/2026",2,0,0,0,"GIOVANNI VARZI","GIOVANNI VARZI","","","","","","","",690.00,690.00,0,"27/01/2026",0,0,0,"220","BOOKRS",0,"20/01/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-03-2026',103),203,'19/06/2026 - 23/06/2026','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="09/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="02/03/2026" where num=203 and DAL=#06/19/2026# and AL=#06/23/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'09-03-2026',103),203,'01/06/2026 - 09/06/2026','INSERT INTO PRENOTAZIONE VALUES (203,"01/06/2026","09/06/2026",2,0,0,0,"MARINA D""AMELIA","MARINA D""AMELIA","","","","","","","",1360.00,1360.00,0,"16/03/2026",0,0,0,"160 1 PERSONA PER OGNI CAMERA","BOOKRS",0,"09/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),203,'12/07/2026 - 13/07/2026','UPDATE PRENOTAZIONE SET NOME="MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI", COGNOME="MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="200 VERIFICARE BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=230.00, CONCORDATO=200.00, ACCONTO=200.00, ENTROIL="03/03/2026", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2026" where num=203 and DAL=#07/12/2026# and AL=#07/13/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'06-03-2026',103),203,'12/07/2026 - 13/07/2026','UPDATE PRENOTAZIONE SET NOME="MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI", COGNOME="MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="200 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=230.00, CONCORDATO=200.00, ACCONTO=200.00, ENTROIL="06/03/2026", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="03/03/2026" where num=203 and DAL=#07/12/2026# and AL=#07/13/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),203,'02/07/2026 - 05/07/2026','UPDATE PRENOTAZIONE SET NOME="GIOVANNI VARZI", COGNOME="GIOVANNI VARZI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220", NB=0, NA=2, MPA=0, MPB=0, TOTALE=690.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="20/01/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=203 and DAL=#07/02/2026# and AL=#07/05/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),203,'12/07/2026 - 13/07/2026','INSERT INTO PRENOTAZIONE VALUES (203,"12/07/2026","13/07/2026",2,0,0,0,"MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI","MADDALENA AFFINITO E EMANUELA POLLASTRINI 2 LETTI","","","","","","","",230.00,230.00,0,"10/03/2026",0,0,0,"200","BOOKRS",0,"03/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-02-2026',103),204,'05/06/2026 - 07/06/2026','INSERT INTO PRENOTAZIONE VALUES (204,"05/06/2026","07/06/2026",2,0,0,0,"LUDOVICA GARBARINO","LUDOVICA GARBARINO","","","","","","","",320.00,320.00,0,"03/03/2026",0,0,0,"160","BOOKRS",0,"24/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-02-2026',103),204,'05/06/2026 - 07/06/2026','UPDATE PRENOTAZIONE SET NOME="LUDOVICA GARBARINO", COGNOME="LUDOVICA GARBARINO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 BONIFICO OK", NB=0, NA=2, MPA=0, MPB=0, TOTALE=320.00, CONCORDATO=320.00, ACCONTO=160.00, ENTROIL="24/02/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/02/2026" where num=204 and DAL=#06/05/2026# and AL=#06/07/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'23-01-2026',103),205,'30/06/2026 - 05/07/2026','UPDATE PRENOTAZIONE SET NOME=" ANTOINETTE MCTERNAN", COGNOME=" ANTOINETTE MCTERNAN", INDIRIZZO="06/29", RAGSOC="ANTOINETTE MCTERNAN VISA: 4147 2026 8554 4171", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="270 CARTA DI CREDITO ", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1090.00, CONCORDATO=1350.00, ACCONTO=0.00, ENTROIL="23/01/2026", PAGATOS=0, PAGATOA=0, PAGATOC=1, EXTRA=0.00, DATAP="20/01/2026" where num=205 and DAL=#06/30/2026# and AL=#07/05/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),205,'30/06/2026 - 05/07/2026','UPDATE PRENOTAZIONE SET NOME=" ANTOINETTE MCTERNAN", COGNOME=" ANTOINETTE MCTERNAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="270", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1090.00, CONCORDATO=1350.00, ACCONTO=0.00, ENTROIL="27/01/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=205 and DAL=#06/30/2026# and AL=#07/05/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),205,'30/06/2026 - 05/07/2026','INSERT INTO PRENOTAZIONE VALUES (205,"30/06/2026","05/07/2026",2,0,0,0," ANTOINETTE MCTERNAN"," ANTOINETTE MCTERNAN","","","","","","","",1090.00,1090.00,0,"27/01/2026",0,0,0,"270","BOOKRS",0,"20/01/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),206,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (206,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",280.00,280.00,0,"05/03/2026",0,0,0,"","BOOKRS",0,"26/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),207,'22/05/2026 - 24/05/2026','UPDATE PRENOTAZIONE SET NOME="UMBERTO MIGLIACCIO", COGNOME="UMBERTO MIGLIACCIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=260.00, CONCORDATO=280.00, ACCONTO=0.00, ENTROIL="05/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="26/02/2026" where num=207 and DAL=#05/22/2026# and AL=#05/24/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),207,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (207,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",260.00,260.00,0,"05/03/2026",0,0,0,"","BOOKRS",0,"26/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),207,'16/06/2026 - 21/06/2026','INSERT INTO PRENOTAZIONE VALUES (207,"16/06/2026","21/06/2026",2,0,0,0,"SIMONETTA CERVELLINI","SIMONETTA CERVELLINI","","","","","","","",650.00,650.00,0,"15/03/2026",0,0,0,"130","BOOKRS",0,"08/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),208,'16/06/2026 - 21/06/2026','INSERT INTO PRENOTAZIONE VALUES (208,"16/06/2026","21/06/2026",2,0,0,0,"SIMONETTA CERVELLINI","SIMONETTA CERVELLINI","","","","","","","",650.00,650.00,0,"15/03/2026",0,0,0,"130","BOOKRS",0,"08/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),208,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (208,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",260.00,260.00,0,"05/03/2026",0,0,0,"140","BOOKRS",0,"26/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),208,'22/05/2026 - 24/05/2026','UPDATE PRENOTAZIONE SET NOME="UMBERTO MIGLIACCIO", COGNOME="UMBERTO MIGLIACCIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="140", NB=0, NA=2, MPA=0, MPB=0, TOTALE=260.00, CONCORDATO=280.00, ACCONTO=0.00, ENTROIL="05/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="26/02/2026" where num=208 and DAL=#05/22/2026# and AL=#05/24/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-03-2026',103),301,'22/06/2026 - 25/06/2026','INSERT INTO PRENOTAZIONE VALUES (301,"22/06/2026","25/06/2026",2,0,0,0,"REDI","REDI","","","","","","","",510.00,510.00,0,"09/03/2026",0,0,0,"170","BOOKRS",0,"02/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),301,'30/05/2026 - 02/06/2026','INSERT INTO PRENOTAZIONE VALUES (301,"30/05/2026","02/06/2026",2,0,0,0,"IACOVELLI ANTONELLA","IACOVELLI ANTONELLA","","","","","","","",490.00,490.00,0,"27/01/2026",0,0,0,"190","BOOKRS",0,"20/01/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),301,'30/05/2026 - 02/06/2026','UPDATE PRENOTAZIONE SET NOME="IACOVELLI ANTONELLA", COGNOME="IACOVELLI ANTONELLA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=490.00, CONCORDATO=570.00, ACCONTO=190.00, ENTROIL="20/01/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=301 and DAL=#05/30/2026# and AL=#06/02/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),301,'30/05/2026 - 02/06/2026','UPDATE PRENOTAZIONE SET NOME="IACOVELLI ANTONELLA", COGNOME="IACOVELLI ANTONELLA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 BONIFICO 570 X 3 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=490.00, CONCORDATO=570.00, ACCONTO=190.00, ENTROIL="20/01/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=301 and DAL=#05/30/2026# and AL=#06/02/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-02-2026',103),301,'19/06/2026 - 22/06/2026','INSERT INTO PRENOTAZIONE VALUES (301,"19/06/2026","22/06/2026",2,0,0,0,"LINO PIRRO","LINO PIRRO","","","","","","","",510.00,510.00,0,"09/02/2026",0,0,0,"190","BOOKRS",0,"02/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-02-2026',103),301,'19/06/2026 - 22/06/2026','UPDATE PRENOTAZIONE SET NOME="LINO PIRRO", COGNOME="LINO PIRRO", 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="09/02/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="02/02/2026" where num=301 and DAL=#06/19/2026# and AL=#06/22/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),301,'22/06/2026 - 25/06/2026','UPDATE PRENOTAZIONE SET NOME="REDI", COGNOME="REDI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=510.00, ACCONTO=170.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="02/03/2026" where num=301 and DAL=#06/22/2026# and AL=#06/25/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-02-2026',103),302,'19/06/2026 - 22/06/2026','UPDATE PRENOTAZIONE SET NOME="LINO PIRRO", COGNOME="LINO PIRRO", 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="09/02/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="02/02/2026" where num=302 and DAL=#06/19/2026# and AL=#06/22/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-02-2026',103),302,'19/06/2026 - 22/06/2026','INSERT INTO PRENOTAZIONE VALUES (302,"19/06/2026","22/06/2026",2,0,0,0,"LINO PIRRO","LINO PIRRO","","","","","","","",510.00,510.00,0,"09/02/2026",0,0,0,"190","BOOKRS",0,"02/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),303,'30/05/2026 - 02/06/2026','UPDATE PRENOTAZIONE SET NOME="IACOVELLI ANTONELLA", COGNOME="IACOVELLI ANTONELLA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=490.00, CONCORDATO=570.00, ACCONTO=190.00, ENTROIL="20/01/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=303 and DAL=#05/30/2026# and AL=#06/02/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-03-2026',103),303,'19/06/2026 - 22/06/2026','INSERT INTO PRENOTAZIONE VALUES (303,"19/06/2026","22/06/2026",2,0,0,0,"LINO PIRRO","LINO PIRRO","","","","","","","",510.00,510.00,0,"09/03/2026",0,0,0,"190","BOOKRS",0,"02/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),303,'30/05/2026 - 02/06/2026','INSERT INTO PRENOTAZIONE VALUES (303,"30/05/2026","02/06/2026",2,0,0,0,"IACOVELLI ANTONELLA","IACOVELLI ANTONELLA","","","","","","","",490.00,490.00,0,"27/01/2026",0,0,0,"190","BOOKRS",0,"20/01/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-02-2026',103),303,'06/06/2026 - 12/06/2026','INSERT INTO PRENOTAZIONE VALUES (303,"06/06/2026","12/06/2026",2,0,0,0,"CHRISTEL HORRAS","CHRISTEL HORRAS","","","","","","","",1020.00,1020.00,0,"04/03/2026",0,0,0,"160 ATTESA CARTA DI CREDITO","BOOKRS",0,"25/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'25-02-2026',103),303,'06/06/2026 - 12/06/2026','UPDATE PRENOTAZIONE SET NOME="CHRISTEL HORRAS", COGNOME="CHRISTEL HORRAS", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 VERIFICA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1020.00, CONCORDATO=960.00, ACCONTO=960.00, ENTROIL="25/02/2026", PAGATOS=1, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="25/02/2026" where num=303 and DAL=#06/06/2026# and AL=#06/12/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'02-03-2026',103),303,'22/06/2026 - 25/06/2026','INSERT INTO PRENOTAZIONE VALUES (303,"22/06/2026","25/06/2026",2,0,0,0,"REDI","REDI","","","","","","","",510.00,510.00,0,"09/03/2026",0,0,0,"170","BOOKRS",0,"02/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),303,'22/06/2026 - 25/06/2026','UPDATE PRENOTAZIONE SET NOME="REDI", COGNOME="REDI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="170", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=510.00, ACCONTO=170.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="02/03/2026" where num=303 and DAL=#06/22/2026# and AL=#06/25/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),304,'30/05/2026 - 02/06/2026','INSERT INTO PRENOTAZIONE VALUES (304,"30/05/2026","02/06/2026",2,0,0,0,"IACOVELI ANTONELLA","IACOVELLI ANTONELLA","","","","","","","",460.00,460.00,0,"27/01/2026",0,0,0,"190","BOOKRS",0,"20/01/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),304,'01/05/2026 - 03/05/2026','UPDATE PRENOTAZIONE SET NOME="‪‪‪‪‪‪‪&", COGNOME="‪‪‪‪‪‪‪&", INDIRIZZO="", RAGSOC="GIULIA MARCHETTI", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="140 VERIFICARE BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=280.00, ACCONTO=140.00, ENTROIL="08/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="08/03/2026" where num=304 and DAL=#05/01/2026# and AL=#05/03/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),304,'01/05/2026 - 03/05/2026','UPDATE PRENOTAZIONE SET NOME="‪‪‪‪‪‪‪‪‪‪‪‪‪‪GIULIA MARCHETTI‬‬‬‬‬‬‬‬‬‬‬‬‬‬", COGNOME="‪‪‪‪‪‪‪‪‪‪‪‪‪‪GIULIA MARCHETTI‬‬‬‬‬‬‬‬‬‬‬‬‬‬", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="140 VERIFICARE BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=280.00, ACCONTO=140.00, ENTROIL="08/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="08/03/2026" where num=304 and DAL=#05/01/2026# and AL=#05/03/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'21-02-2026',103),304,'05/06/2026 - 07/06/2026','INSERT INTO PRENOTAZIONE VALUES (304,"05/06/2026","07/06/2026",2,0,0,0,"GIAN MARCO GARBARINO","GIN MARCO GARBARINO","","","","","","","",320.00,320.00,0,"28/02/2026",0,0,0,"BOOKING CARTA DI CREDITO","BOOKRS",0,"21/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'20-01-2026',103),304,'30/05/2026 - 02/06/2026','UPDATE PRENOTAZIONE SET NOME="IACOVELI ANTONELLA", COGNOME="IACOVELLI ANTONELLA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=460.00, CONCORDATO=570.00, ACCONTO=190.00, ENTROIL="20/01/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="20/01/2026" where num=304 and DAL=#05/30/2026# and AL=#06/02/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-03-2026',103),304,'01/05/2026 - 03/05/2026','INSERT INTO PRENOTAZIONE VALUES (304,"01/05/2026","03/05/2026",2,0,0,0,"‪‪‪‪‪‪‪‪‪‪‪‪‪‪GIULIA MARCHETTI‬‬‬‬‬‬‬‬‬‬‬‬‬‬","‪‪‪‪‪‪‪‪‪‪‪‪‪‪GIULIA MARCHETTI‬‬‬‬‬‬‬‬‬‬‬‬‬‬","","","","","","","",300.00,300.00,0,"15/03/2026",0,0,0,"140","BOOKRS",0,"08/03/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'03-03-2026',103),304,'13/06/2026 - 19/06/2026','UPDATE PRENOTAZIONE SET NOME="MICCONE", COGNOME="MICCONE", INDIRIZZO="", RAGSOC=" LE ISOLE D’ITALIA TOUR OPERATOR", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160 OKBONIFICO FARE FATTURA", NB=0, NA=2, MPA=0, MPB=0, TOTALE=960.00, CONCORDATO=960.00, ACCONTO=288.00, ENTROIL="03/03/2026", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/02/2026" where num=304 and DAL=#06/13/2026# and AL=#06/19/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'21-02-2026',103),304,'05/06/2026 - 07/06/2026','UPDATE PRENOTAZIONE SET NOME="GIAN MARCO GARBARINO", COGNOME="GIN MARCO GARBARINO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING CARTA DI CREDITO EURO 320", NB=0, NA=2, MPA=0, MPB=0, TOTALE=320.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="28/02/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="21/02/2026" where num=304 and DAL=#06/05/2026# and AL=#06/07/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-02-2026',103),304,'13/06/2026 - 19/06/2026','INSERT INTO PRENOTAZIONE VALUES (304,"13/06/2026","19/06/2026",2,0,0,0,"MICCONE","MICCONE"," LE ISOLE D’ITALIA TOUR OPERATOR","","","","","","",960.00,960.00,0,"03/03/2026",0,0,0,"160","BOOKRS",0,"24/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),306,'22/05/2026 - 24/05/2026','UPDATE PRENOTAZIONE SET NOME="UMBERTO MIGLIACCIO", COGNOME="UMBERTO MIGLIACCIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="140", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=280.00, ACCONTO=0.00, ENTROIL="05/03/2026", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="26/02/2026" where num=306 and DAL=#05/22/2026# and AL=#05/24/2026#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),306,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (306,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",300.00,300.00,0,"05/03/2026",0,0,0,"","BOOKRS",0,"26/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),307,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (307,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",280.00,280.00,0,"05/03/2026",0,0,0,"","BOOKRS",0,"26/02/2026");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'26-02-2026',103),308,'22/05/2026 - 24/05/2026','INSERT INTO PRENOTAZIONE VALUES (308,"22/05/2026","24/05/2026",2,0,0,0,"UMBERTO MIGLIACCIO","UMBERTO MIGLIACCIO","","","","","","","",280.00,280.00,0,"05/03/2026",0,0,0,"140","BOOKRS",0,"26/02/2026");');
TEMPORARY
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','23/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','28/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','26/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','27/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','24/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','22/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','21/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','20/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','19/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','25/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','28/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','26/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','27/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','28/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','27/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'26-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','26/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','22/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'25-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','25/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'25-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','26/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','23/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'25-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','27/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','24/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'25-06-2026',103),CONVERT(datetime,'29-06-2026',103),'MS','28/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','02/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','03/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','04/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','05/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','06/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','07/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','08/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','01/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','06/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','05/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'02-07-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','04/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','07/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','06/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','05/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','04/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','03/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','02/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'02-07-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','02/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'02-07-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','03/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),'MS','20/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-07-2026',103),CONVERT(datetime,'13-07-2026',103),'AS','12/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),'MS','22/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','08/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),'MS','19/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'23-06-2026',103),'MS','21/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'01-06-2026',103),CONVERT(datetime,'09-06-2026',103),'MS','01/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','05/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (204,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','06/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','03/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','02/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','01/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),'MS','30/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'30-06-2026',103),CONVERT(datetime,'05-07-2026',103),'AS','04/07/2026',230,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (206,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','17/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','18/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','16/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','19/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','20/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','18/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','17/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','19/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','20/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'16-06-2026',103),CONVERT(datetime,'21-06-2026',103),'MS','16/06/2026',130,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','21/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','20/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','22/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','24/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','23/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'MS','01/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','31/05/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','30/05/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','19/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','19/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','20/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','21/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','31/05/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','06/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','30/05/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','09/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'MS','01/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','23/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','07/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','22/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','19/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'22-06-2026',103),CONVERT(datetime,'25-06-2026',103),'MS','24/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','21/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2026',103),CONVERT(datetime,'22-06-2026',103),'MS','20/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','11/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','10/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-06-2026',103),CONVERT(datetime,'12-06-2026',103),'MS','08/06/2026',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','31/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'MS','01/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','18/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','17/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','16/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2026',103),CONVERT(datetime,'02-06-2026',103),'BS','30/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','15/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','13/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'01-05-2026',103),CONVERT(datetime,'03-05-2026',103),'BS','01/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'01-05-2026',103),CONVERT(datetime,'03-05-2026',103),'BS','02/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','05/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'05-06-2026',103),CONVERT(datetime,'07-06-2026',103),'MS','06/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'13-06-2026',103),CONVERT(datetime,'19-06-2026',103),'MS','14/06/2026',160,0,0,0,0);
INSERT INTO TEMPORARY VALUES (306,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (306,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (307,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','23/05/2026',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'22-05-2026',103),CONVERT(datetime,'24-05-2026',103),'BS','22/05/2026',140,0,0,0,0);
Num.Prenotazioni: 33
Num.Disdette: 7
10/03/2026 11:12:38
TRASFERIMENTO ESEGUITO.   Tempo: 0 s




BookHLB.it
BookHLB - H.LaBaia. REPORT ANNO 2026.  Incasso    10/03/2026
mese101102103104105106107108 201202203204205206207208 301302303304305306307308 309310Tot
Aprile000000000000000000000000000
Maggio000000000000028028028057005708500280280280003670
Giugno001900000390390253034021203201350065065010805701980128000000015550
Luglio0000000000860000000000000000860
Agosto000000000000000000000000000
Settembre000000000000000000000000000
Ottobre000000000000000000000000000
.00190000039039025303402980320135028093093016505702550213002802802800020080

Riepilogo Euro
Aprile0
Maggio 3670
Giugno 15550
Luglio 860
Agosto 0
Settembre0
Ottobre 0



MeseStanzeAdultiBambini
Aprile000
Maggio10200
Giugno21420
Luglio240
Agosto000
Settembre000
Ottobre000


Riepilogo Presenze       =N.Stanze    =N.Adulti    =N.Bambini
Aprile0/0/0

Maggio10/20/0

Giugno21/42/0

Luglio2/4/0

Agosto0/0/0

Settembre0/0/0

Ottobre0/0/0

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