David Gerson
Last Activity: Jul 26 '13, 05:53 PM
Joined: Jul 25 '13
Location:
-
The database is externally managed so I cannot change the schema as much as I would like to. -
Creating a dynamic view for a union query based on a rolling date
I am trying to create a query with a rolling date range to combine log files from the last week. Each day a new log table is created (log_file_07_01 _2013).
I want to create a view which would dynamically update the query for the last seven days of histoy:
i.e.
...Code:Select * from log_file_07_01_2013 union Select * from log_file_07_02_2013 ... Union Select
Last edited by Rabbit; Jul 25 '13, 08:22 PM. Reason: Please use code tags when posting code or formatted data.
No activity results to display
Leave a comment: