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:11 am

    #794220

    This is more elegant.

    SELECT

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

    FROM

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