With Links AS ( select do.number [DONumber], do.copy_name [DOCopyName], do.sequence [DOSeq], cc.number [CompanyNumber], ccl.upstream_division_order_anchor_id [CCLDOAnchor], ccl.contract_anchor_id [CCLContractAnchor], ccl.upstream_ownership_cycle_id [cycleID], ccl.from_date [CCLFrom], ccl.to_date [CCLTo], uoc.revenue [RevCycle], uoc.jib [JIBCycle] from upstream_ownership_cycle_contract_links ccl JOIN upstream_division_orders do on ccl.upstream_division_order_anchor_id = do.anchor_id JOIN upstream_ownership_cycles uoc on ccl.upstream_ownership_cycle_id = uoc.id JOIN company_codes cc on do.company_code_id = cc.id where (ccl.contract_anchor_id is NULL OR ccl.contract_anchor_id = ' ') and do.to_date = '9999-12-31' and do.copy_name IN ('original', 'archived')), LinksJIB AS ( select [DONumber], [DOCopyName], [DOSeq], [CompanyNumber], [CCLDOAnchor], [CCLContractAnchor], [cycleID], [CCLFrom], [CCLTo], [RevCycle], [JIBCycle], loi.from_date, loi.to_date, loi.contract_override, loi.contract_anchor_id [goodanchor], c.number, c.name from Links l1 left JOIN upstream_lines_of_interest loi on l1.cycleID = loi.upstream_ownership_cycle_id JOIN contracts c on loi.contract_anchor_id = c.anchor_id where loi.contract_override = 0 and contract_anchor_id is not null and contract_anchor_id <> ' ' and l1.JIBCycle = 1 and c.name LIKE '%JIB%' ) update LinksJIB set CCLContractAnchor = goodanchor