select o.operatorId, o.companyname, o.fsl_choId from tbl_OPR_ClientOperators o with(nolock) where o.FSLTableCode = and o.OwnerId = and o.operatorId = select o.operatorId, o.companyname from tbl_OPR_ClientOperators o with(nolock) where o.FSLTableCode = 'MSC' and o.OwnerId = 173 and o.companyName like SELECT o.OperatorID, o.CompanyName, o.OwnerID, o.FSLTableCode, recordOwner = CASE FSLTableCode WHEN 'BRO' THEN COALESCE( ( SELECT BROKER_NAME FROM tblBrokers with (nolock) WHERE BROKER_ID = o.OwnerID ), '' ) WHEN 'MFR' THEN COALESCE( ( SELECT MFR_NAME FROM tblManufacturers with (nolock) WHERE MFR_ID = o.OwnerID ), '' ) WHEN 'CHO' THEN COALESCE( ( SELECT CHO_NAME FROM tbl_CHO_Operators with (nolock) WHERE CHO_ID = o.OwnerID ), '' ) WHEN 'DST' THEN COALESCE( ( SELECT DSTNAME FROM tbl_DST_Distributors with (nolock) WHERE DSTID = o.OwnerID ), '' ) WHEN 'MSC' THEN COALESCE( ( SELECT COMPANY FROM tbl_MSC_FSLibraryUsers with (nolock) WHERE USERID = o.OwnerID ), '' ) ELSE '' END FROM tbl_OPR_ClientOperators o with (nolock) WHERE o.FSL_ChoID = AND o.OwnerID = AND o.fsltablecode =