>SELECT DATEADD(day, DATEDIFF(day, 0, @dt), 0) AS HitDate, > COUNT(DISTINCT AddUser) AS CountHit > FROM Hit > GROUP BY HitDate >It seems to be fancy. But, I have an invalid column name on HitDate. Also, what would be the value I would need to store in dt? Would it be my oldest date in the Hit table?
