data table to some columns + xml data in last column

• Vijay_Raju

  Valued Member

  Points: 67

  More actions

  October 2, 2012 at 10:06 am

  #147623

  I need to convert a table data with 20 columns into a new table with 11 columns (10 columns and (remaining columns data in Xml format ) in 11th column )

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  October 2, 2012 at 6:06 pm

  #1544642

  Take a look at the FOR XML clause.

  http://msdn.microsoft.com/en-us/library/ms190922%28v=sql.105%29.aspx

  HTH,

  Rob