Thanks for the compliment, Annas... 🙂 I wish the Tally table was my original idea... but it's not... I just write about how to use it. Just in...

David Naples (7/8/2008)

---

Jeff Moden (7/7/2008)

---

Ummm... maybe not...

harshil (7/8/2008)

---

Hi Jeff, In this query, the condition is rightly mentioned as rowno>1 and shouldn't be rowno=1

What the purpose of this query is to remove all duplicate records except one...

Kent Waldrop (7/8/2008)

---

create either a temp table or a table variable to store the serial numbers and then use a SELECT statement to generate the serial numbers -- something like:

declare...

IN has the same execution plan as an INNER JOIN. EXISTS requires the use of a correlated subquery and is a form of RBAR that is sometimes faster than...

The ROUND function with the truncate option is definately the way to go... but why is it that you can't use the CONVERT function?

Thanks David... Heh... what I'd really like to do is raise a glass at the bar!:P

Sorry Robert... "OP" is forum shorthand for "Original Poster".

The thing is that the table I am retrieving the data from is a production/live database and cannot be modified, the formats...

Now, that's something I can definitely agree with! 🙂

harshil (7/8/2008)

---

Yes Mr. Actually I have read the requirements and I have correctly suggested the intended solution to delete duplicate records.

Although I have intentionally mentioned it for SQL SERVER...

Mark Horninger (7/8/2008)

---

I have to wonder if the people you're seeing are the exceptions or the rule....

I know one certified person who I worked with that didn't have a clue,...

The guy didn't even take the time to find out......

GilaMonster (7/8/2008)

---

I think it was a posting on these forums....

Based on what I've seen in real life at work...

5%...

Alright... I was hoping the OP would come up with something himself...

Here's a million rows test table... as usual, read the comments for what each column represents...

--===== Create and...