>Hi,
>Thank you. What if there are alot of customers?
1. Create a Stored Procedure in SQL to retrieve an XML file of customer ID's and return the order records for those customers.
2. Create temp table of cust_ids and join to the temp table.
>Again, what should I do if I want to join one VFP table and one SQL server table?
Well, 'normall' you can't. However, you could create a linked server in your SQL server... this will allow you to query the Foxdata through the SQL server and also write queries that work with both.
>Am I need to download the whole sql server table first then only can join them?
That will work, but I would try to avoid this...
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement