Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raky
Aged Yak Warrior
767 Posts |
 Posted - 2008-02-25 : 01:25:12
|
| I have the table with xml column that has the following rows with diffrent PurchaseOrderReferenceType rows'<PurchaseOrderInformation><PurchaseOrderNumber>4500022378</PurchaseOrderNumber><PurchaseOrderIssuedDate><Date><Year>2006</Year><Month>12</Month><Day>8</Day></Date></PurchaseOrderIssuedDate><PurchaseOrderReference PurchaseOrderReferenceType="TransactionID" >1</PurchaseOrderReference><PurchaseOrderReference PurchaseOrderReferenceType="TransactionID">2</PurchaseOrderReference><PurchaseOrderReference PurchaseOrderReferenceType="CustomerSpecificationNumber" >3</PurchaseOrderReference></PurchaseOrderInformation>'Then how i get the value in PurchaseOrderReference where PurchaseOrderReferenceType="TransactionID"There is any posiblility to get the result with out subquires.Please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-25 : 03:07:16
|
| DIdnt i answer this here?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97749 |
 |
|
|
|
|
|
Please help to get the data from xml column.