Rizeheergip
New Member
I am new to XML queries in SQL, and was hoping some one could help me with an Sql query on how to retrieve the type value.I have an xml column data as shown below\[code\]<mnt:job xmlns:mnt="http://namespaces.aada.be/4.0/maintenance"xmlns
rder="http://namespaces.aadasoftware.net/4.4/maintenance/order" mnt:version="1.0" mnt:type="Aada.Core.Orders.DownloadOrder, Aada.Core"><mnt:targets><mnt:target mnt:id="bf321a20-8283-4760-a683-57892d8b9e12" mnt:status="Succeeded" mnt:duration="00:00:00" mnt:message="" mnt:attempt="1"><mnt:custom> .................\[/code\]I wanted to retrieve the \[code\]value("Aada.Core.Orders.DownloadOrder, Aada.Core")\[/code\] inside \[code\]mnt:type\[/code\] but was not sure on how to write the query for it.Appreciate the Help
rder="http://namespaces.aadasoftware.net/4.4/maintenance/order" mnt:version="1.0" mnt:type="Aada.Core.Orders.DownloadOrder, Aada.Core"><mnt:targets><mnt:target mnt:id="bf321a20-8283-4760-a683-57892d8b9e12" mnt:status="Succeeded" mnt:duration="00:00:00" mnt:message="" mnt:attempt="1"><mnt:custom> .................\[/code\]I wanted to retrieve the \[code\]value("Aada.Core.Orders.DownloadOrder, Aada.Core")\[/code\] inside \[code\]mnt:type\[/code\] but was not sure on how to write the query for it.Appreciate the Help