Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Comparing 2 Tables

Author  Topic 

Eithne
Starting Member

8 Posts

Posted - 2004-11-10 : 04:54:46
Is there any way i can compare the records between 2 tables (table a and table b where order id is the same in both) and tell what the difference is between the 2 of them.

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2004-11-10 : 06:31:40
Duplicate post
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42421[/url]
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-11-10 : 09:33:11
is there a way to compare two posts to see if they are duplicates?



It would be good irony if the application being supported is a forum app and the goal is to find out which posts are duplicates in the DB so they can be deleted !

- Jeff
Go to Top of Page
   

- Advertisement -