xml query

• tlrsekar

  SSC Enthusiast

  Points: 116

  More actions

  September 10, 2009 at 12:24 am

  #210624

  Hi All

  I am trying to create xml from table

  for that i used query

  select column1,column2,column3 from table1 FOR XML PATH('')

  This will give xml output

  1xxxABC

  My desired output should be like given below

  <[/b]column2>xxx

  ABC

  Suggest me how will i arrive to this output through SQL Query and XML commands

  awating reply asap

• LutzM

  SSC Guru

  Points: 107049

  More actions

  September 10, 2009 at 1:58 pm

  #1051944

  Duplicate post.

  Already answered in this thread .

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]