Formatting XML Output File

• Mike Howell

  Mr or Mrs. 500

  Points: 521

  More actions

  September 17, 2005 at 5:02 pm

  #69643

  I am working on a project where we are passing data between 2 companies using XML.  One of the companies wants the XML data to be formatted where each set of tags is on a new line. example:

  <root>

  <FirstName>Bob</FirstName>

  <LastName>Smith</LastName>

  <City>Somewhere</City>

  <State>CA</State>

  </Root>

  Using the For XML, Elements option, my result set is combined into a single row.  Is there any way to format the XML file as shown above?  My actual data set contains 30 or more fields and I would like to maintain a SS 2000 solution.

  Thanks in advance for any help you can provide.

  Mike

• September 20, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  September 22, 2005 at 1:05 am

  #592094

  Try the link below for some code sample on using XML with SQL Server.  Hope this helps.

  http://msdn.microsoft.com/msdnmag/issues/05/06/DataPoints/default.aspx

  Kind regards,

  Gift Peddie

  Kind regards,
  Gift Peddie