目的: mdcg01 的 任务给 xuganghong
select count(*) from BPMInstTasks where owneraccount ='MDCG01'
结果集:556
select count(*) from bpminstProcsteps where owneraccount ='MDCG01'
结果集:1801
update BPMInstTasks set owneraccount ='xuguanghong' where taskid in
(select taskid from BPMInstTasks where owneraccount ='MDCG01')
update bpminstProcsteps set ownerAccount = 'xuguanghong' where taskid
in (select taskid from bpminstProcsteps where owneraccount ='MDCG01' ) and
stepid in(select stepid from bpminstProcsteps where owneraccount ='MDCG01' )
select count(*) from BPMInstTasks where owneraccount ='MDCG01'
结果集:556
select count(*) from bpminstProcsteps where owneraccount ='MDCG01'
结果集:1801
update BPMInstTasks set owneraccount ='xuguanghong' where taskid in
(select taskid from BPMInstTasks where owneraccount ='MDCG01')
update bpminstProcsteps set ownerAccount = 'xuguanghong' where taskid
in (select taskid from bpminstProcsteps where owneraccount ='MDCG01' ) and
stepid in(select stepid from bpminstProcsteps where owneraccount ='MDCG01' )