DECLARE @BRANCH_ID VARCHAR(20),@DEP_ID VARCHAR(20),@REQ_CODE VARCHAR(20) SELECT @BRANCH_ID=TLSUBBRID,@DEP_ID=SECUR_CODE FROM dbo.TL_USER WHERE TLNANME='oanhpl2' EXEC dbo.PL_REQUEST_DOC_CODE_GenKey @p_BRANCH_ID = @BRANCH_ID, -- varchar(50) @p_DEP_ID = @DEP_ID, -- varchar(100) @p_KeyGen = @REQ_CODE OUTPUT -- nvarchar(100) SELECT @REQ_CODE