BWFC (9/8/2015)

---

SELECT

ltrim(right(postalcode,charindex(' ',reverse(postalcode),PATINDEX('% %',reverse(postalcode))+1)))

FROM yourdata

I've tested this over 14500 county+[space]+postcode combinations and the only ones it didn't work on were cases where there was no space in...

Koen Verbeeck (9/8/2015)

---

It's...

Pack_Star (9/8/2015)

---

Hi All,

I believe that this could be possibly be resolved with a Case Statement?

The select needs to do the following. If there are three separate strings in the...

SQLRNNR (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

SQLRNNR (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Sean Lange (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Brandie Tarvin (9/4/2015)

---

I just came up with the great "customer friendly" metaphor for table contention.

One business unit wants to know...

SQLRNNR (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Sean Lange (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Brandie Tarvin (9/4/2015)

---

I just came up with the great "customer friendly" metaphor for table contention.

One business unit wants to know why production report...

Sean Lange (9/4/2015)

---

Alvin Ramard (9/4/2015)

---

Brandie Tarvin (9/4/2015)

---

I just came up with the great "customer friendly" metaphor for table contention.

One business unit wants to know why production report X was timing...

Jeff Moden (9/3/2015)

---

So, if the run you kill...

Brandie Tarvin (9/4/2015)

---

I just came up with the great "customer friendly" metaphor for table contention.

One business unit wants to know why production report X was timing out, so I went...

Ed Wagner (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that...

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire...

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire MSDN web site to...

If I weren't planning on 2 weeks vacation real soon, I'd be off tomorrow.

Eric M Russell (9/3/2015)

---

Years ago I was involved in a SQL Server 2000 -> 2005 migration. There was a 3rd party hardware interface application that would not connect to SQL...

Memorizing all the parameters of DBCC TimeWarp is something I would recommend not be skipped....

ChrisM@Work (9/3/2015)

---

John Mitchell-245523 (9/3/2015)

---

It's got to be TextData, hasn't it? That's the only string or binary column that's being inserted. Looks like you've captured events in your trace...