Quoting the OP's first post:

it seems like the major issue is the alphanumeric key. Therefore neither...

What is the business case you need to deal with?

Basically I see two options:

1) if possible at all modify the trigger to deal with all rows at once or

2) import...

olie480 (4/2/2010)

---

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...

Your assumption is...

cgreathouse (4/2/2010)

---

Excellent! I'm now getting a duration of 1 ms and with only 3 reads!!

Could you explain what's going on here to make it so much faster?

Thanks!

....

this one

WHERE...

Thank you Jason for detecting my simple but most relevant mistake.

Since my error rate increase dramatically at the moment (in another thread I just forgot that table variables where introduced...

CirquedeSQLeil (4/2/2010)

---

...

My concern is due to the ands

WHERE LOW >= 982827279

AND LOW < 982827279 +1000

AND HIGH <= 982827279

Since the High and Low are the same value - it...

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 used...

That's weird...

Here's the result in the Results window when running the modified query as you posted:

CustNumberFirstNameLastNameCity

345321JohnDoeKellogg

459978JohnDoeKellogg

Message window output:

(4 row(s) affected)

(2 row(s) affected)

The total number of columns doesn't really matter as...

CirquedeSQLeil (4/2/2010)

---

lmu92 (4/2/2010)

---

Is there any change to have a known maximum range between LOW and HIGH?

If so, you could base your query on the LOW column to narrow down the...

Is there any change to have a known maximum range between LOW and HIGH?

If so, you could base your query on the LOW column to narrow down the number of...

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 459978...

Grant Fritchey (4/2/2010)

---

Using a number does make sense, but I wouldn't suggest you use NUMERIC. The NUMERIC(12,0) suggested is 9 bytes in size. An INT is only 4 bytes and...

I truly hope the...

Something like this?

CREATE TABLE #TableA ( id INT,columnA VARCHAR(200))

INSERT INTO #TableA

SELECT 1,'here is my phone number 12345678. but my cell is 44444444.' UNION ALL

SELECT 2,'987654321 is my balance' UNION ALL

SELECT...