Home All Groups Group Topic Archive Search About
Author
11 Aug 2006 4:48 PM
joseph.chewning
I am trying to merge 12 tables that have 6 columns in common and the
rest are unique to that table. I want to merge them into a table that
has all the common and unique columns. Is there a script or product
that can do this????

Author
11 Aug 2006 4:59 PM
Aaron Bertrand [SQL Server MVP]
>I am trying to merge 12 tables

What does "merge" mean?  Are you trying to return a resultset from all 12
tables, or a new table with all the data, or what?  Can you provide DDL,
sample data, and desired results?

AddThis Social Bookmark Button