Can you post the query (at least pseudo-code) so that we can help developping it?

How long does it take to run the query now?

I'm obviously way over my head in this thread... I'll let the gurus handle it.

INSERT dbo.Contacts(compID, first, last, phone, email)

SELECT compID, fname, lname, phone, email

FROM dbo.import_contact IC

WHERE not exists (Select * from dbo.Contacts C where c.compID = ic.compID AND c.first...

When are you increasing the alert count?

The Curse and Blessings of Dynamic SQL

I would strongly suggest a set based solution but this might be a hard one compared to dynamic sql.

http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

The question is more "Why are you designing the table like that instead of having a single date column?".

We can't help you without the trigger code. Can you send us the relevant part of the script?

Nothing's too easy or too hard for us .

Strange, maybe the bookmark lookup cost was too high compared to the scan... Would have too see the ddl and the data to be more sure.

You're right ron k .. I forgot to take in consideration midnight on the 2nd day with the between operator.

You pretty much said it yourself... You have the same cost but with 33% more rows in the select so one option seems better than the other. While I...

Counter_answer : that's already too many if you want my opinion. But I guess that it may become handy in very large data warehouses to be able to add...

Go buy one or contact idera for an extended trial version. You'll be lucky if you don't get banned from this board with a post like that.

[EDITED]

It's strange that...