>Here's the scenario... we are moving a group of tables to a sql server that are part of a large vfp system (the tables are approaching 2gb limit). There will be tables in a VFP database and tables in the sql server database used together.
>
>We are thinking of creating a stored procedure to return all records based on a list of keys created in the front end from the vfp database. The problem is how to get the temp table (in sql) populated the most efficient way. The list of keys could be in the thousands.
>
>How would you upload the data to the server from vfp? This is not static... it would be done whenever needed in the vfp application.

Maybe you can use XML as suggested by Michael Levy in Pass an Array as a parameter to a SP? Thread #638389 Message #638643.