I'd like to query our database for the total number of events per day. I have attached what I have written so far. I'm most interested for when the total is 0, and this query doesn't present 0 in its rowset.
How can I get this to present 0 and the date when the total is 0 for a particular day of the month
SELECT DATEPART(MONTH, created) AS 'Month',
DATEPART(day, created) AS N'Day', COUNT(*)
GROUP BY DATEPART(MONTH, Created), DATEPART(day, Created)
ORDER BY DATEPART(MONTH, Created), DATEPART(day, Created)