You can access the same data in different ways. For example, you may want to retrieve all the data points stored for the last hour or you may want to retrieve evenly spaced data points for the last three months to minimize response time.

At the end of the lab, there will be a group discussion over the questions posed by the queries, as well as a discussion on the main differences between the basic retrieval modes used here.

Run SQL Queries

Now you will use the basic knowledge of SQL queries acquired in the previous lab and include an additional line specifying the retrieval mode.

Step 1. In the SQL Server Management Studio, verify that you are connected to your Historian Server and the Runtime database is selected.

Step 2. On the File menu, click Open | File. The Open File dialog box appears.

Step 3. Download file and, select Lab6-Using wwRetrievalMode.sql and click Open.

Step 4. In the body of the query, highlight the Example 1 query and click the Execute button (or Press the F5 key).

Step 5. Based on the results of this query, complete the sentences or answer the posed questions.

Step 6. Repeat Steps 4 and 5 for the rest of the queries.