Great question, thanks.

Beeeuuuuuuhhh...

Jason-299789 (11/14/2014)

---

Koen Verbeeck (11/13/2014)

---

The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.

ps: the semicolon is a statement terminator, it has no...

The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.

ps: the semicolon is a statement terminator, it has no business being there...

This article explains the most of it:

Understanding SQL Server Backups

Nice question, thanks.

Great question, thanks!

Jeff Moden (11/12/2014)

---

If the email address are, indeed, prevalidated, then there's no need for a triple reverse nor any use of DelimitedSplit8K, which actually returns too much information in this...

Linked servers typically perform worse than queries in the same instance.

Personally I try to avoid them at all costs.

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

David Burrows (11/12/2014)

---

However max(rate) over( partition by product) will not work if the rate varies +/- and the latest value by date...

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

In that case...

Please be aware that this is a forum of volunteers, where most of them have day time jobs as well.

In that case an ORDER BY on...

Ed Wagner (11/12/2014)

---

I hope you've already validated the format of the email address in your table. Koen's solution is probably (I haven't tested against other possibilities) screaming fast, but...

SELECT Email = 'a@abc.com'

INTO #emails

UNION ALL

SELECT 'a@abc.com'

UNION ALL

SELECT 'a@aasdf.com'

UNION ALL

SELECT 'sfawsed@dfsdf.com'

UNION ALL

SELECT 'asdfasdfasdf@asfdsbc.com'

UNION ALL

SELECT 'dffa@abc.com';

SELECT REVERSE(SUBSTRING(REVERSE(Email),1,CHARINDEX('@',REVERSE(Email))-1))

FROM #emails;