How to compare 2 table columns and insert the column name and column value in temp table in SQL?

Let use suppose u have two table A, B with following Colums

A
-----------------
AID , ANAME, AAddress

and

B
-----------------
BID, BNAME, BADddress

now u can open a cursour on table a and compare each row coloum wise and increment a count variable if all the coloums matches else u can leave not increment the count,
one u have done with all the rows then u can check if count is equal to 100 u need not insert else insert in the row in the temp table

Thanks
Pavan Kumar
Mark Answer if this fits the need

Please go thru below links
http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=23054