Reporting years
SELECT
reportingYear as opt_key,
reportingYear as opt_value,
reportingYear as opt_text
FROM [IED].[DB_VERSION].[ReportData]
GROUP BY reportingYear
ORDER BY opt_text DESCNo data
SELECT
reportingYear as opt_key,
reportingYear as opt_value,
reportingYear as opt_text
FROM [IED].[DB_VERSION].[ReportData]
GROUP BY reportingYear
ORDER BY opt_text DESCNo data