with x as ( select datefromParts( year(claimDate), month( claimDate ), 1 ) claimMonth, coalesce( sum( claimDollars ), 0.0 ) claimDollars, coalesce( sum( claimCases ), 0.0 ) claimCases from tbl_DW_OperatorExclusions#_tableSuffix# with (nolock) where ownerId = and ownerType = and beneficiaryOperatorId1 <> beneficiaryOperatorId2 and claimDate between and group by claimDate ) select format( claimMonth, 'MMM yy' ) claimMonth, sum( claimDollars ) as claimDollars, sum( claimCases ) as claimCases from x group by claimMonth order by x.claimMonth select claimantPartnerId, claimantPartnerType, claimantPartnerName, claimId, format( claimDate, 'MM/dd/yyyy' ) claimDate, claimInvoice, claimRef, coalesce( sum( claimDollars ), 0.0 ) claimDollars, coalesce( sum( claimCases ), 0.0 ) claimCases, assignedContractNbr2 assginedContractNbr, beneficiaryOperatorName2 beneficiaryOperatorName, contractName2 contractName assignedContractNbr1 assignedContractNbr, beneficiaryOperatorName1 beneficiaryOperatorName, contractName1 contractName from tbl_DW_OperatorExclusions#_tableSuffix# with (nolock) where ownerId = and ownerType = and beneficiaryOperatorId1 <> beneficiaryOperatorId2 and claimDate between and group by claimantPartnerId, claimantPartnerType, claimantPartnerName, claimId, claimDate, claimInvoice, claimRef, assignedContractNbr2, beneficiaryOperatorName2, contractName2 assignedContractNbr1, beneficiaryOperatorName1, contractName1 order by beneficiaryOperatorName select 'All' as beneficiaryOperatorName, sum( claimDollars ) claimDollars, sum( claimCases ) claimCases from qmd_data select beneficiaryOperatorName, sum( claimDollars ) claimDollars, sum( claimCases ) claimCases from qmd_data group by beneficiaryOperatorName #queryToJSON2( qmd_data, _numericColumns )#