Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2006
    Posts
    111

    Unanswered: fetching result set batch at a time

    hi,

    if i have a sql select statement which results in 300K rows, is there a mechanism to fetch it say 10K at a time?

    TIA,
    g11DB

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Maybe, depending on what you mean and how you intend to accomplish it. Your question isn't specific enough for me to give you a more specific answer than that.

    -PatP

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    oh, come on, pat, you're being stubborn

    he's talking about paging, paging, paging, paging, or paging

    just about everybody and his brother has written about paging in sql server

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jul 2006
    Posts
    111
    thanks guys, i had the concept in mind but didn't know the term... i'll take it from here do some googling :-)

    (edit)
    sorry didn't realize those were links too extra thanks

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you read pages with 10K rows, you have WAY too much time on your hands! I hope to high heaven that g11DB has something very different on their mind, although I can see how the concepts are similar.

    -PatP

  6. #6
    Join Date
    Jul 2006
    Posts
    111
    yea that's probably too high a number for my example i'd say in the real world it shouldve been somewhere between 10 and 50

  7. #7
    Join Date
    Sep 2005
    Posts
    161
    Quote Originally Posted by r937
    oh, come on, pat, you're being stubborn

    just about everybody and his brother has written about paging in sql server

    My brother has certainly never written about paging. He wouldn't know an SQL statement if it selected him in the face.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •