Hi Stephen,
You cannot drop them but why are you creating them in the first place? Anyway you cannot use them inside stored procedure.
>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
--sb--