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 |
|
rcp
Starting Member
32 Posts |
 Posted - 2012-10-18 : 08:13:39
|
| Hi,I am trying to parse below into separate columnsDECLARE @X XMLSET @X = '<clientParameters> <fish>fish</fish> <bird>bird</bird> <grass>grass</grass></clientParameters>'SELECT t.u.value('.','varchar(100)') AS looking_forFROM @X.nodes('clientParameters')t(u)regards,Roland |
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2012-10-18 : 08:21:16
|
| SELECT t.u.value('.','varchar(100)') AS looking_for ,t.u.value('fish[1]','varchar(100)') as fish ,t.u.value('bird[1]','varchar(100)') as bird ,t.u.value('grass[1]','varchar(100)') as grassFROM @X.nodes('clientParameters')t(u) |
 |
|
|
rcp
Starting Member
32 Posts |
Posted - 2012-10-18 : 08:26:21
|
| Thanks works perfectly. |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2012-10-18 : 08:27:04
|
| W.Welcome |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Parse XML