Parsing xml data

• arijit rath

  SSC Veteran

  Points: 252

  More actions

  April 11, 2014 at 1:24 pm

  #285685

  Hi All,

  I have a xml as given below . I need to parse this and retrieve the employee ids present in it and insert into a table.

  declare @data xml='<employeelist>

  <employeeid>7830</employeeid>

  <employeeid>7831</employeeid>

  <employeeid>7832</employeeid>

  </employeelist>';

  Thanks

• a4apple

  SSCrazy

  Points: 2620

  More actions

  April 11, 2014 at 3:23 pm

  #1705473

  use below..

  SELECT a.c.value('(.)', 'varchar(100)') [EmpID]

  FROM @data.nodes ('employeelist/employeeid') a ( c )

  It's upto you to use Varchar or INT.. I just use Varchar for alphanumeric data...

  Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.