1
SELECT [year] AS [value],[year] AS label FROM ( SELECT FORMAT(DATEADD(YEAR,-number,GETDATE()),‘yyyy‘) AS [year] FROM master.dbo.spt_values WHERE type=‘p‘ and number<10) AS t
2023-11-15 13:12:46
1
SELECT [year] AS [value],[year] AS label FROM ( SELECT FORMAT(DATEADD(YEAR,-number,GETDATE()),‘yyyy‘) AS [year] FROM master.dbo.spt_values WHERE type=‘p‘ and number<10) AS t