料號升級,工時資料複製作業

来源:互联网 发布:5元已备案域名 编辑:程序博客网 时间:2024/06/06 03:03

SELECT * FROM CPS.MTL_UPH WHERE MTL_NO LIKE '70200312%'

INSERT INTO CPS.PRODUCT_INFO
SELECT '70200312A2',DEPT_ID,MTL_MODEL,MTL_CUST,MTL_SET,SET_NO,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_INFO WHERE MTL_NO='70200312A0'

INSERT INTO CPS.PRODUCT_PROCE
SELECT '70200312A2',SEQ_NO,PROCE_NO,SEQ_DESC,STATUS_NO,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_PROCE WHERE MTL_NO='70200312A0'

INSERT INTO CPS.PRODUCT_EQUIP
SELECT '70200312A2',SEQ_NO,TYPE_NO,CAV_QTY,CT_TIME,INSD_CNT,OUSD_CNT,START_DATE,END_DATE,OPT_STATION,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_EQUIP WHERE MTL_NO='70200312A0'