Thanks lotsmuch for your advice everyone,

I'll digest it over the weekend and let you know how I get on.

Have a lovely weekend.

D.

-----Original Message-----
From: Mordechai Danielov
[mailto:mssqldba-ezmlmshield-x94838993.[Email address protected]
Sent: 28 July 2006 16:41
To: LazyDBA Discussion
Subject: [SPAM] - RE: Paging Records with Stored Procs - Number of
numbers in MIME From exceeds maximum threshold


If you don't want to use temp tables removing records as you go along,
you can probably still do it using a bit of logic:

1. get the total number of records to be returned 2. get the id of the
last row of each batch using max(col) and for the next batch use the
where condition of id_col>last_max_id_col however both this, and the
temp table approach would require few passes at the data. It may be more
efficient to handle this type of displaying programatically.

just my 2c

-----Original Message-----
From: David Peters
[mailto:mssqldba-ezmlmshield-x81104976.[Email address protected]
Sent: Friday, July 28, 2006 5:07 AM
To: LazyDBA Discussion
Subject: Paging Records with Stored Procs


Hi All,

Is there anyone out there who has tried this? What we need to do is
return records say, 20 at a time, for a search on thousands of products.
The records can be ordered according to the user's requirements and we
need to be able to have "page x of y" displayed along with "records a to
n".

Having looked at samples in the web, I have seen that most people seem
to use temporary tables but is this the most efficient way?

Any help would be deeply appreciated.

Kind regards,

David Peters

Senior Developer
Storm Technologies

Phone: 01923 801 080 Fax: 01923 252 106 Mobile: 07817 812 936

david.[Email address protected]
www.storm-technologies.com <http://www.storm-technologies.com/>



**********************

CONFIDENTIALITY NOTICE 28/7/2006

The information contained in this message is legally privileged and
confidential information intended only for the use of the individual or
the entity named as the recipient. If the reader of this message is not
the intended recipient, you are hereby notified that any dissemination,
distribution or copy of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone on the number below, and return the original message to the
sender.

Your co-operation is appreciated.

Storm Technologies

Unit 41 Park House
Greenhill Crescent
Watford
United Kingdom
WD18 8PH
Tel:+44(0)1923801080 Fax:+(0)1923252106

www.storm-technologies.com




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page