Bug #1604
30062025
Status:
New
Priority:
Normal
Assignee:
-
Start date:
06/30/2025
Due date:
% Done:
0%
Estimated time:
History
#1 Updated by Luc Tran Van about 1 month ago
UPDATE CM_PRICE_BANK set RECORD_STATUS = '0'
WHERE CREATE_DT >= CAST
AND ( REFERENCE_PRICE = 0 OR REFERENCE_PRICE is NULL )
AND ( FATHER_ID = ( SELECT cpb.PRICE_BANK_ID FROM CM_PRICE_BANK cpb WHERE cpb.PRICE_BANK_NAME = N'Nạp mực'))
AND FATHER_ID is NOT NULL