
update std00160
   set species_name = case when species = '134' then 'Slagtekalv st.r. 0-6mdr.(220 kg)'
                           when species = '137' then 'Slagtekalv st.r. (220-440 kg)'
                           when species = '138' then 'Slagtekalv Jers. 0-6mdr.(145 kg)'
                           when species = '140' then 'Slagtekalv Jers. (145-328 kg)'
                           else species_name end
 where species in ('134','137','138','140') and expire_date is null;

update std00160_perm
   set species_name = case when species = '134' then 'Slagtekalv st.r. 0-6mdr.(220 kg)'
                           when species = '137' then 'Slagtekalv st.r. (220-440 kg)'
                           when species = '138' then 'Slagtekalv Jers. 0-6mdr.(145 kg)'
                           when species = '140' then 'Slagtekalv Jers. (145-328 kg)'
                           else species_name end
 where species in ('134','137','138','140') and expire_date is null;

update agr_correction_parm
   set species_name = case when species = '134' then 'Slagtekalv st.r. 0-6mdr.(220 kg)'
                           when species = '137' then 'Slagtekalv st.r. (220-440 kg)'
                           when species = '138' then 'Slagtekalv Jers. 0-6mdr.(145 kg)'
                           when species = '140' then 'Slagtekalv Jers. (145-328 kg)'
                           else species_name end
 where species in ('134','137','138','140');

update agr_corr_parm_perm
   set species_name = case when species = '134' then 'Slagtekalv st.r. 0-6mdr.(220 kg)'
                           when species = '137' then 'Slagtekalv st.r. (220-440 kg)'
                           when species = '138' then 'Slagtekalv Jers. 0-6mdr.(145 kg)'
                           when species = '140' then 'Slagtekalv Jers. (145-328 kg)'
                           else species_name end,
       const16      = case when species = '134' then 40
                           when species = '137' then 220
                           when species = '138' then 25
                           when species = '140' then 145
                           else const16 end, 
       const17      = case when species = '134' then 220
                           when species = '137' then 440
                           when species = '138' then 145
                           when species = '140' then 328
                           else const17 end
 where species in ('134','137','138','140');
