Home Forums Programming XML XML Type XML Attribute query RE: XML Type XML Attribute query

  • August 31, 2016 at 6:49 am

    #1898522

    jharvey6 76850 (8/30/2016)

    I have a small data table that store XML files of a certain standard design.

    There are three columns [Index_ID] and IDENTITY seeded index, InsertDate, and XML_File of XML datatype.

    Within the XML file I have an element with an attribute that is deterministic to construction of the XML file

    Element is <TransType tc="NNN" />the attribute can be various 3 digit numbers, obviously as a string here.

    How can I query the table for the Index_ID and InsertDate based on the value of this element attribute with the XML?

    Can you post an example of the XML?

    😎