What the best way to work around this? I have the same SELECT statement but there are different criteria depending on the IF check. Well, if you happen to be using Sql Server you can do that sort of ...

The SELECT INTO statement in SQL is used to create a new table by copying data from an existing table. The new table inherits column names and data types from the source table. It can also copy ...