Support #710
Cập nhật curvalue sys_codemaster
Start date:
12/07/2020
Due date:
% Done:
0%
Estimated time:
Description
SELECT TOP 1 PLAN_ID FROM dbo.PL_MASTER WHERE PLAN_ID NOT LIKE '%I%' ORDER BY PLAN_ID DESC
SELECT TOP 1 TRADE_ID FROM dbo.PL_TRADEDETAIL WHERE TRADE_ID NOT LIKE '%I%' ORDER BY TRADE_ID DESC
UPDATE dbo.SYS_CODEMASTERS SET CurValue= WHERE Prefix='PLM'
UPDATE dbo.SYS_CODEMASTERS SET CurValue= WHERE Prefix='PLT'
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed
- Assignee set to Luc Tran Van