Thanks Wayne, that is a great solution... I'm still a newbie at SQL, so that never dawned on me... I will definitely try it out.. Thanks for your help!

PaulB-TheOneAndOnly (4/5/2010)

---

I've seen so many "duplicate rows" postings lately that I feel somebody has to tell people Microsoft is not charging a license fee per unique index.

Once you have...

CirquedeSQLeil (4/5/2010)

---

olie480 (4/5/2010)

---

What I do know is that if I have 4 'John Smiths' and if they were all different people, the Address column would be different for each of...

What I do know is that if I have 4 'John Smiths' and if they were all different people, the Address column would be different for each of those entities....

Jeff Moden (4/2/2010)

---

Deleting data that is supposedly duplicated by FirstName and LastName is a very good way to have a sudden and very unwelcome career change. There must be...

Jeff Moden (4/2/2010)

---

Deleting data that is supposedly duplicated by FirstName and LastName is a very good way to have a sudden and very unwelcome career change. There must be...

lmu92 (4/2/2010)

---

Btw: What do you mean by "query manager"?

If you're using SQL Server 2000, the query shouldn't run at all since table variable as well as ROW_NUMBER function that I've...

lmu92 (4/2/2010)

---

You could use Row_Number() to find the dupes...

Something like this:

DECLARE @tbl TABLE

(

CustNumber INT, FirstName VARCHAR(30), LastName VARCHAR(30), City VARCHAR(30)

)

INSERT INTO @tbl

SELECT 345321 ,'John','Doe','Kellogg' UNION ALL

SELECT...

Alright, I just ran the script on the sample database, and everything worked out great! Thanks again for your help. I know that there are many JOIN commands, INNER, OUTER,...

Thanks for the help guys, I will definitely try this tomorrow and report back.

I kind of figured it had to do with a join, but like I said, JOIN is...

Wow! That's it! That is exactly what I was looking for! Thank you so much!

The new Microsoft POS (Dynamics POS 2009) has a tool that...

I know I wouldn't have a problem with backup and restore if the database (or program) was the same, but in this instance, I have table names that are changing...