With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
SELECT hv.c.[RMS].value('./@V','float') RMS FROM [TS.Data].[dbo].[Devices] as d JOIN [TS.Data].[dbo].[Devices.Tests] as dt ON d.[DeviceId] = dt.[DeviceId] JOIN [TS.Data].[dbo].[Devices.Tests.RMS] hv(c) ON dt.[DeviceTestId] = hv.[DeviceTestId]