Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP-SQL translation
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00749711
Message ID:
00749944
Views:
33
This message has been marked as a message which has helped to the initial question of the thread.
>Thanks, Sergey. I'm going to use ADO. When I do a seria of selects in SQL Server, should it be written as SP?
>My first select should return matching records ID and the next select will return the actual result. So, where should I put the first select?


First, there's no such word as "seria". <eg>
Second, I would use sproc's regardless if it's one select or T-SQL batch for reasons of performance and security.
Third, the only way to use result of separate query from another is to create a temp. table. It's not recomended for performance reason. Instead you can use result of the first query as derived table in the second query which makes it a one select.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform