Post reply

Compare two tables cell by cell

  • February 6, 2013 at 12:09 pm

    #268141

    I need to compare two tables cell by cell in order to delete one.

    They have the same size and data structure. (More than 5000 records, has the same columns' name and the same data type for each columns)

    How to do it? Is there a store procedure or script can do this job?

  • February 6, 2013 at 12:15 pm

    #1585091

    adonetok (2/6/2013)

    I need to compare two tables cell by cell in order to delete one.

    They have the same size and data structure. (More than 5000 records, has the same columns' name and the same data type for each columns)

    How to do it? Is there a store procedure or script can do this job?

    Use except[/url] to compare 2 tables by row by row

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • February 6, 2013 at 12:58 pm

    #1585109

    I ran except it works like magic.

    Thanks

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

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