You didn't provide much details on what you're trying to do. Maybe you don't need a temp table at all.

>Thanks for your link.
>
>From what I understand, there will be some preparatory work for creating the stored procedure on SQL Server and once created the thing becomes easy from VFP?
>
>I don't know if I will get the permission to modify the SQL Server database manually (as number of databases at various clients site will requrie the manual update). Can all of this be done from VFP?