Getting node values from an XML column

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Mark Cowne One Orange Chip Points: 26986 More actions · Answer 1

SELECT

context_id

,a.alias.value('(KeyValueId/text())[1]','Varchar(20)') AS 'KeyID'

,a.alias.value('(Value/text())[1]','Varchar(20)') AS 'Value'

,a.alias.query('.') AS 'Node'

FROM (

.

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

Chris Quinn-821458 Hall of Fame Points: 3192 More actions · Answer 2

Hall of Fame

Points: 3192

May 30, 2013 at 4:51 am

Many thanks! Works perfectly