quote:

---

declare @CT int

set @CT = 1

while @CT > 0

begin

insert into #tableb select LEFT(Team,CHARINDEX(',',Team+',')-1) AS 'Name',CallID from #tablea where Team <> ''

update #tablea...

Actually, when I wrote the question, I was thinking multiple columns, however, I think what I need is each list member will become a separate record. I have two...