Need some help to get data from an xml column into a datatable.
This is the data in the xml column
I need this to be returned as a datatable
I got help with this in another post but the problem I now got is how to solve this when you have a lots of JOIN.
This is the code I now have.
SELECT hv.c.[RMS].value('./@V','float') RMS
FROM [TS.Data].[dbo].[Devices] as d
[TS.Data].[dbo].[Devices.Tests] as dt
d.[DeviceId] = dt.[DeviceId]
ON dt.[DeviceTestId] = hv.[DeviceTestId]