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 26, 2008 at 11:39 am

    #794232

    Or for this particular XML data you could simplify even further:

    SELECT

    Table1.Column1.value('.','VARCHAR(20)') AS Employee_Name

    FROM

    @XML_Employee_Name.nodes('//Name[1]') AS Table1(Column1)