Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI OLEDB Enterprise

Retrieve current values using TransposeSnapshot Table-Valued Function

Retrieve current values using TransposeSnapshot Table-Valued Function

  • Last UpdatedSep 29, 2022
  • 1 minute read

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\%'

TitleResults for “How to create a CRG?”Also Available in