--generate a sequence of digit from 0 to nCREATE TABLE DBO.NUMBERS(i INT NOT NULL PRIMARY KEY);goINSERT INTO dbo.numbers(i)VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);goINSERT INTO dbo.numbers(i)SELECT numfrom ( SELECT (n4.i * 1000 + n3.i * 100 + n2.i * 10 + n1.i) AS num FROM dbo.numbers n1 CROSS JOIN dbo.numbers n2 CROSS JOIN dbo.numbers n3 CROSS JOIN dbo.numbers n4 ) xWHERE num > 9ORDER BY num;--goal: Output CombYr = 3/4/5/--Input: @startYr int, @endYr int--assume inputs are valid. and year is 4-digit format. and EndYr - BegYr <= 10DECLARE @startYr INT = 2011 , @endYr INT = 2013;DECLARE @outputStr NVARCHAR(100) = ''; SELECT @outputStr = @outputStr + RIGHT(CAST(n.i AS VARCHAR(4)), 1) + '/' FROM dbo.numbers nWHERE n.i BETWEEN @startYr AND @endYr;SELECT @outputStr;