Page Comparison

Old:
select distinct
'IR',
case when not exists (select * FROM dwhs_ods..ca_chart_t a  where a.fin_coa_cd= 'IR' 
                       AND a.FIN_COA_ACTIVE_CD <> 'N' )
then 'false'
else 'true'
end

New:
SELECT SELECT 
FIN_COA_CD, 
FIN_COA_ACTIVE_CDCD 
FROMFROM 
dwhs_ods..ca_chart_t WHERE fin_coa_cd_t 
WHERE 
FIN_COA_ACTIVE_CD <> 'N' AND 
FIN_COA_CD IN ('IR', 'MC', 'UC', 'XX', 'X', 'I');