I have seen this problem before. The ORDER BY clause refrences actual columns or expressions built form such columns. In your regular SELECT statment you used expressions of actual...

I made two corrections to your xml fragment and was able to parse it.

1. the line you removed was not defined properly. the correct definition is

<AMCData xmlns:xsi="http://tempuri.org/AMCData.xsd">

2. The format...