>Hi All,
>
>We are currently going through OLE db from VFP to SQL Server, and we create at a temporary table, insert lots of records into it, then running queries against the temporary table and other tables. The queries can be different every time, not static queries. This takes a lot of time for building the temporary table (30 - 45 mins).
>
>I think this can be done be done through SP, but we keep reading that as soon as you leave the SP, the temporary table is closed.
>
>Hope this is enough info.
>
>Any ideas?
>
>TIA
>Beth

If you create the temptable outside SP it wouldn't be closed. I don't know how SP would help you there. How many records are you inserting into temp table on the average? 30-45mins doesn't sound to be a reasonable timing. It may be with very huge tables but it may also be due to a wrong way of inserting records. I mean you can insert 10 records in 10 seconds or subsecond depending on how you do that.