Use an AVEVA Historian OLE DB provider view

Microsoft SQL Server views have been provided that will access each of the extension tables, eliminating the need to type the four-part server name in the query. These views are named the same as the provider table name.

Note: Backward compatibility views are named according to the v_ProviderTableName convention.

For example:

SELECT * FROM History

WHERE TagName = 'SysTimeSec'

AND DateTime >= '2001-09-12 12:59:00'

AND DateTime <= '2001-09-12 13:00:00'