Untitled

SQL Server 2000 Group By asking for aggregate function when it is supplied
SELECT     c.ContractID, max( cs.ContractStatusCreated)
FROM       dbo.NMPT_Contract AS c INNER JOIN
           dbo.NMPT_ContractStatus AS cs ON c.ContractID = cs.ContractID INNER JOIN
           dbo.CMSS_Status AS s ON cs.StatusID = s.StatusID
group by  c.ContractID
having cs.ContractStatusCreated = MAX(cs.ContractStatusCreated)

select     ContractID, ContractStatusCreated
FROM       dbo.NMPT_Contract AS x INNER JOIN
           dbo.NMPT_ContractStatus AS y ON x.ContractID = y.ContractID
where (x.ContractID, y.ContractStatusCreated) = (
    SELECT     c.ContractID, max( cs.ContractStatusCreated)
    FROM       dbo.NMPT_Contract AS c INNER JOIN
               dbo.NMPT_ContractStatus AS cs ON c.ContractID = cs.ContractID INNER JOIN
               dbo.CMSS_Status AS s ON cs.StatusID = s.StatusID
    group by  c.ContractID
)