Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UNION SELECT... please correct me
Message
From
31/10/1998 11:31:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
30/10/1998 18:52:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00150818
Message ID:
00153174
Views:
24
>Assuming you have unique prices...
>
>Vlad
>
>>For performance gain I think I would first do two seek() on the price, with set near on and once with ascending tag then descending tag, get the two price values, then execute one SQL using between.
>>Cetin
No not assuming. If assumed like that, then would just scatter the two records :) I think TOP approach assumes it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform