Generate List Set of Years based on two Dates in SQL Server

Hi EmadKhan,

Refer below query.

SQL

DECLARE @Counter INT,@StartYear INT, @EndYear INT
SET @Counter = 1
SET @StartYear = YEAR(GETDATE())
SET @EndYear = 1970

DECLARE @Test AS TABLE(StartRange INT,EndRange INT)
DECLARE @StartRange INT,@EndRange INT	
SET @StartRange = @StartYear

WHILE (@Counter <= (@StartYear - @EndYear))
BEGIN	
	SET @EndRange = @StartRange - 9
    INSERT INTO @Test (StartRange,EndRange) VALUES (@StartRange,@EndRange)
	SET @StartRange = @EndRange - 1
	SET @Counter = @Counter + 10
    CONTINUE;
END
  
SELECT CONVERT(VARCHAR,StartRange) + '-' + CONVERT(VARCHAR,EndRange) AS 'Range'  FROM @Test

Output

2019-2010

2009-2000

1999-1990

1989-1980

1979-1970

I appreciate your effort, this is my solution :

declare @minYear nvarchar(4) = '2000' , @maxYear nvarchar(4) = datepart(year,getdate()), @counter int = 1, @howManyYearsPerGroup tinyint = 10; DECLARE @yearTable TABLE(rowNumber int, years nvarchar(4)) ;with CTE AS 
    (SELECT datepart(year,
         @minYear) AS yr
    UNION
    allSELECT yr + 1
    FROM CTE
    WHERE yr < datepart(year,
         @maxYear)) INSERT INTO @yearTableSELECT ROW_NUMBER()
    OVER (ORDER BY YR) AS RowNumber, *
FROM cte DECLARE @ntile int SET @ntile = 
    (SELECT count(1)
    FROM @yearTable) / @howManyYearsPerGroup ;WITH myCTE AS 
    (SELECT NTILE(@ntile)
        OVER (ORDER BY rownumber) myGroup,years
    FROM @yearTable )
SELECT CONCAT(min(years),
        ' - ',max(years)) AS ListOfYears
FROM myCTE
GROUP BY  myGroup
ORDER BY  myCTE.myGroup DESC