tsql - sql missing rows when grouped by DAY, MONTH, YEAR

Question

If I select from a table group by the month, day, year, it only returns rows with records and leaves out combinations without any records, making it appear at a glance that every day or month has activity, you have to look at the date column actively for gaps. How can I get a row for every day/month/year, even when no data is present, in T-SQL?

Answer 1

Create a calendar table and outer join on that table