sql server - Populate Dataset With Table Names From Stored Procedure

Question

I have a stored procedure that returns multiple tables.

It populates my dataset correctly but it names my tables [Table,Table1,Table2,...].

Is there something I can add in the database layer (to my stored procedure) that will name the tables properly?

Answer 1

Your SP is not actually returning multiple tables, its returning a selection of columns and rows from your tables, therefore there is no 'table name', and hence why they are named table1, table2 etc. If its important, you could return an extra column for each selection, and in that column fill it with the desired name and then use it from there.

i.e.

   select *,'MyTableName1' As [TableName] name from mytablename1
   select *,'MyTableName2' As [TableName] name from mytablename2