• You can use system objects about the table/columns to write a query that will write the comparison query for you. Easy-peasy, lemon-squeezy!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service