support 86837 (11/25/2014)
I've never done any XML data extraction before and have spent awhile this afternoon reading about it, and am still struggling. The concept seems relatively simple but my query still doesn't work. Any suggestions would be greatly appreciated!Table name is CCHistory
Column containing the data is CCXML
and the xml format, names changed to protect the guilty, is:
you can use this code directly on the table of CCHistory. Temp/Variable table is just to simulate CCHistory table here to give you can idea how you can fetch the data in actual environment.