Hi Cetin,

Yes, this table can be huge, It has come close to the 2GB limit in vfp. I will have more information hopefully late this week as I start working with program and data.

>>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.