SELECT ADDNEW_ID AS MA_SO_PHIEU, MAKER_ID_KT AS GDV, CHECKER_ID_KT AS KSV, '' AS NOI_DUNG,
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_DIEU_PHOI, 
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
FROM ASS_ADDNEW A
WHERE	(	CONVERT(DATE, CREATE_DT_KT) < '2022-12-31 23:55:51.610' 
			AND CONVERT(DATE, CREATE_DT_KT) > '2022-12-01 00:55:51.610'
		)
		AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
UNION
SELECT USER_MASTER_ID AS MA_SO_PHIEU, MAKER_ID_KT AS GDV, CHECKER_ID_KT AS KSV, '' AS NOI_DUNG,
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_DIEU_PHOI, 
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
FROM dbo.ASS_USE_MULTI_MASTER
WHERE	(	CONVERT(DATE, CREATE_DT_KT) < '2022-12-31 23:55:51.610' 
			AND CONVERT(DATE, CREATE_DT_KT) > '2022-12-01 00:55:51.610'
		)
		AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
UNION
SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, MAKER_ID_KT AS GDV,CHECKER_ID_KT AS KSV, '' AS NOI_DUNG,
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_DIEU_PHOI, 
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
FROM dbo.ASS_TRANSFER_MULTI_MASTER
WHERE	(	CONVERT(DATE, CREATE_DT_KT) < '2022-12-31 23:55:51.610' 
			AND CONVERT(DATE, CREATE_DT_KT) > '2022-12-01 00:55:51.610'
		)
		AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
UNION
SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, MAKER_ID_KT AS GDV,CHECKER_ID_KT AS KSV, '' AS NOI_DUNG,
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_DIEU_PHOI, 
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
FROM dbo.ASS_COLLECT_MULTI_MASTER
WHERE	(	CONVERT(DATE, CREATE_DT_KT) < '2022-12-31 23:55:51.610' 
			AND CONVERT(DATE, CREATE_DT_KT) > '2022-12-01 00:55:51.610'
		)
		AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
UNION
SELECT LIQ_ID AS MA_SO_PHIEU, MAKER_ID_KT AS GDV,CHECKER_ID_KT AS KSV, '' AS NOI_DUNG,
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_DIEU_PHOI, 
CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2)	+'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
FROM dbo.ASS_LIQUIDATION
WHERE	(	CONVERT(DATE, CREATE_DT_KT) < '2022-12-31 23:55:51.610' 
			AND CONVERT(DATE, CREATE_DT_KT) > '2022-12-01 00:55:51.610'
		)
		AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')

---202297