Search results for query: *

Yeah, we are kind of stuck here in a government controlled project. They tend to be behind on versions of a lot of software packages. Thanks for your response. Looks like 'top' would be the answer to my situation. Thanks again, Bill

Thanks for the response. The 'top' idea doesnt seem to work (syntax error). I should actually clarify what I want. We have a DB with millions of records. The query takes a long time. The query will run until it reads all of the records. What I want is for the query to return as SOON as it...

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...

thanks. I will post there.

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...

First, and foremost, thank you for reading my post. I dont think its microsoft. In our system, we are using Sybase. We have a series of C programs that manipulate (read/write/delete) from our database. To speed some of the database access up, we created some stored procedures that are...

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...