Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Batch Blocking in SQL Table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-07 : 14:08:56
Arindam writes "Using SQL 2000 Enterprise Edition on Windows Professional

A table having 5 Fields and doesn't have unique data. I want to fetch data from that table in batches. How can I achieve the same.

Say the table has ten thousand records and I want to fetch the same in batches of say 100 or 200..so that it can be put to a flat file on 100 and 200 for 100 or 50 flatfiles.

If this can be achieved by just simple query

"
   

- Advertisement -