DECLARE @REQ_ID VARCHAR(20) SELECT @REQ_ID = REQUEST_TEMPLATE_ID FROM dbo.CM_REQUEST_TEMPLATE WHERE REPORT_NO = '000360/2023/TTr-0690604' EXEC dbo.CM_REQUEST_TEMPLATE_Back_date @p_REQUEST_TEMPLATE_ID = @REQ_ID, -- nvarchar(200) @p_REPORT_DT = '06/03/2023', -- varchar(20) @p_MAKER_ID = 'quanvta' -- varchar(25)