Project

General

Profile

Download (445 Bytes)

Lấy data DGNCC.txt

Luc Tran Van, 05/04/2023 03:56 PM

 
1 
DECLARE @rate_id varchar(15) =''
2 
SELECT @rate_id= trsm.RATE_ID FROM TR_RATE_SUPPLIER_MASTER trsm WHERE trsm.RATE_REQ_NO='000010/2023/PĐG-0690604'
3 
SELECT * FROM TR_RATE_SUPPLIER_MASTER trsm WHERE trsm.RATE_REQ_NO='000010/2023/PĐG-0690604'
4 
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @rate_id
5 
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT id FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = @rate_id)