Sign in to wikis by wetpaint
This version of Internet Explorer is no longer supported. Please try a current version of
IE
or
Firefox
.
Home
Discussions
Photos
Videos
News
Updates
Members
Sign in
or
Using Database Views To Access Data
Page Versions
Key:
additions
deletions
Please select two page versions to compare - check the checkbox to the right of each version.
Showing 2 pages
Date/Time
Made By
Edit Note
Type
Scope
Compare
May 13 2010, 12:49 PM EDT
sdrevik
edit
427 words added
Change:
Even with the code that generates our reports, we don’t use direct table access. Rather, we use several Views installed in the database, the most useful of which is called
“Reporting.ReadingAverageDataFull.”
The user can query against or receive data from any of these fields:
SELECT [ReadingAverageDataTagID]
,[ReadingAverageIntervalID]
,[IntervalName] e.g., “001H”
View changes from previous version.
(Word count: 453)
May 13 2010, 12:48 PM EDT
sdrevik
create
No content added or deleted.
Change:
Created by
sdrevik
May 13 2010, 12:48 PM EDT for: no reason given
JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then
try again
.
Home
FAQs
AirVision Documentation
AirVision Concepts
Installing AirVision
Configuring AirVision
Using AirVision
Public Information (Web) Tools
AQI Web Service
AgileWeb (optional)
Using Database Views To Access Data
Optional Features
Database Schema
Training
Release Notes
Technical Notes / Workarounds
Design Notes: Upcoming Features
Tricks and Tips
ADVP Rule Suggestions
EPA Conference Notes
Step By Step Procedures
new page
(Uncategorized)