• try this method

    Declare @OutputParameter Datatype

    EXEC StoredProcedurename

    ParameterValue1,

    ParameterValue2,..ParameterValue3,

    @OutputParameter OUTPUT

    Select @OutputParameter