Sorry...But I found what will work is:

inside at my root select putting in the clause:

OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY

This will limit my results. I can change...

Hello,

I have a question about the nesting xml. Now, I want to deliver 150 rows at a time.

How can I restrict the query I have come up with to...

Thank you. Adding in:

Select '<?xml version="1.0"?>' + Cast((

[Original Select

]

) AS VARCHAR(MAX)) as XMLData

Worked nicely. Thank...

Ok. One last question: I need to get the line '<?xml version="1.0"?>' in the top of the results before any xml. How can I do that using the statement I...

Hello Everyone,

Thank you for all your time. I figured out. I am posting the solution I found in hopes it will help in future.

Select (

SELECT p.EmployeeID AS Employeeid,

--,

(...

Sorry for posting in the wrong forum. I can move it if necessary.