retrieving value from xml variable

Question

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

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

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

You were really close

SELECT

V.y.value('./text()[1]','int') as ID

FROM @xmlRoleConsumerTemp.nodes('/RoleConsumerTemp/ID') AS V(y)

____________________________________________________

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

How to get the best help on a forum

SQL006 SSCertifiable Points: 5071 More actions · Answer 2

SSCertifiable

Points: 5071

October 19, 2010 at 3:43 am

thanks for the help