Here's what I have:
Hundreds of tables with identical DDL with only names different,
constructed based on a day-time, so TBL2012041808 is for April 18
2012 8AM data, TBL2012041809 is for 9AM etc.
Each table contains upwards of 300,000 records
What I need to do:
Produce reports from that data. The problem is that if
that is a monthly report, I will be dealing with 720 tables.
Yearly - 8,760 tables.
I am thinking of writing an SP that accepts parameters defining two dates
and returns a resultset from table(s) between those two dates.
Is there even any benefit in writing such an SP in terms of speed?
The real question is:
What would be a better approach to querying such database?
Any help is appreciated,