If Table Exists
Posted on 2008-10-27
On the first day of every month we create a table of data for the previous month, I then join them in a union statement as below.
On the first day of every month I add the next table to the union statement, so on the 1st Novermber I will add out_oct08 to the statement.
I am wandering if there is away where I can add all 12 months to the stement and add an if table exists statement, so the query will still run even if the table does not exist.
Is this possible?