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