|
|
Posted by Larry Linson on 11/14/77 11:29
"Neil" <nospam@nospam.net> wrote
> The machine name changing isn't an issue,
> since these selections are temporary -- maybe
> a few hours or overnight at the most. They're not
> permanent entities.
How about constructing the T-SQL update Query in code and using it as a
Passthrough Query, or creating a Stored Procedure to which you pass
parameters, or, indeed, just creating a Jet query based on information from
the local table, but that does not Join to the local table -- one of these
approaches might avoid the delays, which are, as you pointed out, due to
using a heterogeneous join.
Navigation:
[Reply to this message]
|