Home Forums SQL Server 2012 SQL 2012 - General query to return values from XML field RE: query to return values from XML field

  • June 5, 2014 at 12:15 pm

    #1719386

    select FieldSet.value ('(/Fields/Field[@Key="Column1"]/@value)[1]', 'varchar(20)'),

    FieldSet.value ('(/Fields/Field[@Key="Column2"]/@value)[1]', 'varchar(20)'),

    FieldSet.value ('(/Fields/Field[@Key="Column3"]/@value)[1]', 'varchar(20)'),

    FieldSet.value ('(/Fields/Field[@Key="Column4"]/@value)[1]', 'varchar(20)')

    from #temp