如何在sql中的表中按组填充缺少的日期

I want to know how to use loops to fill in missing dates with value zero based on the start/end dates by groups in sql so that i have consecutive time series in each group. I have two questions.I want to know how to use loops to fill in miss