DECLARE @listTRADE_TRANSFER TABLE ( GOODS_ID VARCHAR(20), TRADE_ID VARCHAR(20), PLAN_ID VARCHAR(20), AMT_APP DECIMAL(18,2), AMT_EXE DECIMAL (18,2), AMT_ETM DECIMAL (18,2), AMT_TF DECIMAL (18,2), AMT_RECEIVE_TF DECIMAL (18,2) ) INSERT INTO @listTRADE_TRANSFER SELECT DISTINCT TO_GOOD_ID, TO_TRADE_ID,TO_PLAN_ID,TO_AMT_APP,TO_AMT_EXE, TO_AMT_ETM, TO_AMT_TF, TO_AMT_RECEIVE_TF FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000207183' SELECT * FROM @listTRADE_TRANSFER EXEC rpt_PL_REQUEST_DOC_DT_ById 'PLRD00000207183'