SELECT ISNULL(CONVERT(char, HitCounter.hitdate, 101), '') AS Date, Contractors.ContractorName AS [Contractor Name], HitCounter.hitcount AS [Total Hits]
FROM HitCounter INNER JOIN
Contractors ON HitCounter.ContractorID = Contractors.ContractorID
ORDER BY HitCounter.ContractorID
...ps...
SELECT hitcount FROM HitCounter where ContractorID=16
SELECT SUM(hitcount) AS Total FROM HitCounter where ContractorID=16
Updating...
Plans and Specs Reprographics Plan Room
