TheSQLGuru (12/25/2015)

---

Jason A. Long (12/25/2015)

---

TheSQLGuru (12/25/2015)

---

How about I do a remote presentation of my Common TSQL Mistakes session? I have presented it somewhere around 100 times now for companies, User...

Gail - That's a HUGE one where I work! Our code is littered...

The one I came across a couple days ago...

WHERE LEN(t.SSN) = 9

as opposed to

WHERE t.SSN LIKE [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]

Jeff Moden (12/25/2015)

---

Jason A. Long (12/25/2015)

---

Jeff Moden (12/25/2015)

---

Jason A. Long (12/25/2015)

---

Come to think of it, I had planned to write an article about creating an insanely fast "Working Days" iTVF...

Jeff Moden (12/25/2015)

---

Jason A. Long (12/25/2015)

---

Come to think of it, I had planned to write an article about creating an insanely fast "Working Days" iTVF I built a few months...

Jeff Moden (12/25/2015)

---

Here's one thing that you should talk about... not subscribing to the absolute belief in "best practices" even if millions of people subscribe to a given "best practice"....

Jeff Moden (12/25/2015)

---

Or, like MS did...

TheSQLGuru (12/25/2015)

---

How about I do a remote presentation of my Common TSQL Mistakes session? I have presented it somewhere around 100 times now for companies, User Groups, SQL Saturdays and...

Fortunately,...

As always, your kind words are very much appreciated. 🙂

As far...

Goodbye...

Yikes... That's what I get for...

Basurmanin (12/24/2015)

---

Hi all,

i have the next problem:

i need to extract numbers from a string.

Without using CTE, func, proc. Just query.

Restrictions - varchar (50)

Let`s take this example

select 'aGk5kyO8pfas2csd444567' as word union...

Unless you're using recursion, a CTE can be rewritten as a derived table... Considering that derived tables (and CTEs) are processed before the outer query, CTEs can allow the code...

Jeff Moden (12/23/2015)

---

You've fallen into the same trap...