Query XML with stylesheet/namespace included in the xml



I have tried several ways to query this data out, but have not been successful. I am on a Sql Server 2012 R2 server. Any help would be appreciated.


<_x005B_M_x005D_._x005B_SEQID_x005D_ xmlns:xs="http://ift.tt/tphNwY" xmlns:xsi="http://ift.tt/ra1lAU" xsi:type="xs:short">200 <_x005B_M_x005D_._x005B_CPID_x005D_ xmlns:xs="http://ift.tt/tphNwY" xmlns:xsi="http://ift.tt/ra1lAU" xsi:type="xs:string">1002


No comments:

Post a Comment