selecting the range of data

• uday.arunkumar

  Newbie

  Points: 9

  More actions

  December 16, 2009 at 9:07 am

  #214841

  Hi,

  I have around 100000 records in a table in which I want to select some range records which belongs to the particulat date.

  Assume that for one date i have 10000 records. I needs to select first 100 records on the first time and then 101-200 records for the next time and 201-300 records and so on.

  I need to use this in my vb application after selecting each records i need to process the data which belongs to that row. which will take 5 min for each row so i need to process with few records.

  Thanks in advance.

• Grant Fritchey

  SSC Guru

  Points: 399352

  More actions

  December 16, 2009 at 9:37 am

  #1093132

  This is more or less a paging problem. There are a number of possible solutions:

  http://www.sqlservercentral.com/articles/66030/%5B/url%5D

  http://www.sqlservercentral.com/scripts/31280/%5B/url%5D

  These are just the first couple that I came across after searching on the site. There are more.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning