从sql中的日期范围获取包含或不包含数据的所有年份和月份

I have table dbo.[sg_Attendance] with schema as shown above image. Now using below query I am getting output with only listed data as:I have table dbo.[sg_Attendance] with schema