Are you using join or not ???

I think Case condition has to be reversed and then we get the right answer

SELECT

DATEDIFF(yy, @DateOfBirth, GETDATE()) - CASE WHEN DATEPART(m, @DateOfBirth) >= DATEPART(m, GETDATE()) AND DATEPART(d, @DateOfBirth) >=...