Retrieve interpolated values using TransposeInterpolatedDiscrete Table-Valued Function

SELECT eh.Name Element, ti.*
FROM NuGreen.[Asset].[ElementHierarchy] eh
CROSS APPLY NuGreen.[DataT].[TransposeInterpolateDiscrete_Cooling Fan]
(
eh.ElementID,
DATE('*') - TIME('1h')
) ti
WHERE eh.Path LIKE N'\NuGreen\Little Rock\Extruding Process\%'
OPTION (FORCE ORDER)

Retrieves interpolated values of attributes inherited from the Cooling Fan element template. The query is restricted to elements contained in the \NuGreen\Little Rock\Extruding Process\ subtree.