Retrieving Huge Data From DB in steps of 1000

#1

Hello,
I am working on a application that involves processing
60,000+ rows of records from one table alone. This table's
child tables have probalby double the number of records
than that are present in the parent.My question is how can
I retreive records in say steps of 1000 process them ,
then go to the next 100o records in the same table,
process them and so on.
Ideally I would prefer it done on the SQL Level, through
Stored Procedures, Cursors,etc. But I am not sure how to
do it. So would someone plz help me with a example on how
to do this or a much a better aprroach if present would
be very highly appreciated.
Thanx,
SSP.

#2

Check the excellent article about paging at
http://www.aspfaq.com/show.asp?id=2120.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

"SSP" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,
I am working on a application that involves processing
60,000+ rows of records from one table alone. This table's
child tables have probalby double the number of records
than that are present in the parent.My question is how can
I retreive records in say steps of 1000 process them ,
then go to the next 100o records in the same table,
process them and so on.
Ideally I would prefer it done on the SQL Level, through
Stored Procedures, Cursors,etc. But I am not sure how to
do it. So would someone plz help me with a example on how
to do this or a much a better aprroach if present would
be very highly appreciated.
Thanx,
SSP.

#3

I am looking it at from the SQL Level. Cos its an Fiancial
Application. So i need to do it in a fast,reliable manner.
I am using ASP.Net and Ado.NEt.
Thanx,
SSP

Quote:

-----Original Message-----
Check the excellent article about paging at
http://www.aspfaq.com/show.asp?id=2120.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

"SSP" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message
news:1699801c4486b$75fb71d0$a601280a (AT) phx (DOT) gbl...
Hello,
I am working on a application that involves processing
60,000+ rows of records from one table alone. This
table's
child tables have probalby double the number of records
than that are present in the parent.My question is how
can
I retreive records in say steps of 1000 process them ,
then go to the next 100o records in the same table,
process them and so on.
Ideally I would prefer it done on the SQL Level, through
Stored Procedures, Cursors,etc. But I am not sure how to
do it. So would someone plz help me with a example on
how
to do this or a much a better aprroach if present would
be very highly appreciated.
Thanx,
SSP.

.

#4

Quote:

I am looking it at from the SQL Level.

Have you really read the article? There is a lot of T-SQL code in it with
things you need.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Retrieving Huge Data From DB in steps of 1000

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

Retrieving Huge Data From DB in steps of 1000 - 06-02-2004 , 01:33 AM

Re: Retrieving Huge Data From DB in steps of 1000 - 06-02-2004 , 02:03 AM

Re: Retrieving Huge Data From DB in steps of 1000 - 06-02-2004 , 02:55 AM

Re: Retrieving Huge Data From DB in steps of 1000 - 06-02-2004 , 06:13 AM