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
button
 


Linked Server Errors Help