I return 30 tables or so from sql in a stored procedure.
In the stored procedure I select these tables via...
select * from myTable1
select * from myTable2
select * from myTable3
etc.
These tables lose their sql table name when returned in a dataset and have default names of Table, Table1, Table2 etc.
So how do I identify a particular table out of the now 30 'random' tables in my dataset.
Thank you.