Trasferimento dati da MS-Access:Labaia.mdb ==> MSSQL:MSSql162519
24/03/2025 18:28:18
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 (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 (103,CONVERT(datetime,'20-04-2025',103),CONVERT(datetime,'22-04-2025',103),2,0,0,0,'GIUSEPPE LIMONE','GIUSEPPE LIMONE','-','-','-','-','-','-','-',300,315,0,CONVERT(datetime,'31-03-2025',103),0,0,0,'BOOKING DA PRELEVARE','BOOKRS','0',CONVERT(datetime,'24-03-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,'SANDRO CEREA','SANDRO 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,'SANDRO CEREA','SANDRO CEREA','-','-','-','-','-','-','-',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 (207,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'GUIDO COEN ','GUIDO COEN ','-','-','-','-','-','-','-',240,240,120,CONVERT(datetime,'13-03-2025',103),1,0,0,'120 GRUPPO ANIENI','BOOKRS','0',CONVERT(datetime,'13-03-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,'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 (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,'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 (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),2,0,0,0,'MIEDICO ANTONIO','MIEDICO ANTONIO','-','-','-','-','-','-','-',680,600,0,CONVERT(datetime,'31-03-2025',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'24-03-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 (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,540,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 (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,540,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 (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 (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 (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),2,0,0,0,'RAFFAELE TARTAGLIONE','RAFFAELE TARTAGLIONE','-','-','-','-','-','-','-',600,600,0,CONVERT(datetime,'14-03-2025',103),0,0,0,'CAMERA SUPERIOR 210 ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'07-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'06-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','-',200,190,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 (202,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,190,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 (203,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'CARLA MARONI DE STEFANO','CARLA MARONI DE STEFANO','-','-','-','-','-','3398522244','-',200,190,190,CONVERT(datetime,'13-03-2025',103),1,1,0,'190 GRUPPO PROSPERI OK BONIFICO','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'MARCO MARRANA','MARCO MARRANA','-','-','-','-','-','-','-',150,162,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 (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,190,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,190,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 (201,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'09-07-2025',103),2,0,0,0,'MONTELLA AMICO CESARO','MONTELLA AMICI CESARO','-','-','-','-','-','-','-',400,400,0,CONVERT(datetime,'20-03-2025',103),0,0,0,'210','BOOKRS','0',CONVERT(datetime,'13-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,1200,0,CONVERT(datetime,'06-03-2025',103),0,0,0,'','BOOKRS','0',CONVERT(datetime,'27-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,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,'19-03-2025',103),1,0,0,'210 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'15-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,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 (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 (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 (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,'24-03-2025',103),103,'20/04/2025 - 22/04/2025','INSERT INTO PRENOTAZIONE VALUES (103,"20/04/2025","22/04/2025",2,0,0,0,"GIUSEPPE LIMONE","GIUSEPPE LIMONE","","","","","","","",300.00,300.00,0,"31/03/2025",0,0,0,"BOOKING DA PRELEVARE","BOOKRS",0,"24/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),103,'20/04/2025 - 22/04/2025','UPDATE PRENOTAZIONE SET NOME="GIUSEPPE LIMONE", COGNOME="GIUSEPPE LIMONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="BOOKING DA PRELEVARE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=315.00, ACCONTO=0.00, ENTROIL="31/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=103 and DAL=#04/20/2025# and AL=#04/22/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),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,'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,'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,'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,'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,'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,'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,'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,'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,'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),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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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','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,'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,'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','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,'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-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,'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,'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,'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,'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,'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','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,'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,'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,'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="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,'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 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,'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-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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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),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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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,'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','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,'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,'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 (103,CONVERT(datetime,'20-04-2025',103),CONVERT(datetime,'22-04-2025',103),'BS','20/04/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (103,CONVERT(datetime,'20-04-2025',103),CONVERT(datetime,'22-04-2025',103),'BS','21/04/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 (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','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','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','25/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','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-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','26/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'09-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','12/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-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,'21-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'09-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'09-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'09-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','09/07/2025',200,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,'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,'07-07-2025',103),CONVERT(datetime,'09-07-2025',103),'AS','07/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'09-07-2025',103),'AS','08/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 (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,'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,'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,'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,'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,'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,'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-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-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','20/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','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),'AS','24/08/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,'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,'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,'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,'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,'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','22/08/2025',240,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,'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,'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,'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,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','19/08/2025',240,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,'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','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','19/07/2025',200,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','17/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 (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','12/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,'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,'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,'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','16/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 (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 (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 (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 (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 (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,'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,'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,'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','27/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,'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,'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','21/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,'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,'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,'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,'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,'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,'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,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,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),'BS','30/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','31/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','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','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','01/06/2025',150,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-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,'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 (308,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 (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','13/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);
Num.Prenotazioni: 35
Num.Disdette: 2
24/03/2025 18:28:23
TRASFERIMENTO ESEGUITO. Tempo: 5 s
BookHLB.it
| BookHLB - H.LaBaia. REPORT ANNO 2025. Incasso |
24/03/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 | 315 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 315 |
| Maggio | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 300 | 300 | 0 | 0 | 0 | 240 | 0 | 320 | 320 | 320 | 800 | 0 | 0 | 0 | 0 | 0 | 0 | 2900 |
| Giugno | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 540 | 0 | 1140 | 0 | 720 | 440 | 0 | 0 | 1170 | 570 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4580 |
| Luglio | 0 | 0 | 0 | 0 | 0 | 0 | 680 | 960 | 1390 | 790 | 1390 | 0 | 1080 | 0 | 0 | 162 | 190 | 190 | 200 | 0 | 0 | 0 | 720 | 0 | 0 | 0 | 7752 |
| Agosto | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1470 | 0 | 0 | 1560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1140 | 0 | 0 | 4170 |
| 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 |
| . | 0 | 0 | 315 | 0 | 0 | 0 | 680 | 960 | 2230 | 1090 | 4300 | 0 | 1800 | 2000 | 240 | 162 | 1680 | 1080 | 520 | 800 | 0 | 0 | 720 | 1140 | 0 | 0 | 19717 |
Riepilogo Euro
| Aprile | 315 |  |
| Maggio | 2900 | |
| Giugno | 4580 | |
| Luglio | 7752 | |
| Agosto | 4170 | |
| Settembre | 0 | |
| Ottobre | 0 | |
| Mese | Stanze | Adulti | Bambini |
|---|
| Aprile | 1 | 2 | 0 |
| Maggio | 8 | 16 | 0 |
| Giugno | 8 | 16 | 2 |
| Luglio | 15 | 30 | 2 |
| Agosto | 3 | 6 | 1 |
| Settembre | 0 | 0 | 0 |
| Ottobre | 0 | 0 | 0 |
Riepilogo Presenze =N.Stanze
=N.Adulti
=N.Bambini
| Aprile | 1/2/0 |
|
| Maggio | 8/16/0 |
|
| Giugno | 8/16/2 |
|
| Luglio | 15/30/2 |
|
| Agosto | 3/6/1 |
|
| Settembre | 0/0/0 |
|
| Ottobre | 0/0/0 |
|
D:\inetpub\webs\bookrsit\1\Report-2025.txt