Lấy data hợp đồng.txt
| 1 |
declare @REQ_DOC_ID VARCHAR(15)='', @PL_REQ_ID VARCHAR(15)='' |
|---|---|
| 2 |
SET @REQ_DOC_ID = (select top(1) REQ_DOC_ID from TR_CONTRACT where CONTRACT_ID = 'TRC000000254168') |
| 3 |
SET @PL_REQ_ID = (select TOP(1) PL_REQ_ID from TR_REQUEST_DOC WHERE REQ_ID = @REQ_DOC_ID) |
| 4 |
SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID = @REQ_DOC_ID |
| 5 |
SELECT * FROM TR_CONTRACT WHERE CONTRACT_ID = 'TRC000000254168' |
| 6 |
SELECT * FROM TR_CONTRACT_DT WHERE CONTRACT_ID = 'TRC000000254168' |
| 7 |
select * from PL_REQUEST_DOC WHERE REQ_ID = @PL_REQ_ID |
| 8 |
select * from PL_REQUEST_DOC_DT WHERE REQ_ID = @PL_REQ_ID |
| 9 |
select * from PL_TRADEDETAIL TRADE WHERE EXISTS(Select * from PL_REQUEST_DOC_DT DT WHERE REQ_ID = @PL_REQ_ID AND DT.TRADE_ID = TRADE.TRADE_ID) |