I completely agree that the set-based splitter is the right approach, but what if someone has a name like 'Georges St. Pierre' and you want to split it based on...

mister.magoo (3/30/2015)

---

Ed Wagner (3/30/2015)

---

Jeff Moden (3/29/2015)

---

I'll have to disagree with that. To me, an empty string or the number 0 is...

Not terminating statements with a semicolon is not only...

Warm

Add me to the list of people who understand the difference between a terminator and a begininator. A statement terminator belongs at the end of a statement and nowhere...

Jeff Moden (3/29/2015)

---

I'll have to disagree with that. To me, an empty string or the number 0 is nothing. Null...

Growth

Jeff Moden (3/27/2015)

---

SQLRNNR (3/27/2015)

---

Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on...

TRS-80

Sean Lange (3/27/2015)

---

Luis Cazares (3/27/2015)

---

In a different order of ideas, I want to share with you my happiness.

Starting on April 21st I'll be working in the US. I'll make a...

Handy

Ford (I've actually ridden in a model T...

Adding to the pile. Triggers themselves aren't bad, only poorly-written ones. Functions themselves aren't bad, only poorly-written ones. One example of bad is what Grant said. ...

No problem. That type of thing can be difficult to track down sometimes. I'm glad you found your answer.

TomThomson (3/27/2015)

---

Jeff Moden (3/26/2015)

---

My recommendation would be to do those kinds of checks externally rather than adding them to the function. Changes for convenience will slow things down when...