FILE 3.0 CHECK SO LIEU SAU KHI CHAY KHAU HAO.txt
| 1 |
DECLARE @AMORT_ID VARCHAR(15) |
|---|---|
| 2 |
SET @AMORT_ID =(SELECT TOP 1 AMORT_ID FROM ASS_AMORT WHERE AMORT_TERM ='2/2021') |
| 3 |
SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMT) AS GT_KHAU_HAO FROM ASS_ENTRIES_POST WHERE TRN_ID =@AMORT_ID |
| 4 |
SELECT * FROM ASS_AMORT WHERE AMORT_ID =@AMORT_ID |
| 5 |
SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMORT_AMT) AS GT_HACH_TOAN FROM ASS_AMORT_DT WHERE AMORT_ID =@AMORT_ID |