On Mon, Feb 21, 2011 at 11:34 AM, Rafael Copquin <rcopquin@ciudad.com.ar> wrote:

> That's another way of doing it, thanks, but I'd rather have SQL give me

> the right answer.

-----------------

I would make a SP to give you the right answer. A param to pass in

would be what page do you want? If user was on page 1 and wanted to

go to page 5 allow them to tell you last page # instead of next, next,

next.

No cursors either on the SQL side please.

Now do you know how to identify how many pages you are going to get?

Can you pull subsets form one group to another easily?

Is there a SQL person on site at this location to run this by, or is that you?

--

Stephen Russell

Sr. Production Systems Programmer

CIMSgts

901.246-0159 cell

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/AANLkTikkQAj4nw8QPwn9-1Qs-v-ZHx+r-2N+-mmypahO@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.