Wouldn't this be a little easier?

UPDATE #test_43

SET email=STUFF(email, 1, CHARINDEX('@', email)-1, LEFT(REPLACE(CAST(NEWID() AS VARCHAR(36)), '-', ''), 8));

Thanks for the plug Micky!

If you read the article, you should probably also look at the discussion thread:

http://www.sqlservercentral.com/Forums/Topic1559372-3529-1.aspx?Update=1

Claire,

Interesting article. I have indeed found cases where divide and conquer can be helpful to solve a really tricky query form. But I'm afraid I'm going to need...

h.tobisch (4/7/2014)

---

Dear Dwain

1. You write

"Because we know that SQL Server ignores NULL values when it constructs an INDEX. "

If I interpret your statement the way it was intended, then,

to my...

mister.magoo (4/7/2014)

---

Nice write up Dwain.

As with anything like this, whether this technique benefits you or not will depend on so many factors.

On my laptop, for instance, I see no difference...

Pavel Pawlowski (4/6/2014)

---

Hi,

thanks for the post and only a few comments.

You do not need to write CTE to get index seek in your case (where you have a lot of...

SQLRNNR (4/4/2014)

---

Well well well, another blog to read. I...

WayneS (4/3/2014)

---

dwain.c (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

You are welcome...

Lynn Pettis (4/3/2014)

---

TomThomson (4/3/2014)

---

Not...

Steve Jones - SSC Editor (4/3/2014)

---

You are welcome and good...

If it happens every...

Many thanks to Steve for syndicating my blogs on SSC:

DwainCSQL[/url]

And my apologies for making you work so hard at it.

I nominate this as about the most annoying SQL error message I've seen in a long time:

Cannot use the ROLLBACK statement within an INSERT-EXEC statement.

Koen Verbeeck (3/31/2014)

---

True dat...