select portal_ownerType, portal_ownerId
from fsenablers..tbl_CUS_Websites with (nolock)
where portal_name is not null
and portal_type = 'MFR'
order by portal_ownerType, name asc
select ownerId, fsltablecode, operatorId
from tbl_OPR_ClientOperators with (nolock)
where ownerId =
and fsltablecode =
and ( ( oprcompanytype = '1' and independentYN = 0 ) or oprcompanytype = 'C' )
and buyingDecisions = 'N'
update tbl_OPR_ClientOperators
set buyingDecisions = 'Y'
where ownerId =
and fsltablecode =
and operatorId =
COMPLETE