you will need to add a return to your stored procedure. So when the procedure runs it will return a value. This can be static of a value from the TSQL you run in your stored procedure.
Check this link for more info <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-2017"></a>