The XML is represented in a table.  The data returned is spit out in the order that it is in the table.  If you remove the FOR XML EXPLICIT statement...

Good to see you got it working.

Never having used ADO.NET I cannot comment on its behaviour.  What I can do though, is provide (hopefully) the correct non-lazy way of performing the UNION for you.

Note that even...

I assume you are calling the procedure through ADO or using the SQLXML ISAPI.  The result is streamed out, so as long as the text streamed out looks like XML...

Here is one method of forcing encoding I have found in Microsoft's documentation.  If you can be more specific on how you wish to retrieve the data there may be...

I believe Word 2000 cannot save documents as XML and consequently you would be unable to run the documents through any XML parser.

What you really need to do is use...

I have done this before and a quick look around has found what I was after.  ENJOY!!

This is where I found the info - http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag02/html/overcomingopenxmlhangupsListing_03.asp

Essentially sp_xml_preparedocument can take a...

What is the report engine? Crystal.

Are you using a web UI or application UI?

I'm no expert, but why aren't you using a between statement when grabbing the date?  In my mind it should look something like below.  Note that I have returned [DATE] in the...

A couple of "freeware" editors I have come across which work quite well are "Context" and "PSPad".

If you are using SQL Server 2000 and XML, when you select using OPEN XML, it automagically omits null columns.

This achieves your ends in a simple manner, but I do...