sql - Combine results from different procedures into a single table -

what wanted: want execute procedure each distinct entry in table , display result in single table.

what did:

declare @sql varchar(max)='' select @sql = @sql + ' exec proc1 ' + convert(nvarchar(50),s1.product) + ';'        (select distinct(s2.product) product sales s2) s1; exec (@sql) 

what problem is: returns me n number of tables, n being number of distinct entries in table. how union of them?

i solved it. thank everyone.

declare @sql varchar(max)='declare @temptable table (product nvarchar(50) ); ' select @sql = @sql + 'insert @temptable exec proc1 ' + convert(nvarchar(50),s1.product) + ';'  (select distinct(s2.product) product sales s2) s1; set @sql = @sql + 'select * @temptable'; exec (@sql)