If the table is denormalised and has Comma Seperate Values in a column, this code will copy it to Multiple columns of a Normalised table declare @DeNormalisedTable table(data varchar(8000)) insert into @DeNormalisedTable select '1,Davolio,Nancy' union...