Viewing 2 posts - 1 through 2 (of 2 total)
Thanks it is working. I also got below another way:
select c.value('(../@value)[1]', 'varchar(100)'),c.value('@value','varchar(100)'), c.value('.','varchar(100)')from @x.nodes('/root/row/col') as m(c)
select c.value('(../@value)[1]', 'varchar(100)'),c.value('@value','varchar(100)'), c.value('.','varchar(100)')
from @x.nodes('/root/row/col') as m(c)
Thanks
Paresh
December 25, 2012 at 4:11 am
#1571407
Thank you very much. It works. What a nice query!!!!
You are great!!! (champs of SQL Server) 🙂
September 24, 2009 at 8:26 am
#1058045