I have to add footnote marks to a table before printing. PITA, and it's one big cursor that I have done.

Anyway there are 20-100 selects done as we perk through the cursor.

I have the data in #t1 and the final line of the SP is :
Select * from #t1

In my C# call for data into a dataset, I see tables for each one of those 20-100 selects?

I understand where they come from, how do I drop them out in SQL Server before it hit's my C# ds?

TIA