Yeap.

DECLARE @DateFrom DATE = '2018-01-01';
DECLARE @DateTo DATE = '2018-08-21';

IF OBJECT_ID('tempdb..#ClaimType') IS NOT NULL
DROP TABLE #ClaimType

CREATE TABLE #ClaimType
(
  ClaimDescription VARCHAR(255) PRIMARY KEY...

Quick question, what does CASE WHEN THEN 1 mean? What's the THEN 1 doing exactly?

Claim Main Table Sample

CREATE TABLE [Schema.ClaimMain]
(
 [PolicyNumber] [int] NULL,
 [ClaimNumber] [int] NOT NULL,
 [ClaimType] [smallint] NOT NULL,
 [CurrentStatus] [smallint] NOT NULL,
 [OpeningRegistrationDate] [datetime] NOT...

Hi Thom.

I've changed the code to this.

DECLARE @DateFrom DATE = '2018-01-01';
DECLARE @DateTo DATE = '2018-08-21';

SELECT GenPar.ParameterValue AS ClaimType,
       COUNT(CASE ClaimMain.CurrentStatus...