pauledwardian
asked on
SQL Update Querry
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER