Just saw a message from the recruiter, Jeff. You...

Not sure about the company, but you are correct about Connecticut.

Jeff Moden (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and...

Hugo Kornelis (6/7/2016)

---

GilaMonster (6/7/2016)

---

What I've advised for years is to notify on lack of success (eg: have a monitoring server check that the backup ran, and if it didn't, send...

I decided to look at the msdn page referenced and I was amazed!

Not ONE of the sample CTEs was started with a semicolon. The CTE was either the first...

I still think points should be awarded back, and I don't usually advocate this position.

Luis Cazares (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Sounds interesting, unfortunately New York City isn't really where I would like to work. Too bad this may not be a position open to a...

Sounds interesting, unfortunately New York City isn't really where I would like to work. Too bad this may not be a position open to a remote position.

I would use REPLACE to replace the unwanted word with an empty string.

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that you should answer on your...

Not sure if this will be any better, but it is what I would have written.

with basedata as (

select distinct

email

from

dbo.[UMG sent 2016]

)

select

...

jasona.work (6/7/2016)

---

Lynn Pettis (6/7/2016)

---

Jeff Moden (6/7/2016)

---

It was almost as sarcastic as using LMGTFY...

Jeff Moden (6/7/2016)

---

It was almost as sarcastic as using LMGTFY but I'm absolutely...

Luis Cazares (6/7/2016)

---

That's why...

But it is encouraging it.