select  id,countanimals,chipid,animalsname,userfixeddate,rowrank
from
(
SELECT  top 100  animals.id,count(animals.id) as countanimals,animals.chipid as chipid,
animals.name as animalsname,animals.userfixeddate,
ROW_NUMBER()
OVER (
order by CASE WHEN @orderbyc=1 THEN animals.name
END ASC,
CASE WHEN @orderbyc=2 THEN animals.name
END DESC,
userfixeddate ASC
) as 'ROWRANK'

FROM  Animals ON  Animals.ownerid = Owners.id INNER JOIN
                      pettype ON Animals.pettype = pettype.id
where  animals.usname=@usnamelower and (animals.lag <> 99 or animals.lag is null) 
and (nullif(@animalname,'') is null or animals.name like  @animalname + '%')
group by animals.id,chipid,animals.name,animals.userfixeddate,animals.createddate
order by animals.createddate asc
)t 
group by t.id,t.countanimals,t.chipid,t.animalsname,t.userfixeddate,t.rowrank
order by 
CASE WHEN @orderbyc=1 THEN animalsname
END ASC,
CASE WHEN @orderbyc=2 THEN animalsname
END DESC,
userfixeddate ASC