ALTER PROCEDURE USP_BOARD_INSERT
 -- Add the parameters for the stored procedure here
   @table varchar(50)
 , @thread int
 , @type char(1)
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

 -- Insert statements for procedure here
 DECLARE @sql varchar(8000)
 
 SET @sql =        'INSERT INTO ' + @table
 SET @sql = @sql + '     ( thread, depth, type)'
 SET @sql = @sql + 'SELECT ISNULL(MAX(thread),0)+100'
 SET @sql = @sql + '     , 0'
 SET @sql = @sql + '     , ''' + @type + '''' -- T or H
 SET @sql = @sql + '  FROM ' + @table

 EXEC(@sql)

-- SET @sql =        'SELECT MAX(thread) AS thread' -- 이 방법은 싫어요.
-- SET @sql = @sql + '  FROM ' + @table
-- EXEC(@sql)

위와 같은 구문이 있는데요.  INSERT 구문상의 ISNULL(MAX(thread),0)+100 값을 리턴값으로 받고자하는데 방법이 없나요?