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');