BookHLB.it

Trasferimento dati da MS-Access:Labaia.mdb ==> MSSQL:MSSql162519 17/04/2025 21:01:13

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

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

DISDETTA
INSERT INTO DISDETTA VALUES (103,CONVERT(datetime,'20-04-2025',103),CONVERT(datetime,'22-04-2025',103),2,0,0,0,'GIUSEPPE LIMONE','GIUSEPPE LIMONE',CONVERT(datetime,'08-04-2025',103));
INSERT INTO DISDETTA VALUES (202,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'ELSA E MASSIMO','ELSA E MASSIMO',CONVERT(datetime,'08-04-2025',103));
INSERT INTO DISDETTA VALUES (203,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'CARLA MARONI DE STEF','CARLA MARONI DE STEFANO',CONVERT(datetime,'12-04-2025',103));
INSERT INTO DISDETTA VALUES (301,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'GRAZIELLA BERNASCONI','GRAZIELLA BERNASCONI',CONVERT(datetime,'15-03-2025',103));
INSERT INTO DISDETTA VALUES (302,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'11-07-2025',103),2,0,0,0,'GRAZIELLA BERNASCONI','GRAZIELLA BERNASCONI',CONVERT(datetime,'15-03-2025',103));

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

PRENOTAZIONE
INSERT INTO PRENOTAZIONE VALUES (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 (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',300,368,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'184','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (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,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',280,300,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'150','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),2,0,0,0,'PAOLO TAMIETTI','PAOLO TAMIETTI','-','-','-','-','-','-','-',280,336,0,CONVERT(datetime,'14-04-2025',103),0,0,0,'168','BOOKRS','0',CONVERT(datetime,'07-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),2,1,0,0,'CORRADO ANDREAN','CORRADO ANDREAN','-','-','-','-','-',' (+39) 348 0705494','-',470,630,210,CONVERT(datetime,'17-04-2025',103),1,0,0,'210 CAMERA VISTA MARE CON BALCONE','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),2,0,0,0,'RAFFAELE BASSI','RAFFAELE BASSI','-','-','-','-','-','-','-',880,800,240,CONVERT(datetime,'19-03-2025',103),1,0,0,'800 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'15-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'LINDA STEFANETTI','LINDA STEFANETTI','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'22-04-2025',103),0,0,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'FRANCESCO PALMEGGIANI','FRANCESCO PALMEGGIANI','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'22-04-2025',103),0,0,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'LUIGI CERONI','LUIGI CERONI','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'22-04-2025',103),0,0,0,'170','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),2,0,0,0,'MARIA LAURA DE GENNARO ','MARIA LAURA DE GENNARO ','-','-','-','-','-','-','-',280,280,0,CONVERT(datetime,'22-04-2025',103),0,0,0,'140 STANDARD','BOOKRS','0',CONVERT(datetime,'15-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),2,0,0,0,'ANNALISA ALCESTE','ANNALISA ALCESTE','-','-','-','-','-','-','-',340,320,0,CONVERT(datetime,'12-04-2025',103),0,0,0,'160','BOOKRS','0',CONVERT(datetime,'05-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),2,0,0,0,'MIEDICO ANTONIO','MIEDICO ANTONIO','-','-','-','-','-','-','-',680,600,180,CONVERT(datetime,'25-03-2025',103),1,0,0,'150','BOOKRS','0',CONVERT(datetime,'24-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,'EDOARDO STANISCIA','EDOARDO STANISCIA','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'NON HO DETTO IL PREZZO','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),2,0,0,0,'EDOARDO STANISCIA','EDOARDO STANISCIA','-','-','-','-','-','-','-',340,340,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'NONN HO DETTO IL PREZZO','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),2,1,0,0,'FRANCESCO ROMANI','FRANCESCO ROMANI','-','-','-','-','-','-','-',510,720,240,CONVERT(datetime,'24-03-2025',103),1,0,0,'240 TRIPLA CON TERRAZZA','BOOKRS','0',CONVERT(datetime,'24-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (101,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,510,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (103,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,510,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'ELSA E MASSIMO','ELSA E MASSIMO','-','-','-','-','-','-','-',510,540,0,CONVERT(datetime,'11-04-2025',103),0,0,0,'180','BOOKRS','0',CONVERT(datetime,'04-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PIRRO/FABENI ','PIRRO/FABENI ','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PORTANOVA/PICHILLI','PORTANOVA/PICHILLI','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),2,0,0,0,'GIORGIO GHIRELLI','GIORGIO GHIRELLI','-','-','-','-','-','-','-',680,680,0,CONVERT(datetime,'12-04-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'05-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'21-06-2025',103),CONVERT(datetime,'23-06-2025',103),2,1,0,0,'MARCO DOMINICI','MARCO DOMINICI','-','-','-','-','-','-','-',280,440,0,CONVERT(datetime,'01-03-2025',103),0,0,0,'220 TRIPLA ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'22-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),2,0,0,0,'RAFFAELE TARTAGLIONE','RAFFAELE TARTAGLIONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'CAMERA SUPERIOR 210 ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'07-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),2,0,0,0,'RAFFAELE TARTAGLIONEAMICI','IODICE PASQUALE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'04-04-2025',103),1,0,0,'210 ATTESA BONIFICO','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),2,0,0,0,'ANDREA GIOVAGNOLI','ANDREA GIOVAGNOLI','-','-','-','-','-','-','-',600,660,220,CONVERT(datetime,'15-04-2025',103),1,0,0,'220 SUPERIOR OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'VALERIA COSENTINO ALESI','VALERIA COSENTINO ALESI','VISA N. 4025 4724 6457 1599 SCAD 06/26','-','-','-','-','3355975763','-',400,400,0,CONVERT(datetime,'11-03-2025',103),0,0,1,'190 GRUPPO PROSPERI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'MARCO MARRANA','MARCO MARRANA','-','-','-','-','-','-','-',300,300,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'BOOKING 162 DA PRELEVARE','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'MARCO VISCOGLIOSI','MARCO VISCOGLIOSI','INTESA SAN PAOLO N. 4471 4931 0432 4958 SCAD. 12/2','-','-','-','-','3930692400','-',200,200,0,CONVERT(datetime,'11-03-2025',103),0,0,1,'190 GRUPPO PROSPERI','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'RIZZA STEFANO E FEDERICA','RIZZA STEFANO E FEDERICA','AMERICAN EXPRESS: N 375288071412009 SCADENZA12/25.','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'12-03-2025',103),0,0,1,'190','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'ENZA BURATO E CIRO TAMBURELLA','ENZA BURATO E CIRO TAMBURELLA','-','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),2,0,0,0,'PROSPERO DANIELA E CRISTINA COSTANZO','PROSPERO DANIELA E CRISTINA COSTANZO','GRUPPO PROSPERO','-','-','-','-','-','-',200,200,0,CONVERT(datetime,'18-03-2025',103),0,0,0,'190','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (201,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'09-07-2025',103),2,0,0,0,'MONTELLA AMICO CESARO','MONTELLA AMICI CESARO','-','-','-','-','-','-','-',400,420,210,CONVERT(datetime,'04-04-2025',103),1,0,0,'210 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),2,0,0,0,'NOTAIO CERASO','NOTAIO CERASO','-','-','-','-','-','-','-',1200,1140,450,CONVERT(datetime,'04-04-2025',103),1,0,0,'190','BOOKRS','0',CONVERT(datetime,'27-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (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,840,252,CONVERT(datetime,'04-04-2025',103),1,0,0,'210 OK BONIFICO','BOOKRS','0',CONVERT(datetime,'15-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (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 (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210 BONIFICO 630 X 3 CAMERE','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),2,0,0,0,'GIAMPIERO FORMICONE','GIAMPIERO FORMICONE','-','-','-','-','-','-','-',600,630,210,CONVERT(datetime,'01-04-2025',103),1,0,0,'210','BOOKRS','0',CONVERT(datetime,'01-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),2,0,0,0,'ELENA PETRALIA ','ELENA PETRALIA','-','-','-','-','-','-','-',600,660,220,CONVERT(datetime,'15-04-2025',103),1,0,0,'220 SUPERIOR OK BONIFICO','BOOKRS','0',CONVERT(datetime,'13-04-2025',103));
INSERT INTO PRENOTAZIONE VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,0,0,0,'VALENTINA BRIZIARELLI','VALENTINA BRIZIARELLI','ELEONORA NALDINI (MIA FIGLIA) E NINA DE PASQUALE','-','-','-','-','-','-',600,680,204,CONVERT(datetime,'12-03-2025',103),1,0,0,'170 CAMERA ECONOMY VERIFICARE ACCONTO','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,1,0,0,'VALENTINA BRIZIARELLI','VALENTINA BRIZIARELLI','ELEONORA D�OSTUNI, VALERIA BRANDOLO E AGATA ARCUDI','-','-','-','-','-','-',600,960,288,CONVERT(datetime,'13-03-2025',103),1,0,0,'240 CAMERA TRIPLA ECONOMY','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (307,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),2,0,0,0,'GIORGIA BARBARULO','GIORGIA BARBARULO','CODICE FISCALE BRBGRG72R44F839V','ROMA 00161 VIA PADOVA 53','-','-','-','3200132390','-',680,720,216,CONVERT(datetime,'13-03-2025',103),1,0,0,'180 CAMERA STANDARD 3 PIANO','BOOKRS','0',CONVERT(datetime,'11-03-2025',103));
INSERT INTO PRENOTAZIONE VALUES (206,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),2,1,0,0,'ALESSANDRO OLIVA','ALESSANDRO OLIVA','EFFETTUATO BONIFICO DI EURO 810 X LE DUE CAMERE','-','-','-','-','-','-',1140,1560,700,CONVERT(datetime,'16-02-2025',103),1,0,0,'N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190','BOOKRS','0',CONVERT(datetime,'13-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (308,CONVERT(datetime,'11-08-2025',103),CONVERT(datetime,'17-08-2025',103),2,0,0,0,'ALESSANDRO OLIVA','ALESSANDRO OLIVA','-','-','-','-','-','-','-',1140,1140,110,CONVERT(datetime,'16-02-2025',103),1,0,0,'N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190','BOOKRS','0',CONVERT(datetime,'13-02-2025',103));
INSERT INTO PRENOTAZIONE VALUES (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,'04-04-2025',103),103,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (103,"19/06/2025","22/06/2025",2,0,0,0,"ELSA E MASSIMO","ELSA E MASSIMO","","","","","","","",510.00,510.00,0,"11/04/2025",0,0,0,"180","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),103,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=103, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=103 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'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,'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,'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','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,'10-04-2025',103),201,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=201, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=201 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),201,'09/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="GIUSEPPE MURENA", COGNOME="GIUSEPPE MURENA", INDIRIZZO="", RAGSOC="AMICO CESARO", CAP="", CITTA="", PROV="", TEL="3487081901", EMAIL="", NOTEP="210 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=800.00, CONCORDATO=840.00, ACCONTO=252.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/03/2025" where num=201 and DAL=#07/09/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),201,'07/07/2025 - 09/07/2025','UPDATE PRENOTAZIONE SET NOME="MONTELLA AMICO CESARO", COGNOME="MONTELLA AMICI CESARO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=400.00, CONCORDATO=420.00, ACCONTO=210.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/03/2025" where num=201 and DAL=#07/07/2025# and AL=#07/09/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'08-04-2025',103),201,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="ELSA E MASSIMO", COGNOME="ELSA E MASSIMO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="180", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=540.00, ACCONTO=0.00, ENTROIL="11/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="04/04/2025" where num=201 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),201,'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,'04-04-2025',103),201,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (201,"13/06/2025","15/06/2025",2,0,0,0,"EDOARDO STANISCIA","EDOARDO STANISCIA","","","","","","","",340.00,340.00,0,"11/04/2025",0,0,0,"NON HO DETTO IL PREZZO","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'01-04-2025',103),201,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 BONIFICO 630 X 3 CAMERE", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=201 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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','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,'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,'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,'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','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,'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="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,'15-03-2025',103),201,'09/07/2025 - 13/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"09/07/2025","13/07/2025",2,0,0,0,"GIUSEPPE MURENA","GIUSEPPE MURENA","AMICO CESARO","","","","","3487081901","",800.00,800.00,0,"22/03/2025",0,0,0,"210","BOOKRS",0,"15/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-03-2025',103),201,'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,'01-04-2025',103),201,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (201,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),202,'13/06/2025 - 15/06/2025','INSERT INTO PRENOTAZIONE VALUES (202,"13/06/2025","15/06/2025",2,0,0,0,"EDOARDO STANISCIA","EDOARDO STANISCIA","","","","","","","",340.00,340.00,0,"11/04/2025",0,0,0,"NONN HO DETTO IL PREZZO","BOOKRS",0,"04/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'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,'01-04-2025',103),202,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (202,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),202,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=202 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'10-04-2025',103),202,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=202, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=202 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="MARCO VISCOGLIOSI", COGNOME="MARCO VISCOGLIOSI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="3930692400", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=202 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),202,'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,'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,'01-04-2025',103),203,'17/07/2025 - 20/07/2025','UPDATE PRENOTAZIONE SET NOME="GIAMPIERO FORMICONE", COGNOME="GIAMPIERO FORMICONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=203 and DAL=#07/17/2025# and AL=#07/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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="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,'25-03-2025',103),203,'12/06/2025 - 16/06/2025','UPDATE PRENOTAZIONE SET NOME="MIEDICO ANTONIO", COGNOME="MIEDICO ANTONIO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=600.00, ACCONTO=180.00, ENTROIL="25/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=203 and DAL=#06/12/2025# and AL=#06/16/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'01-04-2025',103),203,'17/07/2025 - 20/07/2025','INSERT INTO PRENOTAZIONE VALUES (203,"17/07/2025","20/07/2025",2,0,0,0,"GIAMPIERO FORMICONE","GIAMPIERO FORMICONE","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=450.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=450.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),203,'06/06/2025 - 08/06/2025','UPDATE PRENOTAZIONE SET NOME="ANNALISA ALCESTE", COGNOME="ANNALISA ALCESTE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="160", NB=0, NA=2, MPA=0, MPB=0, TOTALE=340.00, CONCORDATO=320.00, ACCONTO=0.00, ENTROIL="12/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/04/2025" where num=203 and DAL=#06/06/2025# and AL=#06/08/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'21-01-2025',103),203,'18/08/2025 - 25/08/2025','UPDATE PRENOTAZIONE SET NOME="DONATELLA PAI", COGNOME="DONATELLA PAI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1600.00, CONCORDATO=1470.00, ACCONTO=0.00, ENTROIL="28/01/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="21/01/2025" where num=203 and DAL=#08/18/2025# and AL=#08/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (203,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"150 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),203,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NOME="CARLA MARONI DE STEFANO", COGNOME="CARLA MARONI DE STEFANO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 GRUPPO PROSPERI", NB=0, NA=2, MPA=0, MPB=0, TOTALE=200.00, CONCORDATO=190.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=203 and DAL=#07/06/2025# and AL=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'04-04-2025',103),203,'07/07/2025 - 13/07/2025','UPDATE PRENOTAZIONE SET NOME="NOTAIO CERASO", COGNOME="NOTAIO CERASO", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="", NB=0, NA=2, MPA=0, MPB=0, TOTALE=1200.00, CONCORDATO=1140.00, ACCONTO=0.00, ENTROIL="06/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/02/2025" where num=203 and DAL=#07/07/2025# and AL=#07/13/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),203,'06/06/2025 - 08/06/2025','INSERT INTO PRENOTAZIONE VALUES (203,"06/06/2025","08/06/2025",2,0,0,0,"ANNALISA ALCESTE","ANNALISA ALCESTE","","","","","","","",340.00,340.00,0,"12/04/2025",0,0,0,"160","BOOKRS",0,"05/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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','INSERT INTO PRENOTAZIONE VALUES (205,"16/07/2025","20/07/2025",2,1,0,0,"EMANUELA GEROSA","EMANUELA GEROSA","","","","","","","",800.00,800.00,0,"10/03/2025",0,0,0,"270","BOOKRS",0,"03/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'24-03-2025',103),205,'17/06/2025 - 20/06/2025','UPDATE PRENOTAZIONE SET NOME="FRANCESCO ROMANI", COGNOME="FRANCESCO ROMANI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="240 TRIPLA CON TERRAZZA", NB=1, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=720.00, ACCONTO=240.00, ENTROIL="24/03/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="24/03/2025" where num=205 and DAL=#06/17/2025# and AL=#06/20/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'07-04-2025',103),205,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="184", NB=0, NA=2, MPA=0, MPB=0, TOTALE=300.00, CONCORDATO=368.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=205 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),205,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (205,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",300.00,300.00,0,"14/04/2025",0,0,0,"184","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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 NOME="ALESSANDRO OLIVA", COGNOME="ALESSANDRO OLIVA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190", NB=1, NA=2, MPA=0, MPB=0, TOTALE=1140.00, CONCORDATO=1560.00, ACCONTO=0.00, ENTROIL="20/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="13/02/2025" where num=206 and DAL=#08/11/2025# and AL=#08/17/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),206,'11/08/2025 - 17/08/2025','UPDATE PRENOTAZIONE SET NUM=206, DAL=#08/11/2025#, AL=#08/17/2025#, TOTALE=1140.00, CONCORDATO=1140.00 WHERE NUM=206 AND dal=#08/10/2025# and al=#08/11/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-02-2025',103),206,'10/08/2025 - 11/08/2025','INSERT INTO PRENOTAZIONE VALUES (206,"10/08/2025","11/08/2025",2,1,0,0,"ALESSANDRO OLIVA","ALESSANDRO OLIVA","","","","","","","",170.00,170.00,0,"20/02/2025",0,0,0,"N. 2 CAMERE UNA TRIPLA AD EURO 260 E ALTRA DOPPIA AD EURO 190","BOOKRS",0,"13/02/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'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-04-2025',103),208,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=150.00, CONCORDATO=150.00 WHERE NUM=208 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),208,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=300.00, CONCORDATO=300.00 WHERE NUM=208 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'12-04-2025',103),208,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=208, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=300.00, CONCORDATO=300.00 WHERE NUM=208 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="13/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'11-04-2025',103),301,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=301 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','INSERT INTO PRENOTAZIONE VALUES (301,"18/07/2025","21/07/2025",2,0,0,0,"ELENA PETRALIA ","ELENA PETRALIA","","","","","","","",600.00,600.00,0,"20/04/2025",0,0,0,"220 SUPERIOR","BOOKRS",0,"13/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=600.00, ACCONTO=220.00, ENTROIL="13/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'13-04-2025',103),301,'03/07/2025 - 06/07/2025','INSERT INTO PRENOTAZIONE VALUES (301,"03/07/2025","06/07/2025",2,0,0,0,"ANDREA GIOVAGNOLI","ANDREA GIOVAGNOLI","","","","","","","",600.00,600.00,0,"20/04/2025",0,0,0,"220 SUPERIOR","BOOKRS",0,"13/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'13-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=0.00, ENTROIL="20/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'06/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"06/06/2025","07/06/2025",2,0,0,0,"LINDA STEFANETTI","LINDA STEFANETTI","","","","","","","",170.00,170.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'05/06/2025 - 07/06/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#06/05/2025#, AL=#06/07/2025#, TOTALE=340.00, CONCORDATO=340.00 WHERE NUM=301 AND dal=#06/06/2025# and al=#06/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'03/07/2025 - 06/07/2025','UPDATE PRENOTAZIONE SET NOME="ANDREA GIOVAGNOLI", COGNOME="ANDREA GIOVAGNOLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/03/2025# and AL=#07/06/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),301,'18/07/2025 - 21/07/2025','UPDATE PRENOTAZIONE SET NOME="ELENA PETRALIA ", COGNOME="ELENA PETRALIA", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="220 SUPERIOR OK BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=660.00, ACCONTO=220.00, ENTROIL="15/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="13/04/2025" where num=301 and DAL=#07/18/2025# and AL=#07/21/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),301,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="PIRRO/FABENI ", COGNOME="PIRRO/FABENI ", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 CAMERA SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="03/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=301 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),301,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (301,"19/06/2025","22/06/2025",2,0,0,0,"PIRRO/FABENI ","PIRRO/FABENI ","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"190 CAMERA SUPERIOR","BOOKRS",0,"27/01/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'01-04-2025',103),301,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONE", COGNOME="RAFFAELE TARTAGLIONE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="CAMERA SUPERIOR 210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="01/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="07/03/2025" where num=301 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),301,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=301, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=301 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),302,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=302, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=302 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'04-04-2025',103),302,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONEAMICI", COGNOME="IODICE PASQUALE", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="04/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=302 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),302,'26/06/2025 - 29/06/2025','UPDATE PRENOTAZIONE SET NOME="RAFFAELE TARTAGLIONEAMICI", COGNOME="RAFFAELE TARTAGLIONE AMICI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 ATTESA BONIFICO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=600.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="08/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="01/04/2025" where num=302 and DAL=#06/26/2025# and AL=#06/29/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'01-04-2025',103),302,'26/06/2025 - 29/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"26/06/2025","29/06/2025",2,0,0,0,"RAFFAELE TARTAGLIONEAMICI","RAFFAELE TARTAGLIONE AMICI","","","","","","","",600.00,600.00,0,"08/04/2025",0,0,0,"210 ATTESA BONIFICO","BOOKRS",0,"01/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),302,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"05/06/2025","07/06/2025",2,0,0,0,"FRANCESCO PALMEGGIANI","FRANCESCO PALMEGGIANI","","","","","","","",340.00,340.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),302,'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','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-04-2025',103),302,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=302, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=302 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'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,'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,'05-04-2025',103),303,'19/06/2025 - 23/06/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#06/19/2025#, AL=#06/23/2025#, TOTALE=680.00, CONCORDATO=680.00 WHERE NUM=303 AND dal=#06/20/2025# and al=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"30/05/2025","02/06/2025",2,1,0,0,"CORRADO ANDREAN","CORRADO ANDREAN","","","","","","","",470.00,470.00,0,"22/04/2025",0,0,0,"210 CAMERA VISTA MARE CON BALCONE","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="22/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"05/06/2025","07/06/2025",2,0,0,0,"LUIGI CERONI","LUIGI CERONI","","","","","","","",340.00,340.00,0,"22/04/2025",0,0,0,"170","BOOKRS",0,"15/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'17-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" (+39) 348 0705494", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=210.00, ENTROIL="17/04/2025", PAGATOS=0, PAGATOA=1, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'05-04-2025',103),303,'20/06/2025 - 24/06/2025','INSERT INTO PRENOTAZIONE VALUES (303,"20/06/2025","24/06/2025",2,0,0,0,"GIORGIO GHIRELLI","GIORGIO GHIRELLI","","","","","","","",680.00,680.00,0,"12/04/2025",0,0,0,"190","BOOKRS",0,"05/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-04-2025',103),303,'30/05/2025 - 02/06/2025','UPDATE PRENOTAZIONE SET NOME="CORRADO ANDREAN", COGNOME="CORRADO ANDREAN", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL=" (+39) 348 0705494", EMAIL="", NOTEP="210 CAMERA VISTA MARE CON BALCONE", NB=1, NA=2, MPA=0, MPB=0, TOTALE=470.00, CONCORDATO=630.00, ACCONTO=0.00, ENTROIL="22/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="15/04/2025" where num=303 and DAL=#05/30/2025# and AL=#06/02/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-04-2025',103),303,'06/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#07/06/2025#, AL=#07/07/2025#, TOTALE=200.00, CONCORDATO=200.00 WHERE NUM=303 AND dal=#07/05/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'10-04-2025',103),303,'05/07/2025 - 07/07/2025','UPDATE PRENOTAZIONE SET NUM=303, DAL=#07/05/2025#, AL=#07/07/2025#, TOTALE=400.00, CONCORDATO=400.00 WHERE NUM=303 AND dal=#07/06/2025# and al=#07/07/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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,'05-04-2025',103),303,'20/06/2025 - 24/06/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIO GHIRELLI", COGNOME="GIORGIO GHIRELLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=760.00, ACCONTO=0.00, ENTROIL="12/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="05/04/2025" where num=303 and DAL=#06/20/2025# and AL=#06/24/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),303,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (303,"23/05/2025","25/05/2025",2,0,0,0,"SANDRO CEREA","SANDRO CEREA","","","","","","","",300.00,300.00,0,"18/03/2025",0,0,0,"160 GRUPPO ANIENI","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'15-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,'07-04-2025',103),304,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (304,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",280.00,280.00,0,"14/04/2025",0,0,0,"150","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),304,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="150", NB=0, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=300.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=304 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'07-04-2025',103),305,'23/05/2025 - 25/05/2025','INSERT INTO PRENOTAZIONE VALUES (305,"23/05/2025","25/05/2025",2,0,0,0,"PAOLO TAMIETTI","PAOLO TAMIETTI","","","","","","","",280.00,280.00,0,"14/04/2025",0,0,0,"168","BOOKRS",0,"07/04/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'07-04-2025',103),305,'23/05/2025 - 25/05/2025','UPDATE PRENOTAZIONE SET NOME="PAOLO TAMIETTI", COGNOME="PAOLO TAMIETTI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="168", NB=0, NA=2, MPA=0, MPB=0, TOTALE=280.00, CONCORDATO=336.00, ACCONTO=0.00, ENTROIL="14/04/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="07/04/2025" where num=305 and DAL=#05/23/2025# and AL=#05/25/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),307,'23/07/2025 - 27/07/2025','INSERT INTO PRENOTAZIONE VALUES (307,"23/07/2025","27/07/2025",2,0,0,0,"GIORGIA BARBARULO","GIORGIA BARBARULO","CODICE FISCALE BRBGRG72R44F839V","ROMA 00161 VIA PADOVA 53","","","","3200132390","",680.00,680.00,0,"18/03/2025",0,0,0,"180","BOOKRS",0,"11/03/2025");');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'11-03-2025',103),307,'23/07/2025 - 27/07/2025','UPDATE PRENOTAZIONE SET NOME="GIORGIA BARBARULO", COGNOME="GIORGIA BARBARULO", INDIRIZZO="ROMA 00161 VIA PADOVA 53", RAGSOC="CODICE FISCALE BRBGRG72R44F839V", CAP="", CITTA="", PROV="", TEL="3200132390", EMAIL="", NOTEP="180 CAMERA STANDARD 3 PIANO", NB=0, NA=2, MPA=0, MPB=0, TOTALE=680.00, CONCORDATO=680.00, ACCONTO=0.00, ENTROIL="18/03/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="11/03/2025" where num=307 and DAL=#07/23/2025# and AL=#07/27/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'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,'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");');
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,'15-04-2025',103),308,'05/06/2025 - 07/06/2025','INSERT INTO PRENOTAZIONE VALUES (308,"05/06/2025","07/06/2025",2,0,0,0,"MARIA LAURA DE GENNARO ","MARIA LAURA DE GENNARO ","","","","","","","",280.00,280.00,0,"22/04/2025",0,0,0,"140 STANDARD","BOOKRS",0,"15/04/2025");');

