can someone correct me please what's wrong in this query?
SELECT substr(eh.Name,1,5) farmcode,eh.Name latlongmap, tc.height,
if tc.speed is null then 'NaN' else cast (tc.speed as variant) as speed,
FROM (SELECT Date('07/02/2016') Time) t, [HYREF].[Asset].[ElementHierarchy] eh
CROSS APPLY [HYREF].[DataT].[TransposeInterpolateDiscrete_WindGeneratorTemplate](eh.ElementID, t.Time) tc
WHERE eh.Path like '%\%' and eh.Name like 'F4402W0001H0080'
order by latlongmap
OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)
in this query state and temperature values are not appearing, although PI tags have been defined on explorer window correctly.
Even if I say 'NaN' as speed, still state and temp values are not displaying in result set.
PS: Since there is no PI point available for 'speed' attribute, I should set as NaN fo speed and all other values should disply me.