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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-13 : 08:52:20
|
| Rusty writes "I do not have your standard delete query for deduping. However not that far off. I have a table that has zip code and serveral other items in it. I am joining this to a Zip code database. The issue seems to be zip codes cross boundries of cities. I am not concerned so much with the specific city or anything I just need to get only one of them that match. I tried serveral things with sub selects on left joins with distinct, even used the having min(ID)............. :( obviously no luck.... Still no prevail. Looking all over for help...... Any help would be great." |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-03-13 : 12:21:19
|
| Can you post a sample of table data and a sample of what you want returned?Jeremy |
 |
|
|
|
|
|
Duplicate data