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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by paraglidersd

  1. paraglidersd

    Getting first row

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

    Getting first row

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

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

    temp table in stored procedure

    thanks. I will post there.
  5. paraglidersd

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

    temp table in stored procedure

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

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

Part and Inventory Search

Back
Top