Can you provide us with the DDL for the table(s), some sample data (as insert statements), and expected results based on the sample data. From looking at your picture,...

GilaMonster (7/21/2009)

---

Lowell (7/21/2009)

---

maybe one of the articles required registration on another site, so you duplicated the same email for registration for that article? check your cookies or firefoxes saved passwords...see...

Backups are not logged in the transaction log.

JohnSQLServerCentral (7/21/2009)

---

My software development company has under 50 employees. In addition to SQL DBA, I 'also serve as the Domain Administrator. I've been at this for 20...

The problem with @sql's version is that the AND in the WHERE clause should be an OR. Change it and check out the results.

I think its fun. Something different to make one think.

Looking closer at your code, this is in a trigger isn't it.

Why would you want to change from a set-based solution to a cursor-based (row by row) solution?

Your current method is more efficient.

Yes. and you are probably running on a X86 version of the OS as well.

What kind of standby are we talking about?

Triggers in SQL Server are fired once regardless of the number of rows inserted/updated/deleted. If the possibility exists, you need to code your triggers to handle multiple rows.

I'd start...

Having a DVR is great. It does allow me to watch my shows when I can get the TV.

Jack Corbett (7/21/2009)

---

I'm a little jealous. My wife isn't a big movie fan so we don't go, and I don't have NetFlix because it's just not the same if...

I have read the privacy statement and I don't see anything there that says that they sell their lists. They won't even send you thier own marketing emails if...

Not sure, but I think a paren may be missing. Could you also format your code so that it is easier to read. White space is your friend.