SELECT DISTINCT CONVERT(nvarchar(10), Date, 105) AS Date, COUNT(CONVERT(nvarchar(10), Date, 105)) AS hits
FROM         Statistiche
GROUP BY CONVERT(nvarchar(10), Date, 105)