Lấy data PYCMS PUR-2023-000287.txt
| 1 |
SELECT * FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287' |
|---|---|
| 2 |
SELECT * FROM TR_REQUEST_DOC_DT trdd WHERE trdd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287') |
| 3 |
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287') |
| 4 |
DECLARE @RECORD_ID VARCHAR(50) |
| 5 |
SELECT @RECORD_ID = trdxmm.RECORD_ID FROM TR_REQ_DOC_XETGIA_100M_500M trdxmm WHERE trdxmm.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd where trd.REQ_CODE = 'PUR/2023/000287') |
| 6 |
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_DGC trdxmmdd WHERE trdxmmdd.RECORD_MASTER_ID = @RECORD_ID |
| 7 |
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_DT_XG trdxmmdx WHERE trdxmmdx.RECORD_MASTER_ID = @RECORD_ID |
| 8 |
SELECT * FROM TR_REQ_DOC_XETGIA_100M_500M_XH trdxmmx WHERE trdxmmx.RECORD_MASTER_ID = @RECORD_ID |