Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server version of DLookup

Status
Not open for further replies.
ksbigfoot

ksbigfoot

Programmer
Apr 15, 2002
856
CA
I wonder if there is SQL Server version of DLookup?
In my SQL statement, I have embedded a dLookup and it is very fast when I run against Access tables. But as soon as I run it against linked tables to SQL Server, it seems like SQL Server returns all rows and it is very slow.

Thanks

 
Sort by date Sort by votes
Have a look at sub queries in the help

Chance,

Filmmaker, taken gentleman and crunch day + 22
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
feipezi
  • Locked
  • Question
Do we have a VBS version of listing files in a folder?
Replies
2
Views
337
strongm
strongm
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
1K
Katto
Katto
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
540
Andrzejek
Andrzejek
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top