update_branch_dep_code_dvcm.txt
| 1 |
UPDATE E SET E.BRANCH_CODE = '0500', E.DEP_CODE = D.DEP_CODE |
|---|---|
| 2 |
FROM TL_USER A |
| 3 |
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId |
| 4 |
LEFT JOIN AbpRoles C ON B.RoleId = C.Id |
| 5 |
LEFT JOIN CM_DEPARTMENT D ON A.DEP_ID = D.DEP_ID |
| 6 |
LEFT JOIN CM_EMPLOYEE_LOG E ON A.TLNANME = E.USER_DOMAIN |
| 7 |
WHERE C.DisplayName = 'DVCM' |