Use stored procedures in OLE DB queries

Any normal SQL Server stored procedure can make use of the tables exposed by the AVEVA Historian OLE DB Provider. Stored procedures can use any valid Transact-SQL syntax to access AVEVA Historian historical data.

In other words, stored procedures can make use of four-part-queries, OPENQUERY and OPENROWSET functions, cursors, parameterized queries and views. Stored procedures can be used to encapsulate complex joins and other operations for easy re-use by applications and end users.