TEMPORARY
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 (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','25/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (107,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','26/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','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','26/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (108,CONVERT(datetime,'23-07-2025',103),CONVERT(datetime,'27-07-2025',103),'AS','24/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,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 (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,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','21/06/2025',170,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,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'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','08/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','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','09/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','12/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'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,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'13-06-2025',103),CONVERT(datetime,'15-06-2025',103),'MS','14/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (202,CONVERT(datetime,'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,'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,'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,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','07/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AS','24/08/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','19/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','18/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','13/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'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,'17-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'12-06-2025',103),CONVERT(datetime,'16-06-2025',103),'MS','15/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','21/08/2025',240,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),'AS','23/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','08/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','22/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','09/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','10/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'08-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,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,'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,'07-07-2025',103),CONVERT(datetime,'13-07-2025',103),'AS','11/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','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'17-06-2025',103),CONVERT(datetime,'20-06-2025',103),'MS','17/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','16/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (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,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'16-07-2025',103),CONVERT(datetime,'20-07-2025',103),'AS','17/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (205,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,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','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,'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','22/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','21/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (207,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','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,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (208,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (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,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','03/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','04/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'03-07-2025',103),CONVERT(datetime,'06-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'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,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/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','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','26/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','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,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','18/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'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,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','19/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'18-07-2025',103),CONVERT(datetime,'21-07-2025',103),'AS','20/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'06-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'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','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','19/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','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','28/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','27/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'26-06-2025',103),CONVERT(datetime,'29-06-2025',103),'AS','26/06/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','30/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'BS','31/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'02-06-2025',103),'MS','01/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'20-06-2025',103),CONVERT(datetime,'24-06-2025',103),'MS','23/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'23-06-2025',103),'MS','22/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'05-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','05/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'06-07-2025',103),CONVERT(datetime,'07-07-2025',103),'AS','06/07/2025',200,0,0,0,0);
INSERT INTO TEMPORARY VALUES (303,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (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,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','04/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'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','01/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (304,CONVERT(datetime,'30-05-2025',103),CONVERT(datetime,'05-06-2025',103),'MS','02/06/2025',150,0,0,0,0);
INSERT INTO TEMPORARY VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','24/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (305,CONVERT(datetime,'23-05-2025',103),CONVERT(datetime,'25-05-2025',103),'BS','23/05/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (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','26/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 (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);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','05/06/2025',140,0,0,0,0);
INSERT INTO TEMPORARY VALUES (308,CONVERT(datetime,'05-06-2025',103),CONVERT(datetime,'07-06-2025',103),'MS','06/06/2025',140,0,0,0,0);

Num.Prenotazioni: 52
Num.Disdette: 5

17/04/2025 21:01:13
TRASFERIMENTO ESEGUITO. Tempo: 0 s

BookHLB.it

BookHLB - H.LaBaia. REPORT ANNO 2025. Incasso	17/04/2025

mese	101	103	107	108	201	202	203	205	206	207	208	301	302	303	304	305	307	308	Tot
Aprile	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Maggio	0	0	0	0	300	300	300	368	0	240	0	320	320	950	1100	336	0	0	4534
Giugno	510	510	0	0	880	340	920	720	440	0	0	1540	1540	1020	0	0	0	280	8700
Luglio	0	0	680	960	2090	1230	2170	1080	0	0	300	1520	200	200	0	0	720	0	11150
Agosto	0	0	0	0	0	0	1470	0	1560	0	0	0	0	0	0	0	0	1140	4170
Settembre	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
.	510	510	680	960	3270	1870	4860	2168	2000	240	300	3380	2060	2170	1100	336	720	1420	28554

Riepilogo Euro

Aprile	0
Maggio	4534
Giugno	8700
Luglio	11150
Agosto	4170
Settembre	0
Ottobre	0

Mese	Stanze	Adulti	Bambini
Aprile	0	0	0
Maggio	12	24	1
Giugno	18	36	2
Luglio	19	38	2
Agosto	3	6	1
Settembre	0	0	0
Ottobre	0	0	0

Riepilogo Presenze

=N.Stanze

=N.Adulti

=N.Bambini

Aprile	0/0/0
Maggio	12/24/1
Giugno	18/36/2
Luglio	19/38/2
Agosto	3/6/1
Settembre	0/0/0
Ottobre	0/0/0

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