Is it possible to get resultset from a SQL StoredProc batch by batch?

• Soorya

  Ten Centuries

  Points: 1314

  More actions

  October 15, 2007 at 1:32 am

  #176252

  Hi,

  The requirement of my application is to fetch data from a couple of tables which have millions of records. Is it possible to send the resultset from SQL batch by batch? i mean... sending first 5000 records and then the next 5000 and so on... This is because, the StoredProc takes nearly 5 minutes to fetch the data all together. So i want to split it up and append the data as they come batch by batch. Is it possible?

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  October 15, 2007 at 2:24 am

  #741897

  This is the same post as http://www.sqlservercentral.com/Forums/Topic410712-149-1.aspx. I reckon it will be easier for you too to look up the answers on a single page.

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software