sql - Comparing the data of two tables in the same database in sqlserver -

i need compare 2 table data in 1 database.match data using columns form table.

stored rows data table called "relationaldata". while searched ,found solutin.

but it's not working me http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

can 1 how this. how compare 2 table data in 1 database using redgate(tool)?

red gate sql data compare lets map 2 tables in same database, provided columns compatible datatypes. put same database in source , target, go object mapping tab, unmap 2 tables, , map them together.

data compare used use union all, filling tempdb, happen if table has high row count. "joins" on local hard disk using data cache.