Versions Compared

Key

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

...

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)], 
																										ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ , 
																										ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE , 
																										ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ 
FROM (
  select *
from 
(
  select period, rank, class,  [insurer] , [gross_comm] AS premium
  from [CTP_qld_import] 
) src
pivot
(
  SUM([premium])
  for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 3 order by rank


Non ITCE 12 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)], 
																										ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ , 
																										ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE , 
																										ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ 
FROM (
  select *
from 
(
  select period, rank, class,  [insurer] , [gross_priv] AS premium
  from [CTP_qld_import] 
) src
pivot
(
  SUM([premium])
  for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 12 order by rank

Non ITCE 6 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)], 
																										ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ , 
																										ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE , 
																										ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ 
FROM (
  select *
from 
(
  select period, rank, class,  [insurer] , [gross_priv] AS premium
  from [CTP_qld_import] 
) src
pivot
(
  SUM([premium])
  for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 6 order by rank

Non ITCE 3 Month Rates

SQL
noDataMessageNo Records Found!
columnLabeltrue
columnTypesS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXsstrue
width100%
columnAttributesstyle="background:#f2f2f2;text-align:center;font-weight:bold"
dataSourceManufacturerDS
select CASE WHEN class LIKE '%seat%' THEN '+ per adult passenger seat over 7' ELSE REPLACE(class, 'base','') END AS Class, ISNULL(CAST(AAI AS VARCHAR),'n/a') AS [AAI (SUNCORP)], 
																										ISNULL(CAST(ALLIANZ AS VARCHAR),'n/a') AS ALLIANZ , 
																										ISNULL(CAST(QBE AS VARCHAR),'n/a') AS QBE , 
																										ISNULL(CAST(RACQ AS VARCHAR),'n/a') AS RACQ 
FROM (
  select *
from 
(
  select period, rank, class,  [insurer] , [gross_priv] AS premium
  from [CTP_qld_import] 
) src
pivot
(
  SUM([premium])
  for [insurer] in ([AAI], [ALLIANZ], [QBE], [RACQ])
) piv
) AS CTP
where period = 3 order by rank