Split strings in columns to a new table

split-string-columns-to-table.sql

declare @table table(id int, strings nvarchar(400))
insert into @table (id, strings)
    select 1, 'abc,def,ghi'
    union all
    select 2, 'jkl'
    union all
    select 3, 'mno,pqr'

select * from @table

declare @results table(id int, string varchar(400))
declare @id int
declare @strings varchar(400)

set @id = 0

while exists (select * from @table where id > @id)
begin

    select top 1 @id = id, @strings = strings
    from @table
    where id > @id
    order by id asc

    insert into @results
        select @id, data from dbo.Split(@strings, ',')

end

select * from @results