I need a SQL store procedure that would look into two tables and use the 1st table as the source and the 2nd table as the target.
It needs to update the 2nd table info based on the 1st tabe data. Please look at this screenshot:
For instance in this screenshot I need to use the ceredian table to update the data in EmployeeLogin Table. I need a store procedure that would update the EmployeeLogin Department and Position for each employee. The common column between these two table is employee Number.