Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 2005 Linked Server SLOW
Message
From
14/08/2006 17:46:05
 
 
To
14/08/2006 17:14:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01145359
Message ID:
01145452
Views:
21
WOAH!!! This worked in less than 1/2 second!!!

>
>On this way the SQL Server download the histcost table and filter it.
>
>uses OPENQUERY() for a VFP execution:
>
>SELECT * FROM OPENQUERY ( coss, 'SELECT * FROM histcost WHERE jobnum = "10424"')
>
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Reply
Map
View

Click here to load this message in the networking platform