set a value by excuting stored procedure
// Call to the stored procedure, with an OUTPUT parameter
DECLARE @OutputParameter datetime
,@ReturnValue int
EXEC @ReturnValue= [YourStoredProcedure] [comma separated parameters if any] @OutputParameter OUTPUT
PRINT(@ReturnValue)