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)
 Finding Matches in 2 separate DBs

Author  Topic 

blaza
Starting Member

2 Posts

Posted - 2006-05-30 : 12:00:04
Hey guys--I was hoping someone could help me write a query in SQL server to extract similiar characters from two seperate databases here on my local server at work. My SQL skills are limited but i am trying to look at two different DB's and extract a report where I get, say all instances where Phone number in this DB equals the same Phone number in a separate DB. I also want to know if i can look for similiar matches for instance i want to consider Joe's Pizza and Joe's Pizza Parlor a match. If anyone could help or point me in the right direction I would appreciate it. Thanks in advance guys

X002548
Not Just a Number

15586 Posts

Posted - 2006-05-30 : 13:07:52
Dude(ette?), don't cross post



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page
   

- Advertisement -