HOW TO: Paging result set returned via XML

The best way to deal with result set page would be to use an XPath query and the position() function. However, XML for SQL doesn’t currently support this function so we can not use it. There are two other methods which can be used. Which one you use depends on your result set. Both of these examples

Read More - Register for Free Membership