I have written a SQL Query, Stored Procedure, to Order an xClassTree so that the top level xClasses are in the alphabetical order.
If I run the query just as a SQL query, in SSMS, it works great.
If i run the query as a Stored Procedure in SSMS, created using the innovator SQL itemtype, it works great.
In the debugger see the following in resetXClassTopLevelOrder Item, under DOM:XMLDocument, after .apply()
I have tried reorganizing the SQL code and no luck.
Thanks for the help and/or insights.