Posted by John on 04/25/06 19:40

Gurus.
I do not know if it is possible, but here is what I want to do.
I want to allow user to page the SQL result, so he could decides to
return from row 10 to row 20, or row 100 to 200, without returns the
whole resultset. Every time he sends another request, I do not mind to
hit the database again, (I do not want to cache the result in the
middle tier server, scalability issue), and I know that I could achieve
this with CURSOR, but unfortunately the FOR XML is not allowed in a
CURSOR statement .
(I know that I could achieve what I want to do by writing custom code
in the middle tier, but I just want to see if there is a way to do this
on the database side.)

Any comments & suggestion is greatly appreciated.
Thanks in advance.

(I am using SQL2005)



John

[Back to original message]