peter-757102 (11/13/2009)

---

There will be a distinction in software that needs more power and has to go multi-threaded or at least be aware of it and thus require subsequently more programmer...

michael.rosquist (11/13/2009)

---

I find VB.NET better.

3. C# is harder to read (and uglier) due to parentesies and brackets:

C#

public static void HandleControl(System.Web.UI.Control oControl, System.Type oType,

ProcessControlDelegate controlMethod, DelegateArgs delegateParam, bool...

I guess I just haven't come across a situation where this is necessary. If you are only inserting a few rows (OLTP) then what is wrong with simply concatenating multiple...

Lynn Pettis (4/29/2009)

---

Yes, there are technical differences.

From BOL:

Columns that are of the large object (LOB) data types ntext, text, varchar(max), nvarchar(max), varbinary(max), xml, or image cannot be specified as key...

Jeff Moden (4/29/2009)

---

Scott Roberts (4/29/2009)

---

Sorry about the confusion over mis-matched data sizes for RawData. The RawData column used to be VARCHAR(300) but we encountered a new format that is longer...

Lynn Pettis (4/27/2009)

---

Jeff,

I knew you'd have a bit to say here when you read it. I modifed his table def for RawData to match the def in his cursor...

Jeff Moden (4/27/2009)

---

Just a parting thought. I recommended working on a staging table with separate columns and indexes on the couple of columns that actually determine a dupe CDR....

Lynn Pettis (4/27/2009)

---

Not sure, but the fact that you are apparently doing this for call records, I'd assume that there would also be date/time values, elapsed time values, from/to phone...

Lynn Pettis (4/27/2009)

---

As stated in later posts, i personally think there is more to the DEDUPE requirements, and based on the what the OP provided, we both have provided a...

And hopefully an occassional "thank you". Although I'd be obliged to agree if you don't consider that much of...

Thank you both very much for your solutions. I will definitely give both of them a try on larger data samples.

As for row sequencing, is it not invalid to assume...

Actually, it doesn't.

Check your results against the "expected results" in post #3 again....

I'm certain that you (and everyone else in these forums) is keenly aware of the pros and cons...

Oops. The RowId column (or "Id" column) is a uniqueidentifier so "MIN(rowid)" doesn't work. I don't see a "First()" function for SQL Server. Any other ideas?

Thanks Bob. I noticed that your original solution generated 4 table scans on the main table (that has millions of records) but I was reserving judgment until I ran some...