Changes between Version 3 and Version 4 of last change fish & operation

Timestamp:

Dec 7, 2010 10:10:34 PM (14 years ago)

Author:

cedric

Comment:

--

last change fish & operation

@@ -38 +38 @@
 group by fi_id) as toto where count>1);
 ; -- 22086 -- export update_fish_op_1.sql --lancer ici le script sql
+
+
+-- now I still have when joining on date and station some fish pointing to more than one operation
+select * from wrbd.fish_fi join wrbd.operation_op op on (fi_date,fi_st_id)=(op_date,op_st_id)
+where fi_op_id is null and fi_date is not null; -- 58
+
+-- only two choices there... One with 8 fishes (fi_id 10761 to 10768) one with 21 8 is 1674 21 is 1675
+select * from wrbd.fish_fi where fi_id>=10761 and fi_id<=10768; -- to verify
+update wrbd.fish_fi set fi_op_id=1674 where fi_id>=10761 and fi_id<=10768;
+
+select * from wrbd.fish_fi join wrbd.operation_op op on (fi_date,fi_st_id)=(op_date,op_st_id)
+where fi_op_id is null and fi_date is not null; -- 42
+
+select * from wrbd.fish_fi where fi_id>=10769 and fi_id<=10789; -- to verify
+update wrbd.fish_fi set fi_op_id=1675 where fi_id>=10769 and fi_id<=10789;
+
+-- OK finished for pivot on date
+
+select * from wrbd.fish_fi where fi_op_id is null; --1346 still.... some have dates uh ?
 }}}