Home Forums Programming XML Little help need with a WHERE clause RE: Little help need with a WHERE clause

  • June 9, 2014 at 7:31 am

    #1720070

    This might work:

    SELECT T.C.value('@Name', 'varchar(50)') FROM @myXMLData.nodes('/order/Product/Drops/Drop[@Number="1"]/Area') T(C)

    note the test in brackets for the attribute Number.