Consolidating data into one table from similar tables - robboll |
09-May-08 07:47:57
|
Hello SQL gurus! Is there a simple way to do the following using
TSQL? Here's a model of the problem.
There are 10 tables that are structurally identical and named
similarly:
080501TableAlpha
080502TableAlpha
080503TableAlpha
.
.
.
080510TableAlpha
I would like to append the contents of all of them into one new table:
TableAlpha
Without doing them individually, what procedure can I run to automate
the process?
Thanks for any help with this.
RBollinger |
 |
| |
|
|