Here, I am attaching screen shot of the issue.
My problem is, I have detail tag as Item and I am able to get data from that but along with that I want to get data from the header tag which is Success tag.
My structure is shown in attachment along with dummy xml file. Please help me to resolve the issue.
![> SELECT * FROM openxml( '
1 29004caf-5710-4769-b61b-a94074ebad8e sdfsdfs 509f91b9-c040-41f6-9273-12fefeaf4411 uXkC81eBk... hnU9MoVqId3rs0m77Vh2O5uVGBA= MIIEfzCCA2egAwIBAgITHwA... sdfsdfs 509f91b9-c040-41f6-9273-12fefeaf4411 uXkC81eBk... hnU9MoVqId3rs0m77Vh2O5uVGBA= MIIEfzCCA2egAwIBAgITHwA... ','//:Body//:item' ) WITH ( success int 'Body///:success/text()', clientDocRef long varchar ':clientDocRef',auditRef long varchar ':documents/item/auditRef',signatureValue long varchar ':documents/item/signatureValue',digestValue long varchar ':documents/item/digestValue',x509Cert long varchar ':documents/item/x509Cert' );][1]
[Screen Shot]: http://ift.tt/1ELiuKE
No comments:
Post a Comment