We're currently upgrading/migrating a DB where data is polled every hour. The old DB had individual columns (ie. DateTime, Pressure, Temp, etc.), however, for the new one, we found out they captured everything in one column, and formatted as XML.
I tried using SELECT col.value('(/Data/Fields[N
', 'int'), however after digging around the FieldData column is actually nvarchar, so that didn't work.
I'm trying to figure out how to extract parts of the data within the FieldData column (see highlighted).
Any questions or further info, please let me know...