Importing XML

• TheRedneckDBA

  SSChampion

  Points: 14001

  More actions

  October 11, 2007 at 11:23 am

  #182648

  We want to import an XML file like the one below (which will contain many more s, I'm just showing 1 here).

  We don't care about the volume-index / volume stuff.

  Is there a way to do this with T-SQL?

  We'd just like a row for each transaction.

  The Redneck DBA

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  October 11, 2007 at 11:48 am

  #741302

  Nothing there, you may want to repost.

  However, assuming the XML is well formed, you have multiple options for importing it.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning