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'