I've close to 60 databases - each of them have tables with similar schemas. I would like to create just one table, and load the data from all tables to this one. All these databases are in one server only. What is the better and fastest way to do it?? Cursors, While Loop??? any suggestions? Please let me know.
Thanks in advance !!