Converte procedure para tabela

Converte procedure para tabela.sql

DECLARE @NomeProcedure VARCHAR(200)= 'Nome da Tabela',
    @NomeSchema VARCHAR(200)= 'dbo'

DECLARE @SqlProcedure VARCHAR(MAX)= '',
    @Sql VARCHAR(MAX)= ''
SELECT  @SqlProcedure += ', ' + PARAMETER_NAME + ' = ' + CASE DATA_TYPE
                                                           WHEN 'datetime'
                                                           THEN '''' + CONVERT(VARCHAR(10), GETDATE(), 120) + ''''
                                                           WHEN 'int' THEN '0'
                                                           ELSE 'NULL'
                                                         END
FROM    information_schema.parameters
WHERE   SPECIFIC_NAME = @NomeProcedure
ORDER BY ORDINAL_POSITION

SET @SqlProcedure = @NomeSchema + '.' + @NomeProcedure + ' ' + STUFF(@SqlProcedure, 1, 2, '')


SELECT  @Sql += ', ' + name + ' ' + system_type_name
FROM    sys.dm_exec_describe_first_result_set_for_object(OBJECT_ID(@NomeSchema + '.' + @NomeProcedure), NULL)

SELECT  'DECLARE @Tabela TABLE (' + STUFF(@Sql, 1, 2, '') + ') INSERT  INTO @Tabela '
UNION ALL
SELECT  'EXEC ' + @SqlProcedure
UNION ALL
SELECT  '; SELECT * FROM @Tabela'