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

• Next in forum: Re: Order by in a INSERT INTO..SELECT
• Prev in forum: Re: Order by in a INSERT INTO..SELECT
• Thread view: How to page SQL query result returned from FOR XML statement?

[Reply to this message]