INSERT INTO zjz.dbo.employee
(employee_code,technical_post, duty, name, sex, id_card, birthday,nation, speciality, graduate_college,
cultrue_level)
SELECT No_Staff,Title, Duty, StaffName, CASE Sex WHEN '男' THEN '1' ELSE '2' END AS sex,
IdentityCode, BirthDate,'0001', Specialty, GraduateSchool, CASE Education WHEN '硕士' THEN '0002' WHEN '本科' THEN '0003' WHEN '专科' THEN '0004' WHEN '大专' THEN '0004' WHEN '初中' THEN '0007' WHEN '高中' THEN '0006' ELSE '0005' END AS Education
FROM newjt.dbo.staff
(employee_code,technical_post, duty, name, sex, id_card, birthday,nation, speciality, graduate_college,
cultrue_level)
SELECT No_Staff,Title, Duty, StaffName, CASE Sex WHEN '男' THEN '1' ELSE '2' END AS sex,
IdentityCode, BirthDate,'0001', Specialty, GraduateSchool, CASE Education WHEN '硕士' THEN '0002' WHEN '本科' THEN '0003' WHEN '专科' THEN '0004' WHEN '大专' THEN '0004' WHEN '初中' THEN '0007' WHEN '高中' THEN '0006' ELSE '0005' END AS Education
FROM newjt.dbo.staff
update A set A.team_id=B.team_id from employee A,(SELECT employee.employee_id, team.team_id
FROM newjt.dbo.Staff INNER JOIN
employee ON newjt.dbo.Staff.No_Staff = employee.employee_code INNER JOIN
team ON newjt.dbo.Staff.WorkUnit = team.team_cn_name) B where A.employee_id = B.employee_id
FROM newjt.dbo.Staff INNER JOIN
employee ON newjt.dbo.Staff.No_Staff = employee.employee_code INNER JOIN
team ON newjt.dbo.Staff.WorkUnit = team.team_cn_name) B where A.employee_id = B.employee_id