select opr.companyName as orgName, opr.operatorId as orgId, 'OPR' as orgType, 'OPR:' + cast( opr.operatorId as varchar ) as orgKey, opr.fsl_choId as oneFsId from tbl_OPR_ClientOperators opr with (nolock ) where opr.ownerId = and opr.fsltablecode = and opr.oprCompanyType in ( 'G', 'C' ) and opr.crmActive = 'Y' order by orgName for json auto, include_null_values