Paging

I'm looking for an efficient generic T-SQL paging
technique
that would be able to give me a page result under
different sorting
I done a lot of web searching but didn't find any
tnxPlease dont MULTI-Post... I've already answered this in the other
group and dont wish to answer it a 2nd time.
if more than one group is relevent (as in this case) then CROSS-post
your questions then when someone replies it will automatically cross
post the replie.
to cross post put ALL the names of the groups in the to field
seperated by a semi colon (depending on browser app)
hth.
Al.
On Tue, 13 Jan 2004 10:12:11 -0800, "Bnaya Eshet"
<bnaya_eshet@.splsoftware.com> wrote:

quote:

---

>I'm looking for an efficient generic T-SQL paging
>technique
>that would be able to give me a page result under
>different sorting
>I done a lot of web searching but didn't find any
>tnx

---