Cool, thank you Gail.

I'll show some cards here. I don't have the full process documented, but the results were pretty cool. Just a couple code changes, and a little index tuning brought this...

Jeff Moden (12/29/2014)

---

sqldriver (12/29/2014)

---

Jeff Moden (12/29/2014)

---

sqldriver (12/29/2014)

---

I'm not exactly sure how to test that, but I do have a 2014 Dev edition installed, and ran the below code.

If there's...

Jeff Moden (12/29/2014)

---

sqldriver (12/29/2014)

---

I'm not exactly sure how to test that, but I do have a 2014 Dev edition installed, and ran the below code.

If there's something in particular...

I'm not exactly sure how to test that, but I do have a 2014 Dev edition installed, and ran the below code.

If there's something in particular you'd like me...

Holy cow. Those are both way prettier solutions. Thanks to both of you.

I ran them on my test box and got close enough results.

Jeff, first, you need to apologize...

Jeff Moden (12/22/2014)

---

sqldriver (12/22/2014)

---

Jeff Moden (12/22/2014)

---

ScottPletcher (12/22/2014)

---

Jeff Moden (12/22/2014)

---

CELKO (12/22/2014)

---

Pull all the punctuation out and pad with digits as needed until you get the Standard International phone number. Let the...

Jeff Moden (12/22/2014)

---

ScottPletcher (12/22/2014)

---

Jeff Moden (12/22/2014)

---

CELKO (12/22/2014)

---

Pull all the punctuation out and pad with digits as needed until you get the Standard International phone number. Let the presentation layers handle...

DonlSimpson (12/10/2014)

---

Matt Miller (#4) (12/10/2014)

---

sqldriver (12/9/2014)

---

Grant Fritchey (12/9/2014)

---

Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other...

Borrowing from Scott's table code, and adding in Dwain's sweet pattern splitter[/url], which I used for a long time to 'clean' phone numbers. This will get you most of the...

Their one use...

It's funny, using this with another column of similar data works perfectly, if I stack new line and double new line char/nchar variations in a VALUES construct and use that...

spaghettidba (11/21/2014)

---

Thanks Brandie! We really needed the fantasy of a writer here 🙂

"The creepy DBA" - out...

ScottPletcher (11/20/2014)

---

Jeff Moden (11/20/2014)

---

ZZartin (11/20/2014)

---

There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one...

Jeff Moden (11/20/2014)

---

sqldriver (11/20/2014)

---

Jeff Moden (11/20/2014)

---

Sounds mean but my suggestion is that...