DECLARE @AMORT_ID VARCHAR(15)
SET @AMORT_ID =(SELECT TOP 1 AMORT_ID FROM ASS_AMORT WHERE AMORT_TERM ='2/2021')
SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMT) AS GT_KHAU_HAO FROM ASS_ENTRIES_POST WHERE TRN_ID =@AMORT_ID
SELECT * FROM ASS_AMORT WHERE AMORT_ID =@AMORT_ID
SELECT COUNT(*) AS SO_LUONG_TS, SUM(AMORT_AMT) AS GT_HACH_TOAN FROM ASS_AMORT_DT WHERE AMORT_ID =@AMORT_ID