From a much less technical stance...

The only thing I haven't been able to do faster in T-SQL, so far, is RegExReplace and I still came pretty close.

rog pike (12/19/2008)

---

That strikes me as an interesting question. I'm not sure if it's the case that right now I...

Lynn Pettis (12/19/2008)

---

Okay, hows this??

create table #MyTest (

CompanyName varchar(50),

CompanyID varchar(10),

RegionID char(2)

);

insert into #MyTest

select 'ANDERSON DAIRY PRODUCTS ...

How do you figure that?

Heh... Just what you were hoping for, huh, Steve?

Let's try that again...

--===== Create artificial rows where all inclusive dates are in place for each Person_ID

SELECT ISNULL(ROW_NUMBER() OVER (ORDER BY aid.Person_ID, aid.Event_Date),0) AS RowNum,

...

Hang on a minute... I'll fix the smiley faces...

I think this will do it very quickly using the ol' "Divide and Conquer" methods. Side benefit it that it doesn't affect the original table... it makes a brand...

If there were a table creation statement and those were insert statements, I know someone that might show you how...

Heh... thanks for the feedback... didn't mean for it to be so stark. :hehe: Any questions on how that works?

psmg01 (12/18/2008)

---

Hi Jeff,

I tried your tally table and splitting the string as rows in a table output.

But how to make them as columns? or use crosstab to make it as...

Chad Crawford (12/18/2008)

---

Jeff - I really appreciate your time and if you think the nested set is superior, I would appreciate some additional thoughts to help steer me in...

dejanette.gordon (12/18/2008)

---

It sure is...it can be downright grueling and discouraging for a newbie if one takes it personally. But hey, my post was kind of simple and "cheesy" based on...

bnordberg (12/18/2008)

---

The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we can't find...

Chris Morris (12/18/2008)

---

Jeff, I was hoping you'd take the bait...proof of concept is one thing, turning prototype code into 'nasty fast' production code is entirely another. My query will not...