Post reply

How to Merge the data from different table into one table

  • December 23, 2008 at 12:16 am

    #73418

    Hi,

    I have 101 table which contain the different number of columns (Count of columns) and also column names are different.

    Please help out to create the one table from the multiple tables

    Note:- i am using SQL Server 2000

    Thanks and regards,

    Pravin V. Kadam

  • December 23, 2008 at 7:08 am

    #916743

    You're going to have to be a lot more specific on your setup... and your reasons for wanting to do this. Do all the tables hold the same data? Due to the fact that you have different numbers of columns with different column names, I'm guessing they don't. Are you trying to consolidate your entire database into one table? (That'd be a bad idea... to put it lightly)

    Try starting with 3 table definitions so we can see the kind of merge'ing you are trying to accomplish.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply