流程组人员的快速复制

--流程组人员的快速复制。
select * from filter where
moduleid ='flowgroup'
 and
filtertitle like '%阀门采购%'

--阀门替换
update filter set filtercontent=(select filtercontent from filter where filterid='1006')
where filterid='1116'
--重工替换
update filter set filtercontent=(select filtercontent from filter where filterid='1001')
where filterid='1114'
--气瓶替换
update filter set filtercontent=(select filtercontent from filter where filterid='1005')
where filterid='1115'
--撬装替换
update filter set filtercontent=(select filtercontent from filter where filterid='1022')
where filterid='1117'
--工程事业部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1065')
where filterid='1118'
--总部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1021')
where filterid='1120'

 

－－－－－－－－－－销售－－－－－－－－－－－－－

--阀门替换
update filter set filtercontent=(select filtercontent from filter where filterid='1004')
where filterid='1122'
--重工替换
update filter set filtercontent=(select filtercontent from filter where filterid='1002')
where filterid='1125'
--气瓶替换
update filter set filtercontent=(select filtercontent from filter where filterid='1003')
where filterid='1121'
--撬装替换
update filter set filtercontent=(select filtercontent from filter where filterid='1023')
where filterid='1124'
--工程事业部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1076')
where filterid='1118'
--总部替换
update filter set filtercontent=(select filtercontent from filter where filterid='1101')
where filterid='1126'