Übersicht über das Alter und die Produktivität von Kühen

Rinder - Übersicht über das Alter und die Produktivität von Kühen

declare @animalType varchar(3)
set @animalType=(SELECT acSetOfItemCattle FROM dbo.tFA_Param)
select ls.acAnimal as Animal_ID, 
        ls.acName, 
        convert(date, ls.adDateBirth) as DateBirth, 
        dd.mF as AgeInMonths, 
        mi.anAllMilkKG as anLastMilkKg
from vFA_LiveStock ls
left join 
( select 
    acAnimal, 
    MAX(anQId) as maxID
  from tfa_livestockmilk 
  group by acAnimal) m on m.acAnimal = ls.acAnimal 
left join tfa_livestockmilk mi on mi.anQId = m.maxID
CROSS APPLY fFA_GetDateDiffYMD(ls.adDateBirth, GETDATE()) as dd
where ls.acSetOfAnimalType = @animalType
order by dd.mF desc