I have a text column in my table with XML tags
I need to extract the text from some nodes
Assume I have the following content
I had the following which works to extract the text from the first description, but how do I extract the text from the second description and insert a "," between the extracted text?
DECLARE @XML AS varchar(MAX)
<description>the description <outsideContent>the content</outsideContent> continued</description>
SELECT CAST(@XML as XML).value( '(root/Person/description)', ' varchar(2000) ' )