Using seek in index of a table in a query
Results 1 to 4 of 4

Thread: Using seek in index of a table in a query

  1. #1
    Join Date
    Nov 2004
    Location
    us
    Posts
    14

    Using seek in index of a table in a query

    Hi, I would like to use if possible a seek statement that takes me to the first range of a data on the indexed table column. Then be able to run formulas on the given range and continue on the next range do the same thing until the the end of the table, instead of scanning the whole table for each range.
    If you could post me a Select statement example or what you think can do the job using index I would appreciate. Also I would like to know if this is an efficient way of retreiving ranges of data while running formulas on each range

    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    5,900
    On which rdbms?

  3. #3
    Join Date
    Nov 2004
    Location
    us
    Posts
    14
    On SQL Server

  4. #4
    Join Date
    Sep 2002
    Posts
    5,900
    There's no seek statement in sql server. Can you post table schema, same sample data and result you like to get?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •