That's just mean 😀

Sometimes the OP finds the solution a couple of minutes after posting the question and posts the...

Could you mark all of them?

This could be called as the green thread 😀

I agree that we should disagree. :hehe:

There seems to be a new feature in the forums to mark answers that worked for the OP.

What do you think about this? I'm not sure if it's only possible...

OP stands for Original Poster. That's...

Sean Lange (2/6/2014)

---

ChrisM@home (2/6/2014)

---

Hey Luis I don't know if you can see what I've just seen on this funny little mobly but you my friend may just be the first!...

This is an old thread but I would suggest a different approach. It might get give better results performance wise.

/*

Example:

SELECT dbo.CHARINDEX2('a', 'abbabba', 3)

returns the location of the third occurrence of...

I added some comments to the original code that might help you to understand what's going on.

I've been thinking on what to answer here. It seems that you haven't understood the query. I could get the result, but I want you to try harder and research...

Please don't post in several forums, you'll just divide the possible help given to you.

All answers should go in: http://www.sqlservercentral.com/Forums/Topic1538780-391-1.aspx

You're welcome.

But, do you understand how does it work?

Even if the article is not related directly with this problem, it gave me the idea for the CHAR(7) option. 🙂

http://www.sqlservercentral.com/articles/T-SQL/68378/

That splitter is made to split string when the delimiter is not a constant, because it won't perform...

Maybe something like this could work.

WITH cteTally AS(

--Use TOP to return only the number of rows needed for all ranges

SELECT TOP((SELECT MAX([End]) FROM @ranges) - (SELECT MIN([Start]) FROM @ranges) +...