I am looking to bring back 2 attributes that can be in any element. Currently, I am running a x.query() for each attribute I am looking for. Is there a way to do this in one query? Looking at the execution plan, each XML Reader table is taking 28% of the total process. Such as: SELECT myXMLcol.query('fn:data(//s2sBody//@dateTime)').value('.','varchar(MAX)') as test, myXMLcol.query('fn:data(//s2sBody//@TTL)').value('.','varchar(MAX)') as test FROM myXMLTable
See jacob's post: http://beyondrelational.com/blogs/j...-applying-filters-on-multiple-attributes.aspx for help.