declare @StartDate DATETIME = ‘2015/05/01’
declare @EndDate DATETIME =’2015/06/03’;
with cte as
(
select @StartDate dday
union all
select dday +1 from cte
where dday < @EndDate
)
select * from cte
option(maxrecursion 0)
declare @StartDate DATETIME = ‘2015/05/01’
declare @EndDate DATETIME =’2015/06/03’;
with cte as
(
select @StartDate dday
union all
select dday +1 from cte
where dday < @EndDate
)
select * from cte
option(maxrecursion 0)