RuleName combination

Hi Anonymous ,

For SQL Query, you can try to write it like this:

select case when RuleName in ('A','B') then 'AB' when RuleName in ('C','D','E') then 'CDE' when RuleName in ('F','G') then 'FG' end as RuleName,
sum([Total Records])"Total Records", sum([Total Records Passed]) "Total Records Passed",sum([Total Records Failed]) "Total Records Failed",
cast(cast(100 *(sum([Total Records Passed])/sum([Total Records])  )as decimal(18,1) ) as varchar(50))+'%' "Pass%",
cast(cast(100 *(sum([Total Records Failed])/sum([Total Records])  )as decimal(18,1) ) as varchar(50))+'%' "Fail%"
from Rules
group by 
case when RuleName in ('A','B') then 'AB' when RuleName in ('C','D','E') then 'CDE' when RuleName in ('F','G') then 'FG' end

Best Regards

Rena