select skopr.operatorId, skparent.operatorId oprParentCo from tbl_OPR_ClientOperators opr inner join tbl_OPR_ClientOperators skopr on skopr.recordSource = 'M:4441;B:14;O:' + convert( varchar, opr.operatorId ) and skopr.ownerId = 4441 and skopr.fsltablecode = 'MFR' inner join tbl_OPR_ClientOperators skparent on skparent.recordSource = 'M:4441;B:14;O:' + convert( varchar, opr.oprParentCo ) and skparent.ownerId = 4441 and skparent.fsltablecode = 'MFR' where opr.ownerId = 14 and opr.fsltablecode = 'BRO' and opr.crmActive = 'Y' and opr.oprCompanyType = '0' and opr.oprParentCo > 0 update tbl_OPR_ClientOperators set oprParentCo = where operatorId = and ownerId =4441 and fsltablecode = 'MFR'