Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Compare two Table data and insert changed field to the third table RE: Compare two Table data and insert changed field to the third table

  • August 13, 2014 at 4:31 am

    #1737499

    F/-\R//-\Z (8/12/2014)

    hi

    I want Compare two Table data and insert changed field to the third table

    who can help me

    thanks a lot:-):hehe:

    So all three tables have the same structure?

    And table three should contain all of the rows in table 2 which either

    a) Do not have a matching row in table one, or

    b) Have one or more columns whose value is different.

    Is that correct?

    In future, please provide sample data as well as DDL. Also you should provide desired results, based on your sample data. This avoids us having to play 'guess the requirement', as we are doing here.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.