Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SQL
noDataMessageNo Records Found!
columnLabeltrue
disableAntiXsstrue
width100%50%
dataSourceManufacturerDS
SELECT '<a href="http://confluence.dev.ultimate.net.au:8090/display/pub/Compulsory Third Party Fees (Queensland) - Detailed Fees?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

...