1.查询数据库
select * from t_org_admin org where 1=1
and org.FIsSealUp=0
and org.FIsOUSealUp =0
and org.FIsLeaf=0
and org.FResponPositionID is not null;
2.备份
此备份在EAS查询分析器执行;
select * into dml_t_org_admin_180119 from t_org_admin org where 1=1
and org.FIsSealUp=0
and org.FIsOUSealUp =0
and org.FIsLeaf=0
and org.FResponPositionID is not null;
3.将不为空的部门负责人设置为空;
可以手工处理,将FResponPositionID此字段值的单元格的内值删掉即可;
脚本处理:
update t_org_admin set FResponPositionID='' where fid in (select fid from t_org_admin org where 1=1and org.FIsSealUp=0
and org.FIsOUSealUp =0
and org.FIsLeaf=0
and org.FResponPositionID is not null)
即可;