SQLServerCentral / SQL Server 2005 / T-SQL (SS2K5) / Change XML output hierarchy in a SELECT...FOR XML clause / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:40:39 GMT20RE: Change XML output hierarchy in a SELECT...FOR XML clausehttp://www.sqlservercentral.com/Forums/Topic735374-338-1.aspxHi Valle,you might want to read the following article [url]http://www.sqlservercentral.com/articles/SS2K5+-+XML/2982/[/url].If you have further questions please provide sample data as described in the link in my signature. Please use [ code="xml" ] tag (with removed spaces) for xml sample data.Tue, 16 Jun 2009 00:47:27 GMTLutzMChange XML output hierarchy in a SELECT...FOR XML clausehttp://www.sqlservercentral.com/Forums/Topic735374-338-1.aspxHi, I'm trying to create an XML output file with some hierarchy using a a SELECT...FOR XML clause, to group equal values in rows in the same XML node.I've tried with AUTO and EXPLICIT clauses but its doesn't work as I need.Best Regards,ValleMon, 15 Jun 2009 17:05:59 GMTJDValle