Retrieving Huge Data From DB in steps of 1000

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SSP (anonymous_at_discussions.microsoft.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 00:04:59 -0700

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.
.

Relevant Pages

  • Retrieving Huge Data From DB in steps of 1000
    ... 60,000+ rows of records from one table alone. ... child tables have probalby double the number of records ... to do this or a much a better aprroach if present would ...
    (microsoft.public.sqlserver.programming)
  • Re: Man Charged When His 6 Dogs Kill Little Boy
    ... they often walked places alone. ... snatch a child or whatever, where before they'd just fantasize about it. ... couple weeks ago about some guy in Canada raping a child online. ... As for Carlie Brucia, I think we'd probably have heard about that one ...
    (alt.true-crime)
  • Re: Off topic - Hail Re: What are you stitching next?
    ... there is even a distinction between lonely and alone. ... As a child that was lonliness magnified. ... on to realize that he really doesn't have a bunch of close male friends. ... I was a be in my room reading kid - or out at the barn - or playing football ...
    (rec.crafts.textiles.needlework)
  • Re: 14 months and still gets up atleast 4-5 times at night
    ... Another idea is to get the child accustomed to being alone ... so that the child can feel calm while alone. ... my theory is that if a child falls asleep with a parent ... stay quietly lying there and fall asleep again, ...
    (misc.kids)
  • Re: Legal Age for Looking After Siblings?
    ... There is no law that states the minimum age that a child can be left alone. ... All children left alone should be able to phone the emergency services. ... Put obvious dangers out of reach of children, e.g. medicines, chemicals, ...
    (uk.legal)