Home Forums SQL Server 2008 T-SQL (SS2K8) Cross Apply to get child parent value from Xml in SQL Server RE: Cross Apply to get child parent value from Xml in SQL Server

  • December 25, 2012 at 4:11 am

    #1571407

    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)

    Thanks

    Paresh