xml file content appears in one long row

• sam-433147

  Ten Centuries

  Points: 1221

  More actions

  February 3, 2017 at 9:44 am

  #326554

  for exporting to xml file i use:
  bcp "select * from table'" queryout C:\filename.dat -S @@servername -t -c -C 65001 -T
  the result in the created file appears in one long row like:
  "<Payment_group><Payment>100</Payment><PayMonth>201301</PayMonth></Payment_group>"

  how can i force it to appear in separate rows like: 
  "<Payment_group>
  <Payment>100</Payment>
  <PayMonth>201301</PayMonth>
  </Payment_group>"

  thanks ahead

• Thom A

  SSC Guru

  Points: 99130

  More actions

  February 3, 2017 at 10:15 am

  #1926666

  Duplicate of post https://www.sqlservercentral.com/Forums/1854197/export-to-xml-file-with-separate-rows. Please keep to one topic per question.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• onkar26_saini

  Newbie

  Points: 9

  More actions

  February 8, 2017 at 1:31 pm

  #1927405

  sam-433147 - Friday, February 3, 2017 9:44 AM

  for exporting to xml file i use:
  bcp "select * from table'" queryout C:\filename.dat -S @@servername -t -c -C 65001 -T
  the result in the created file appears in one long row like:
  "<Payment_group><Payment>100</Payment><PayMonth>201301</PayMonth></Payment_group>"

  how can i force it to appear in separate rows like: 
  "<Payment_group>
  <Payment>100</Payment>
  <PayMonth>201301</PayMonth>
  </Payment_group>"

  thanks ahead

  Open Analysis Services XMLA Query window from SSMS and paste your XML code. You will get the same what you are looking for, See below screen shot.