Posted by: bajara January 15, 2015
Login in to Rate this Post:
0 
? 
?
I have xml data in a column called OriginalString as follows.
I need to extract all "Item Key" values from this column. I can use the CHARINDEX and SUBSTRING function combination to extract the first occurance of ItemKey, but how do I do this when I have multiple "Item Key"
I need to extract all "Item Key" values from this column. I can use the CHARINDEX and SUBSTRING function combination to extract the first occurance of ItemKey, but how do I do this when I have multiple "Item Key"