Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian XML Workshop XVII - Writing a LOOP to process XML elements in TSQL RE: XML Workshop XVII - Writing a LOOP to process XML elements in TSQL

  • March 18, 2009 at 7:32 am

    #961847

    I found the solution.

    Sometimes it helps, when you write your problem down on 'paper'.

    SELECT

    T.c.value('../../@Id[1]','int') AS PropertyId,

    T.c.value('(CountryCode/text())[1]', 'varchar(256)') as CountryCode,

    T.c.value('(Number/text())[1]', 'varchar(256)') as PhoneNumber

    FROM @x.nodes('//Property/PhoneList/Phone') T(c)