Retrieve current values using TransposeSnapshot Table-Valued Function
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
SELECT eh.Name Element, tc.*
FROM [NuGreen].[Asset].[ElementHierarchy] eh
CROSS APPLY [NuGreen].[DataT].[TransposeSnapshot_Cooling Fan](eh.ElementID) tc
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'