none
SqlDataAdapter vs Temporary Table RRS feed

  • Question

  • Hello everybody

    I'm having trouble trying to fill a DataTable using a DataAdapter, which calls a procedure that uses a temporary table.

    I have two SPs. The first one process some data, generate a public temporary table (##MyTable) and then returns some results. The second procedure needs the temporary table created by the first one in order to do its processing and return the results, but it can't find the temporary table.

    This problem only occurs when I'm using a DataAdapter. If I run the queries in Query Analyzer, for example, it works well.

    Any ideas?

    Thanks in advance.
    Thursday, June 12, 2008 2:27 PM

All replies

  • If you need the data constantly, you'd better make it permant? And clear the data instead of dropping it. It would avoid the problem.

     

    Monday, June 16, 2008 11:01 AM