As per maciaj
i think use left join instead of inner join
UPDATE t1 SET t1.Reporting_manager_id = t2.Eid
FROM Employee AS t1 LEFT JOIN Employee AS t2 ON t1.Employee_name = t2.Reporting_manager
because in employee table some record manager has null so it's not including in result so.......
I hope its helps
Thanks
uttam