Project

General

Profile

Feature #1471

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 28.03.2023

Added by Luc Tran Van about 2 years ago. Updated about 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
03/27/2023
Due date:
% Done:

0%

Estimated time:
check_holiday.txt (303 Bytes) check_holiday.txt Luc Tran Van, 03/28/2023 11:00 AM
update_db.txt (1.06 KB) update_db.txt Luc Tran Van, 03/28/2023 11:39 AM
create_stored.txt (52.1 KB) create_stored.txt Luc Tran Van, 03/28/2023 11:47 AM
TR_REQUEST_DOC_Search.txt (82.7 KB) TR_REQUEST_DOC_Search.txt Luc Tran Van, 03/28/2023 02:02 PM
DATA_#5.xlsx (10.6 KB) DATA_#5.xlsx Luc Tran Van, 03/28/2023 04:13 PM
payment_kt_search.txt (47 KB) payment_kt_search.txt Luc Tran Van, 03/28/2023 04:29 PM
Auto_Scan.txt (24.9 KB) Auto_Scan.txt Luc Tran Van, 03/28/2023 04:49 PM
rpt_PL_APP_CONTRACTOR_Template.txt (13 KB) rpt_PL_APP_CONTRACTOR_Template.txt Luc Tran Van, 03/28/2023 04:50 PM
update template TTCDT.txt (9.45 KB) update template TTCDT.txt Luc Tran Van, 03/28/2023 04:50 PM

History

#5 Updated by Luc Tran Van about 2 years ago

DECLARE @req_id varchar(20)
SELECT @req_id = trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000307'
SELECT * FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000307'
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID = @req_id

Also available in: Atom PDF