select cho_id, cho_type, cho_name from tbl_CHO_Operators with (nolock)
where ( cho_type = 'G' and cho_segmentId = 54 )
or cho_type = 'C'
select * from qmd_memberships
where 1 = 1
and cho_type = 'G'
and cho_type = 'C'
order by cho_name
#_type# Membership Deactivation due to Membership Change
| Member Group | Deactivate Count |
| #cho_name# | |