...
| SQL | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
SELECT '<a href="http://confluence.dev.ultimate.net.au:8090/display/HELP/Eclipse+Client+DetailCopy of Compulsory Third Party Fees - Queensland?run_1=run&run_1_EffDate=' + CONVERT( VARCHAR(10), [eff_date], 23) + ' " target="_blank">' + CONVERT( VARCHAR(10), [eff_date], 103)+ '</a>' AS [CTP Fees Effective Date] FROM [CTP_qld_import_history] WHERE eff_date > '01/01/2019' GROUP BY [eff_date] ORDER BY [eff_date] DESC |
...