Use Four-Part Name Syntax

Although four-part name syntax works with all tables, it is only necessary to use it with the ihTrend table, because the ihTrend table does not work with OPENQUERY.

Example: Access the ihTrend Table From a Linked Server

SELECT * FROM iHist...[SELECT timestamp, *.value FROM ihTrend]