PREVIEW ONLY

select * from qmd_1fsGroupsToConvert where cho_id =

Converting #lsnumberformat( qmd_1fsGroupsToConvert.recordCount )# Member Groups...

#cho_id#:#htmleditformat( cho_name )# - #lsnumberformat( qmd_1fsMembersToConvert.recordCount )# members

#htmleditformat( cho_name )#

update tbl_OPR_CLientOperators set crmActive = 'Y', crmActiveDate = where ownerId = and fsltablecode = 'CHO' and operatorId=

#htmleditformat( unit_cho_name )#

update tbl_OPR_CLientOperators set crmActive = 'Y', crmActiveDate = where ownerId = and fsltablecode = 'CHO' and operatorId= select operatorId, oprCompanyType, companyName, crmActive, crmActiveDate, recordSource, independentYN from tbl_OPR_CLientOperators with (nolock) where ownerId = and fsltablecode = 'CHO' order by operatorId select oprCompanyType, independentYN, count(*) operatorRecords from qmd_operators group by oprCompanyType, independentYN