SELECT DISTINCT TOP 100 PERCENT MAX(ContractDate) AS ContractDate, PersonelNo, CompanyId 
FROM dbo.Contract
GROUP BY PersonelNo, CompanyId
HAVING (ContractDate LIKE '2012%')

Select C.* from Contract C
inner join
(
Select CompanyId,PersonelNo,MAX(ContractDate) ContractDate
from dbo.Contract
Group by CompanyId,PersonelNo
)CT.CompanyId = C.CompanyId and CT.PersonelNo = C.PersonelNo
and CT.ContractDate  = C.ContractDate
Where Year(ContractDate) = 2012