Retrieve interpolated values using TransposeInterpolatedDiscrete function table

SELECT eh.Path + eh.Name Element, tc.*
FROM [NuGreen].[Asset].[ElementHierarchy] eh
INNER JOIN [NuGreen].[DataT].[ft_TransposeInterpolateDiscrete_Boiler] tc
ON tc.ElementID = eh.ElementID
WHERE eh.Path LIKE N'\%' AND tc.Time = '*'
OPTION (FORCE ORDER)

Retrieves interpolated values of all attributes of elements that are inherited from the Boiler template.