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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: paraglidersd
- Content: Threads
- Order by date
-
Getting first row
I looked this up online, but all of the discussed techniques didnt work. I am using Sybase. I have a stored procedure. I want to run a query on a table that has millions of rows. I expect that my query (with some criteria) will return hundreds of possible answers. I only want the FIRST one...- paraglidersd
- Thread
- Replies: 5
- Forum: Sybase: Adaptive (SQL) Server
-
temp table traversal in stored procedure
m pretty inexperienced when it comes to sql, but I am an experienced engineer. Want to create a stored procedure. Within that procedure I am going to create a temp table with certain attributes read in from 2 other permanent tables. After that, within the stored procedure, I want to read the...- paraglidersd
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
-
temp table in stored procedure
am pretty inexperienced when it comes to sql, but I am an experienced engineer. Want to create a stored procedure. Within that procedure I am going to create a temp table with certain attributes read in from 2 other permanent tables. After that, within the stored procedure, I want to read the...- paraglidersd
- Thread
- Replies: 4
- Forum: ANSI_SQL
