|
1
|
UPDATE ASS_GROUP SET DVCM_ID = 'DEP000000000027' WHERE GROUP_ID IN (SELECT VALUE FROM STRING_SPLIT('ASG000000000001,ASG000000000002,ASG000000000003,ASG000000000004,ASG000000000012,ASG000000000142,ASG000000000143,ASG000000001295,ASG000000001297,ASG000000001298,ASG000000001304,ASG000000001317,ASG000000001318,ASG000000001380,ASG000000001381,ASG000000001382,ASG000000001383,ASG000000001384,ASG000000001387,ASG000000001390,ASG000000001391,ASG000000001394,ASG000000001414,ASG000000001415,ASG000000001416,ASG000000001417,ASG000000001418,ASG000000001420,ASG000000001421,ASG000000001425,ASG000000001426,ASG000000001427,ASG000000001428,ASG000000001429,ASG000000001430,ASG000000001445,ASG000000001446,ASG000000001473,ASG000000001474,ASG000000001475,ASG000000001476,ASG000000001477,ASG000000001478,ASG000000001479,ASG000000001480,ASG000000001481,ASG000000001482,ASG000000001502,ASG000000001503,ASG000000001504,ASG000000001505,ASG000000001506,ASG000000001511,ASG000000001512,ASG000000001513,ASG000000001514,ASG000000001515,ASG000000001516,ASG000000001517,ASG000000001518,ASG000000001523,ASG000000001524,ASG000000001525,ASG000000001532,ASG000000001533,ASG000000001534,ASG000000001539,ASG000000001540,ASG000000001541,ASG000000001544,ASG000000001545,ASG000000001549,ASG000000001550,ASG000000001551,ASG000000001557,ASG000000001579,ASG000000001580,ASG000000001585,ASG000000001586,ASG000000001587,ASG000000001588,ASG000000001589,ASG000000001590,ASG000000001591,ASG000000001592,ASG000000001593,ASG000000016198,ASG000000017008,ASG000000017010,ASG000000017012,ASG000000017015,ASG000000017017,ASG000000017043,ASG000000017044,ASG000000017045,ASG000000017053,ASG000000017063,ASG000000017107,ASG000000017108,ASG000000017110,ASG000000017117,ASG000000017118,ASG000000017119', ','))
|