views in Access/SQL server

Jeg er ved at konvertere til SQL fra Access og har problemer med to views der der slet ikke vil funke på SQL-server. DEn kan ikke li' date + det meste af viewene. Please help

View 1:SELECT Hitlist.HitID, HitName, HitURL, Description, Category, SUM(HitCount) AS HitSum
FROM Hitlist, Hitmembers
WHERE (Hitlist.HitID=Hitmembers.HitID AND HitDate>= (Date() - 5))
GROUP BY Hitlist.HitID, HitURL, HitName, Description, Category
ORDER BY -SUM(HitCount);

View 2

SELECT HitID, MIN(HitDate) AS StartDate, SUM(HitCount) AS HitTotSum
FROM Hitlist
GROUP BY HitID
ORDER BY -SUM(HitCount);