update T_PM_ConMeasureDetailtem set itemid=b.id
from T_PM_ConMeasureDetailtem o,(select id,billdetailid from T_PM_ConChangeNoteDetail) as b
where o.itemid=b.billdetailid and SUBSTRING(o.itemid,1,2)='8' and o.type='1'
from T_PM_ConMeasureDetailtem o,(select id,billdetailid from T_PM_ConChangeNoteDetail) as b
where o.itemid=b.billdetailid and SUBSTRING(o.itemid,1,2)='8' and o.type='1'
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
