Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <ITEMS><ITEM SEQ="0" INDNO="50814" DRN="N00230000004816012012" CR_GUID="FB64CD73-8048-4775-81F2-969AE2AB442C" DR_GUID="8025D121-E3B6-4479-A393-CDDC5BEB53C0" CR_ACC="" DR_ACC="" AMOUNT="0" DATE="20120202" /></ITEMS>
- create table YourTable
- (
- XMLColumn xml
- )
- insert into YourTable values
- ('<ITEMS><ITEM SEQ="0" INDNO="50814" DRN="N00230000004816012012" CR_GUID="FB64CD73-8048-4775-81F2-969AE2AB442C" DR_GUID="8025D121-E3B6-4479-A393-CDDC5BEB53C0" CR_ACC="" DR_ACC="" AMOUNT="0" DATE="20120202" /></ITEMS>')
- select I.N.value('@DRN', 'varchar(50)') as DRN
- from YourTable as T
- cross apply T.XMLColumn.nodes('/ITEMS/ITEM') as I(N)
- | DRN |
- -------------------------
- | N00230000004816012012 |
Add Comment
Please, Sign In to add comment