Support #938
Cập nhật mã phòng ban tạo phiếu nhập kho Tài Sản : ASA000000254463
Start date:
03/08/2021
Due date:
% Done:
0%
Estimated time:
Description
SELECT * FROM TL_USER WHERE TLNANME ='sontv1'
SELECT * FROM ASS_ADDNEW WHERE ADDNEW_ID ='ASA000000254463'
DECLARE @DEP_ID VARCHAR
SET @DEP_ID =(SELECT TOP 1 SECUR_CODE FROM TL_USER WHERE TLNANME ='sontv1')
UPDATE ASS_ADDNEW SET DEPT_ID =@DEP_ID WHERE ADDNEW_ID ='ASA000000254463'
History
#1 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed