泛微OA清理人员抄送待办

创建查询，链接ecology数据库，解决人员ID为6的抄送数据

--1。备份wf_curr0724bak自定义

select * into wf_curr0724bak  from workflow_currentoperator

--2查询  替换userid
select * 
from workflow_currentoperator a where isremark in (8,9)  and isremark in (8,9) and isLastTimes=1 and userid=6 

--3--更新 
update a set a.isremark=2,viewtype=-2
from workflow_currentoperator a where isremark in (8,9)   and isremark in (8,9) and isLastTimes=1 and userid=6