FILE 1 - UPDATE CAPEX-OPEX.txt
1 |
UPDATE dbo.CM_GOODS SET GD_CODE=REPLACE(GD_CODE,'.CE.','.OE.') WHERE GD_ID IN |
---|---|
2 |
('GOO000001063542', |
3 |
'GOO000001063541', |
4 |
'GOO000001063747', |
5 |
'GOO000001063748', |
6 |
'GOO000001063549', |
7 |
'GOO000001063550', |
8 |
'GOO000001063559', |
9 |
'GOO000001063560', |
10 |
'GOO000001063169', |
11 |
'GOO000001063170', |
12 |
'GOO000001063533', |
13 |
'GOO000001063534', |
14 |
'GOO000001063536', |
15 |
'GOO000001063535') |