updateHR_USER_ZSJ_推广_oksetlogin_name=fn_getpy_1(名称)||'@'|| (casewhen newoulike'%潮州供电局%'then'cz.gd.csg.cn'when newoulike'%东莞供电局%'then'dg.gd.csg.cn'whennewoulike'%佛山供电局%'then'fs.gd.csg.cn'when newoulike'%河源供电局%'then'hy.gd.csg.cn'whennewoulike'%惠州供电局%'then'hz.gd.csg.cn'when newoulike'%江门供电局%'th

selectname,login_name,fn_getpy_1(name),fn_getpy_1(case wheninstr(name,'曾')>0thenREPLACE(name,'曾','zeng') wheninstr(name,'兴')>0thenREPLACE(name,'兴','xing') wheninstr(name,'毛')>0thenREPLACE(name,'毛','mao') wheninstr(name,'仇')>0thenREPLACE(name,'仇','mao') elsenameend)||substr(login_

select*fromisc_userwherenamecodelike'%qy.gd.csg.cn%' select*fromtmp_yx_user_0401 isc_usert.NAMECODE hr_user_qy0331_okLOGIN_NAMEisnotnull/*5334*/ select*fromtmp_yx_user_0401_qy_login_name; select*fromhr_user_qy0331_ok; CREATETABLEtmp_yx_user_qy_0403as( selecty.*,h.员工id,h.ouASHROU,h.员工所属

selectc.*,fn_getpy(c_name)||'@'|| (casewhennewoulike'%潮州%'then'cz.gd.csg.cn'when newoulike'%东莞%'then'dg.gd.csg.cn'whennewoulike'%佛山%'then'fs.gd.csg.cn'when newoulike'%河源%'then'hy.gd.csg.cn'whennewoulike'%惠州%'then'hz.gd.csg.cn'when newoulike'%江门%'then'jm.gd.csg.cn'whennewoulike'%揭阳%'then'jy.gd