Trasferimento dati da MS-Access:Labaia.mdb ==> MSSQL:MSSql162519     05/02/2025 10:00:43
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
No-Rows
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,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,540,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),2,0,0,0,'FERNANDO MIRAGLIA','FERNANDO MIRAGLIA','-','-','-','-','-','-','-',510,540,180,CONVERT(datetime,'27-01-2025',103),1,0,0,'180 CAMERA VISTA MARE BALCONE 2 CAMERE','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PIRRO/FABENI ','PIRRO/FABENI ','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),2,0,0,0,'PORTANOVA/PICHILLI','PORTANOVA/PICHILLI','-','-','-','-','-','-','-',510,570,0,CONVERT(datetime,'03-02-2025',103),0,0,0,'190 CAMERA SUPERIOR','BOOKRS','0',CONVERT(datetime,'27-01-2025',103));
INSERT INTO PRENOTAZIONE VALUES (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,'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,'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),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,'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,'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,'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,'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,'27-01-2025',103),302,'19/06/2025 - 22/06/2025','UPDATE PRENOTAZIONE SET NOME="PORTANOVA/PICHILLI", COGNOME="PORTANOVA/PICHILLI", INDIRIZZO="", RAGSOC="", CAP="", CITTA="", PROV="", TEL="", EMAIL="", NOTEP="190 CAMERA SUPERIOR", NB=0, NA=2, MPA=0, MPB=0, TOTALE=510.00, CONCORDATO=570.00, ACCONTO=0.00, ENTROIL="03/02/2025", PAGATOS=0, PAGATOA=0, PAGATOC=0, EXTRA=0.00, DATAP="27/01/2025" where num=302 and DAL=#06/19/2025# and AL=#06/22/2025#;');
INSERT INTO LOG VALUES ('BOOKRS',CONVERT(datetime,'27-01-2025',103),302,'19/06/2025 - 22/06/2025','INSERT INTO PRENOTAZIONE VALUES (302,"19/06/2025","22/06/2025",2,0,0,0,"PORTANOVA/PICHILLI","PORTANOVA/PICHILLI","","","","","","","",510.00,510.00,0,"03/02/2025",0,0,0,"190 CAMERA SUPERIOR","BOOKRS",0,"27/01/2025");');
TEMPORARY
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (201,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','22/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'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,'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','20/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','18/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','21/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-08-2025',103),CONVERT(datetime,'25-08-2025',103),'AA','19/08/2025',240,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','18/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','19/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (203,CONVERT(datetime,'18-06-2025',103),CONVERT(datetime,'21-06-2025',103),'MS','20/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,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (301,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (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','21/06/2025',170,0,0,0,0);
INSERT INTO TEMPORARY VALUES (302,CONVERT(datetime,'19-06-2025',103),CONVERT(datetime,'22-06-2025',103),'MS','20/06/2025',170,0,0,0,0);
Num.Prenotazioni: 5
Num.Disdette: 0
05/02/2025 10:00:43
TRASFERIMENTO ESEGUITO.   Tempo: 0 s




BookHLB.it
BookHLB - H.LaBaia. REPORT ANNO 2025.  Incasso    05/02/2025
mese101102103104105106107108 201202203204205206207208 301302303304305306307308 309310Tot
Aprile000000000000000000000000000
Maggio000000000000000000000000000
Giugno00000000540054000000570570000000002220
Luglio000000000000000000000000000
Agosto000000000014700000000000000001470
Settembre000000000000000000000000000
Ottobre000000000000000000000000000
.000000005400201000000570570000000003690

Riepilogo Euro
Aprile0
Maggio 0
Giugno 2220
Luglio 0
Agosto 1470
Settembre0
Ottobre 0



MeseStanzeAdultiBambini
Aprile000
Maggio000
Giugno480
Luglio000
Agosto120
Settembre000
Ottobre000


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

Maggio0/0/0

Giugno4/8/0

Luglio0/0/0

Agosto1/2/0

Settembre0/0/0

Ottobre0/0/0

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