XML Query

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 @XML.value('(/CP/CustomProperty1/text())[1]','VARCHAR(20)')

____________________________________________________

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

How to get the best help on a forum

yossih SSC Enthusiast Points: 182 More actions · Answer 2

SSC Enthusiast

Points: 182

June 28, 2013 at 2:10 am

Hi Mark-101232,

Perfect!! Thanks for your help!!