Holy good night...I just read the entire article and the comments, and that brought me right back here to look at DelimtedSplitN4K or DelimitedSplit8K from Jeff Moden, so I spoke...

Thanks very much for the nudge...

I found this http://www.sqlperformance.com/2012/07/t-sql-queries/split-strings

which was great summation of the blizzard of solutions I found here, which was kind of an embarrassment of riches...

Thanks for that...it was the push I needed to make a recovery set for the mother ship :hehe:

The article was GOLD, enormously instructive. My own issue is that while this is a river I have yet to cross, I will be doing it on vmware workstation...any advice...

Thanks so much Lowell for the link!

It was a great reference and huge leg up, a great tactic, but I still am mulling strategy.

Greg and Nadrek

I don't have the juice...

I appreciate the guidance

Thanks a ton.

This thread has been an enormous help to me, thanks a ton

long story short, gots to save my nickels and dimes for VMware.:-D

Thank you so much for your confirmation, even though I wouldn't call it good news

That said, I did get a real good laugh out of seeing you described as a...

Thank you for your help...going over your correction, I realized that i could make the problem smaller by putting an index over carrier and benefit start date then attack each...

please forgive me, it was too late to edit but I just noticed that I forgot to include rownum int as the last column in the create table statement

Perfect!

Thanks very much, I appreciate it

Embarcadero ER Studio might be worth a look...

Thanks....I think

omg I feel like such a complete knucklehead

:blush::(

I apologize for the original error, and want to express my gratitude for the time and effort you all spent on my problem. It was a great lesson in so...

Holy good night!

You guys are making me dizzy!

What great ideas....thanks a ton