UPDATE "Chaidhanan"."dbo"."hack_test"
SET "dte" = CASE
WHEN concat(x,y) = '10' THEN '2018-10-01'
WHEN concat(x,y) = '20' THEN '2018-10-02'
ELSE "dte" END
WHERE concat(x,y) IN('10','20')
UPDATE tb_whs_countDT2
SET cDT_amount = CASE
WHEN (cDT_reference = '16' AND cDT_plucode = '8850021882213') THEN '111'
WHEN (cDT_reference = '16' AND cDT_plucode = '8850028305111') THEN '222'
ELSE cDT_amount
END
,cDT_empcode = CASE
WHEN (cDT_reference = '16' AND cDT_plucode = '8850021882213') THEN '2100'
WHEN (cDT_reference = '16' AND cDT_plucode = '8850028305111') THEN '2100'
ELSE cDT_empcode
END