You are quite welcome. Glad that worked for you.

If possible, can you post what worked you so that others who may stumble across this thread can see a working solution?

Another option would be to use Dwain Camps' pattern based splitter.

http://www.sqlservercentral.com/articles/String+Manipulation/94365/%5B/url%5D

select *

from dbo.PatternSplitCM('test1##test2##test3', '%#%')

where Matched = 0

vikramchander90 (2/6/2014)

---

Hi,

I have a variable of 40 characters length which contains a complete string. I need to split the string based on pattern

For example i...

MinhTuCSharper (2/6/2014)

---

Combine your advice together, should I secretly try to take MCSA SQL Server 2012 certification and then wait for my time to come to assume the role of DBA...

Yeah something like that. Notice the looping, this is a performance killer in sql. You have the added complexity of a number of value sets to use....

What you are describing sounds a lot like the classic bin packing problem. http://en.wikipedia.org/wiki/Bin_packing_problem

The reason you couldn't figure this out is because it is incredibly difficult. You have to try...

Ouch. An 800 million row heap?

Given that amount of data and that performance is going to be painful here is one idea.

Do a select distinct into a new table. Then...

Duck Season!!

Alex Grinberg-230981 (2/6/2014)

---

To send a table from .NET, you need to use DataTable. I wrote number of applications using this technique, now issues were found. If I have any issues,...

Just run the same query but comment out the where clause in the base part of the rCTE.

WITH rCTE AS(

SELECT CAST( CAST( ParentID AS varchar(10))+ '/' + CAST( ChildID ...

Did you execute a USE statement in SSMS? I have seen many times where that seems to totally confuse intellisense. If however, you use the combobox at the top it...

David McKinney (2/6/2014)

---

Damned if you do, damned if you don't!

I find the criticism somewhat harsh. Am I alone in thinking that articles don't have to be exhaustive? I...

QOTD probably.

Dwain you hit both things I was thinking myself.

To be fair there are two splitters posted. The first is the looping version. The second one is inside the usp_DelimitedString...

Reported as spam.