I wish I was. It's not installed on this server and neither can I actually install it. I'm doing this direct into SQL Server Agent.

Will not do or does not do?

Could you post some sample data please? It will make it much easier to establish what's wrong if we've got an idea what...

The owner of the job is me and the job is run by svc_xxxxr2Agent. Both accounts have sa access and datareader and datawriter enabled.

It also seems that it's one...

Hi Imran,

welcome to the forum.

Try joining to the General Ledger Table with a LEFT join. That's only a guess mind you. If you go to the link on...

Singer

It should just be O'Gara, there's quite a few names with Name #D in the list as it turns out.

The good news is it appears it's not a...

Eric M Russell (10/10/2014)

---

Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good...

Road

I'm not sure your link is right Steve. It takes me to a Beth Schultz article about Big Data and Analytics.

Luis Cazares (10/9/2014)

---

Erin Ramsay (10/9/2014)

---

To avoid results like O'GaraD you're going to have to employ logic such as (possibly):

Any characters that occur BEORE or AFTER an invalid character are also...

+1

I misread the BOL page and didn't see the bit that told me what I was reading about. I just saw a particular line and thought...

Thanks Eirikur and Koen.

I'm going to pursue the CTE approach for the time being I think. The solution Eirikur proposed is close but still returns incorrect characters. There's...

That's a phrase I've seen a lot around here but I wouldn't know one if I was served it for lunch 🙂 Are they something that we can do...

Pogo

No, it's not just you. Although you're going to have to keep a eye on the Recent Forum Posts...