SELECT A.REQ_PAY_CODE,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
A.MAKER_ID_KT AS GDV,
CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
A.CHECKER_ID_KT AS KSV, 
CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET 
FROM TR_REQ_PAYMENT A
WHERE 1=1
AND ((A.TRANSFER_DT >='2022-7-1' AND A.TRANSFER_DT <='2022-12-31')
OR (A.CREATE_DT_KT >='2022-7-1' AND A.CREATE_DT_KT <='2022-12-31')
OR (A.APPROVE_DT_KT >='2022-7-1' AND A.APPROVE_DT_KT <='2022-12-31'))
AND A.AUTH_STATUS ='A'

UNION

SELECT A.REQ_PAY_CODE,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2)  AS NGAY_NHAN_PHIEU,
A.MAKER_ID_KT AS GDV,
CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
A.CHECKER_ID_KT AS KSV, 
CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET 

FROM TR_REQ_ADVANCE_PAYMENT A
WHERE 1=1
AND ((A.TRANSFER_DT >='2022-7-1' AND A.TRANSFER_DT <='2022-12-31')
OR (A.CREATE_DT_KT >='2022-7-1' AND A.CREATE_DT_KT <='2022-12-31')
OR (A.APPROVE_DT_KT >='2022-7-1' AND A.APPROVE_DT_KT <='2022-12-31'))
AND A.AUTH_STATUS ='A'

---202297
---202298