The insertion order matters because when I read the data back in my hierarchy information is built/displayed starting from the top on down.

Clustered Primary Key? Would that be like...

Thanks for the suggestion.

For some reason I thought I had tried that and what happens is the records do disappear. But tne new table does not have the records in...

Your assumption is correct. We felt we had to prepop a quarter table to get out what we wanted.

Absolutely incredible. Thank you very much. I had no idea what a cross join was or that it even existed. We are cheering in the streets here.

Thanks.

I don't plan on the in list being more than 50 people. But who knows.

I must have had another issue. It seems to be working now.

Thank you all for the function, etc. I learned quite a bit - for example I did not...

I tried that split you gave me and like I thought it is splitting OK. I get a vertical array.

I should clarify what I am trying to do. The select...

Thanks all for the response.

Should this work with a view also? Here is the query I want it to go into and it still will not work with the...