Alan.B (3/20/2016)

---

quagmired (3/20/2016)

---

This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion...

Alan.B (3/20/2016)

---

quagmired (3/20/2016)

---

This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion...

Alan.B (3/20/2016)

---

quagmired (3/20/2016)

---

This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion...

Alan.B (3/20/2016)

---

quagmired (3/20/2016)

---

This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion...

Alan.B (3/20/2016)

---

quagmired (3/20/2016)

---

This is exactly what I'm talking about when I mention "cumbersome TSQL solution". For arbitrary 0s, I'd say a tally table would have to have over 2 billion...

Alan.B (3/20/2016)

---

I have to run and will be back later to add my 2 cents but here's how I'd do it.

USE tempdb -- safe place to test

GO

-- There's a...

Jeff Moden (3/19/2016)

---

quagmired (3/19/2016)

---

Jeff Moden (3/19/2016)

I'm a big fan of using the right tool to the job (even when others don't think it's the right tool). With that in...

Jeff Moden (3/19/2016)

I'm a big fan of using the right tool to the job (even when others don't think it's the right tool). With that in mind, what I'd...

Jeff Moden (3/18/2016)

---

quagmired (3/18/2016)

---

Jeff Moden (3/18/2016)

---

Starting thought.... Have you...

Jeff Moden (3/18/2016)

---

Starting thought.... Have you ever actually had...

Jeff Moden (3/17/2016)

---

quagmired (3/17/2016)

---

My personal favorite is, given the same accuracy, which ever is the fastest and least resource intensive. That's usually not REGEX as called from SQL SERVER...

My personal favorite is, given the same accuracy, which ever is the fastest and least resource intensive. That's usually not REGEX as called from SQL SERVER even when using...

This article is just another example of why lack of native "modern" regex support is holding back MS SQL.

replicate('_',fixedLength) ?

.{fixedLength}

.{min,max} ?

... like replicate('_',...) or ... like replicate ('_',...) or ......

Steve Jones - SSC Editor (7/6/2015)...

I'd agree with this. If you find SSIS difficult, use something else. However I also think MS should be improving things that are broken, like...

What about embedded...