PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=40 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=40 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=35 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=35 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=38 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=38 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=36 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=36 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=37 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=37 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=39 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=39 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=5 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=5 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=28 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=28 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=1 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=1 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=41 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=41 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=4 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=4 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=42 AND data BETWEEN '2018-01-01' AND '2018-01-31' GROUP BY data) AS T);
PIOGGIA CUMULATA: SELECT sum(T.maxrain) as totrain FROM ((select MAX(CAST(rain AS DECIMAL(5,2))) AS maxrain, data from DatiStazioniDrop where IdStazione=42 AND data BETWEEN '2018-01-01' AND '2018-12-31' GROUP BY data)AS T);

RIEPILOGHI MENSILI E ANNUALI DA FARE

RIEPILOGHI MENSILI

DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK

DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK

DATO OK
DATO OK



DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK
DATO OK

RIEPILOGHI ANNUALI

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (29,'13.4','-1.6','1024.4','999.0','9.4','-9.9','53.1','-3.4','212.1','12.4','91.0','22.0','54.1');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (19,'12.2','-0.2','1022.1','996.6','9.6','-8.5','49.9','-0.2','144.0','12.1','94.0','0.0','39.0');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (40,'12.5','-2.8','1024.6','999.0','8.9','-7.8','35.4','-2.8','25.4','11.7','90.0','30.0','42.80');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (35,'18.2','6.3','1018.4','998.5','11.1','-3.3','59.6','2.8','42.2','16.7','95.0','32.0','110.40');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (38,'20.2','3.1','1023.5','1002.9','13.9','0.6','69.2','2.8','0.0','19.4','95.0','42.0','0.00');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (36,'20.3','4.8','1022.5','1001.5','13.9','0.0','78.9','3.3','35.2','20.6','93.0','40.0','72.40');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (37,'19.1','2.1','1024.6','1003.3','12.8','0.0','67.6','-0.6','0.0','18.9','95.0','45.0','0.40');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (39,'20.7','4.7','1022.7','1002.5','13.9','1.1','66.0','2.8','64.0','20.6','93.0','35.0','62.00');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (21,'','','','','','','','','','','','','');

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (5,'12.7','-0.2','1022.5','997.3','9.4','-8.9','43.5','-1.7','1.6','12.8','96.0','26.0','36.60');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (11,'12.7','-1.0','1024.6','999.5','10.1','-4.4','53.1','-1.0','52.3','12.2','94.0','32.0','27.3');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (9,'11.2','-1.1','1024.3','999.0','9.4','-5.9','56.3','-2.5','80.6','11.1','97.0','36.0','54.2');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (20,'13.2','-0.2','1024.6','999.3','10.2','-8.1','29.0','-1.7','107.7','11.9','97.0','29.0','70.2');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (17,'12.6','-0.8','1023.1','998.0','9.6','-4.9','46.7','-1.2','15.5','12.3','84.0','35.0','38.5');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (10,'12.3','-1.8','1018.6','1008.1','1.8','-16.0','16.1','-1.8','5.1','10.9','73.0','30.0','7.5');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (28,'15.6','0.3','1029.4','997.1','10.6','-7.8','75.7','-2.8','0.0','15.0','97.0','28.0','8.80');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (18,'13.3','0.0','1024.8','999.1','11.3','-5.5','40.2','0.0','7.0','13.2','99.0','0.0','4.6');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (25,'13.1','0.1','1022.3','997.0','10.1','-6.4','40.2','-2.2','73.0','13.0','90.0','26.0','38.2');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (15,'13.9','0.0','1023.1','0.0','11.0','-4.7','51.5','-0.5','114.3','13.4','92.0','0.0','37.7');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (24,'','','','','','','','','','','','','');

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (16,'13.4','0.0','1017.4','1002.4','6.5','-4.9','35.4','0.0','0.0','12.1','93.0','0.0','0.0');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (14,'13.1','0.3','1022.0','996.7','10.4','-5.1','57.9','-0.5','62.5','12.8','91.0','28.0','41.5');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (1,'','','','','','','','','','','','','');

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (2,'','','','','','','','','','','','','');

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (3,'','','','','','','','','','','','','');

ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (41,'6.8','-2.4','1024.6','999.2','5.0','-11.7','49.9','-3.3','9999.9','6.7','99.0','40.0','43.80');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (4,'16.4','5.9','1021.3','995.2','11.1','-7.8','75.7','5.6','15.2','15.6','94.0','21.0','46.20');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (8,'12.7','-0.4','1023.8','998.5','11.1','-4.9','83.7','-0.7','18.8','12.7','100.0','30.0','19.0');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (6,'12.6','0.0','1022.1','996.8','9.9','-10.1','62.8','-2.9','87.2','12.4','93.0','20.0','39.8');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (42,'14.1','-1.1','1023.6','998.1','11.7','-2.8','19.3','-1.1','5.6','13.3','99.0','33.0','25.40');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (27,'11.3','-2.3','1025.2','999.2','8.9','-7.7','25.7','-2.3','43.0','11.1','98.0','32.0','23.8');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (23,'6.8','-9.5','1028.1','999.8','3.3','-11.6','27.4','-9.5','9.2','6.5','99.0','46.0','56.8');
DATO OK
ESEGUO: INSERT INTO dropediacurrentyearriepilogue (IdStazione, TMax, TMin, PMax,PMin, DPMax, DPMIN, WRMax, WCMin, RRMax, HIMax, URMax, URMin,totRain) VALUES (26,'13.0','-0.8','1025.3','1000.1','10.9','-7.0','51.5','-1.8','87.2','12.8','97.0','25.0','41.0');
DATO OK