DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002858'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID = (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE = 'PUR/2022/002858')

UPDATE PL_REQUEST_DOC SET REQ_DT='2022-09-26' WHERE REQ_ID='PLRD00000205852'

UPDATE TR_REQUEST_DOC_DT SET
PRICE = TOTAL_AMT / QUANTITY
WHERE REQDT_ID = 'TRRDD0000278263'

SELECT cel.BRANCH_CODE, cel.DEP_CODE FROM CM_EMPLOYEE_LOG cel WHERE cel.USER_DOMAIN ='ngantth1'

SELECT tu.BRANCH_TYPE,tu.BRANCH_NAME,tu.SECUR_CODE,tu.DEP_ID FROM TL_USER tu WHERE tu.TLNANME ='ngantth1'

UPDATE TL_USER SET SECUR_CODE='DEP000000252472',DEP_ID='DEP000000252472' WHERE TLNANME ='ngantth1'

SELECT COUNT FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL
SELECT tu.TLNANME,tu.TLSUBBRID,tu.DEP_ID,tu.SECUR_CODE FROM TL_USER tu WHERE tu.DEP_ID IS NULL OR tu.SECUR_CODE IS NULL

UPDATE dbo.TL_USER SET IsActive =1

UPDATE PL_REQUEST_PROCESS SET DEP_ID='' WHERE ID='83812'
UPDATE PL_REQUEST_TRANSFER SET FR_DEP_ID='' WHERE REQ_TRANSFER_ID='PLRT00000216404'

UPDATE PL_REQUEST_PROCESS SET STATUS='U', CHECKER_ID='', APPROVE_DT= NULL, NOTES =N'Chờ giám đốc khối phê duyệt' WHERE ID='83754'

EXEC sp_helptext N'[dbo].[CON_REQUEST_DOC_InsXml]'