SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function | Journey to SQL

Hi Sharan, What you need to do is. You have to add one OUTPUT parameter to your Stored Procedure as: CREATE PROC Myprocedure @Value INT OUT AS SELECT @Value = 1. Now you need to execute this SP from any query/SP as: DECLARE @OutValue ...

blog.sqlauthority.com