Is there a way to create SQL reports to pull data from the hourly or daily tables? The problem I have is with the date being appended to the table name, it makes it impossible to setup a scheduled report to run in SRSS since the query would change each day to reflect the new table name.