declare @date datetime,
@date1 datetime
set @date=‘2021-01-01’
set @date1=‘2021-10-01’
insert [control_date]
select --[day]=
replace(left(convert(varchar,DATEADD(mm,DATEDIFF(mm,0,@date),0)+number,121),10),’-’,’’)
,0 as flag
,‘tablename’ as table_name
from master…spt_values
where type=‘p’
and number< 282
select *from dbo.control_date