below86 (1/15/2014)

---

Steve Jones - SSC Editor (1/15/2014)

---

below86 (1/15/2014)

---

You get pulled into so many different projects with so little time it impossible to 'craft' the perfect solution. As they say...

I'm not sure what you need.

If your strings have different structures, you might be in serious trouble.

Your function might cause serious performance troubles. As I told you before, you should...

One more reason for me to avoid index query hints, unless it's completely necessary and throughly tested.

It's working correctly for me today.

Thank you.:-)

I was thinking this could be a complex split and join strings based on patterns, but I found a possible better way which you can transform into an inLine Table-Valued...

You don't have to apologize. It's only that we can't see what you see to help you.

If you post more details, you'll have an answer in a short time.

To get some help, you need to at least post your query. For best answers, include DDL and sample data as well. You can find details on how to do...

That's great. Even if I only pointed out the article.

Under normal conditions, I would have given a try to give you a coded solution but today I can't think...

I'm having the same issue.

Does this article help you?

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

Note that this is a thread over 3 years old.

However, it's nice that you try to help 😉

Be sure to understand all the code, because you'll have to modify it and support it.

If you have any questions, feel free to ask.

Welcome to the forums!

You have a nice problem here that will help you to learn a lot.

First of all, it's considered "best practices" to post DDL and sample data in...

Polls won't allow multi-line answers, but it's a nice output 🙂

I can't find the insult on Phil's comments. He's just asking you to provide better information when you post questions, it has nothing to do with your knowledge.

Jeff and I...