|
1
|
UPDATE ASS_MASTER SET GROUP_ID = 'ASG000000016196' WHERE ASSET_CODE IN (SELECT * from STRING_SPLIT('1407838_6,1407838_5,1407838_4,1407838_3,1407838_2,1407838_1,1399548_11,1399548_10,1399548_9,1399548_8,1399548_7,1407838_16,1407838_15,1407838_14,1407838_13,1407838_12,1407838_11,1407838_17,1399548_12,1407838_10,1407838_9,1407838_8,1407838_7,1399548_6,1399548_5,1399548_4,1399548_3,1399548_2,1399548_1,1400068,1372668,1407358,1407378,1400568,1365568,1365578,1365588,1401138,1399408,1399438,1399398,1399688,1401058,1396878,1369138,1399668,1400578,1358038,1358048,1400528,1400058,1400078,1400088',','))
|