OK I'll take a look.

(on 'seriously', it was said with a wounded tone).:crying:

Seriously? No one could answer that question?

I went to Tally Table site http://www.sqlservercentral.com/articles/T-SQL/62867/ folks here recommended. Would love clarification on how a loop for extracting the strings between a delimiter works, using his example.

--=============================================================================

-- ...

Yes, I know about what you're talking about. I was lucky to once have a great manager tell me what an awesome job I did after I banged my...

Hi Luis, thanks. Yes, that's the standard application for a splitter. I got it. I guess I love the scenarios behind the scenes.

Delicious got the Ace on...

Luis Cazares (5/30/2014)

---

Another use is to work with parameters that work as arrays contained in strings.

I know that this can be done using table-valued parameters but some might like the...

Cool, will try it. I do come back here to review old posts and sometimes have a hard time finding by my moniker. Thanks.

Luis Cazares (5/30/2014)

---

I added that thread to my briefcase because I'm sure it might get handy some time. I use a digital camera for my photographic memory but from time...

SQL is delicious (5/30/2014)

---

KoldCoffee (5/29/2014)

---

OK I'm taking a look at Delicious's first. So, basically you have the equivalent of a build-a-bear business, with nearly limitless variations available though the...

OK, thanks everyone. Luis's is actually a reverse splitter, the way I see it.

A quick overview of splitter options including Jeff Moden's high performance TSQL approach is here

thank you Luis! that is so nice of you. Got it and reading other post.

OK, the link works for me now. The example there is formatted exactly same way as here and wondering if you could put each of the four STUFF parameters on...

it's a no good link

I know that STUFF takes 3 parameters: (the string, the starting position, the number of characters to delete) but I can't break Luis's TVF into those three. Can you...

OK I'm taking a look at Delicious's first. So, basically you have the equivalent of a build-a-bear business, with nearly limitless variations available though the combination and recombination of...