Subject: Tip that pays off B-I-G

From: Out-Of-Control Weight-Gain? <[email-masked]>
Date: Thu, 07 Aug 2014 08:26:47 -0700

Want to Lose Weight without Being Hungry?

Doctor Oz is going to help You do it in 14 Days.

What is Your Weight-loss Goal?

Choose your Goal:

Lose 1lb per day
Lose 1lb per day
Lose 5lbs per week
Lose 20lbs in 3 weeks
Lose Belly Fat
Lose Arm Jiggle
Curb Your Appetite
Lose 2 Dress Sizes
Other

The key to slimming down is burning calories around the clock while still eating carbs and w/out working out!

View DocOZ Clip Here

To modify message settings write Current Update Alerts 1644 Doral Dr /Brookings, SD 57006 or visit here

f I may add: The accepted answer doesn't work with tables that uses uniqueidentifier. This one is much simpler and works perfectly on any table. Thanks Martin. This solution worked extremely well, thanks. love it. cleaned up a huge mess for me in no time at all is is the only solution that is workable on my large table (30M rows). Wish I could give it more than +1 Julia Hay is such an awesome answer! It worked event when I had removed the old PK before I realised there where duplicates. +100 replaced Col1, Col2, Col3 with a BINARY_CHECKSUM(*) call in the PARTITION BY CLAUSE and had good results, saved myself specifying 30+ columns on some large tables. suggest asking and then answering this question (with this answer) on DBA.SE. Then we can add it to our list of canonical answers. Does anyone know how I could return the number of duplicate records in this same query while also deleting them? I believe, while using the With statement, you can only reverence the temporary
cte once, correct? DDiVita - If you just want to know how many rows were deleted look in the messages tab in SSMS for the rows affected message for more complicated needs look at the OUTPUT clause. nlike the accepted answer, this also worked on a table that had no key (RowId) to compare on. vossad01 Mar 4 it has synonym syntax: delete t from (select ROW_NUMBER() OVER (PARTITION BY name ORDER BY (SELECT 0)) as rn from @table) t where Great solution as can also be used on tables with a compound primary key. Just FYI this article on codeproject works as e Already mentioned in this answer. Unless you are stuck on SQL Server 2000 that seems unnecessarily cumbersome and inefficient compared with ly what it means to say VB is case-insensitive and how it's implemented. The question of whether it's better for a language to be case-insensitive may, sadly, start a flame war. If you're really curious, ask it in another question. (I advise you not to, but if you must then tag it subjecti
ve and make it community wiki) MarkJ Feb 22 '10 at 10:22

@MarkJ - yeah, I hear ya. The question on whether or not it is case sensative was emphatically answered, and that is what I was really looking for. On the why sensitive/insensitive is better/worse, I was trying to see if there was an exact technical "better" like x386 chips are faster than x286 chips but it appears that there isn't a technical reason (that was supplied) so I don't think the second question could be answered. Todd Main Feb 22 '10 at 16:23