79365413

Date: 2025-01-17 16:23:22
Score: 1.5
Natty:
Report link

Managed to do it this way -

declare @startDate datetime,  
    @endDate datetime;  

select @startDate = getdate(),
@endDate = dateadd(year,1,getdate()) -1

;with myCTE as
(
select 1 as ROWNO,@startDate "StartDate" ,@EndDate "EndDate"

union all
select ROWNO+1 ,dateadd(YEAR, 1, StartDate) , dateadd(YEAR, 1, EndDate)

FROM myCTE

where ROWNO+1 <= 10

)  

select ROWNO,Convert(varchar(10),StartDate,105) as StartDate ,Convert(varchar(10),EndDate,105) from myCTE

Reasons:
  • Has code block (-0.5):
  • User mentioned (1): @startDate
  • User mentioned (0): @endDate
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: ikilledbill