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
 SQL Server Development (2000)
 compare 2 tables in sql server 2005

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2006-09-27 : 16:08:37
Hi

I have 2 tables with columns like this..

ID
CarModel
StartYear
EndYear

I need to compare theese 2 tables for differences or rows that exsits in table 1 and not table 2.

Can anyone show me how I do this?


Regards

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-09-27 : 16:51:57
http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx
Go to Top of Page
   

- Advertisement -