Changes between Version 51 and Version 52 of Noeud - parcours RHT

Timestamp:

Jan 9, 2012 2:46:42 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -298 +298 @@
 from (select id_drain,dmer,cumnbbar from rht.noeudmervs2 where dmer is not null and noeudmer) sub
 where sub.id_drain=rhtvs2.id_drain;  ---100 lignes
+
+
+
+-- Calcul du nb de barrages cumulé sous R et réimport
+create table rht.cumnbbarvs2(
+        id_drain integer primary key,
+        cumnbbar integer);
+---Cédric
+copy rht.cumnbbarvs2 from 'E:/workspace/EDAdata/dataEDArht/cumnbbar.csv' with csv header delimiter as ';' NULL AS 'NA';--114600
+---Céline
+copy rht.cumnbbarvs2 from 'D:/CelineJouanin/workspace/EDAData/dataEDArht/cumnbbar.csv' with csv header delimiter as ';' NULL AS 'NA';
+
+---A FAIRE mais pb dans requete ci-dessus (pas le même nb de lignes que RHT)
+-- mise à jour des cumuls barrage  
+update rht.rhtvs2 t set cumnbbar=sub.cumnbbarvs2 from (
+select id_drain, cumnbbar from rht.cumnbbar) as sub
+where t.id_drain=sub.id_drain
+
 }}}