create procedure sp_test(@var varchar(1000))
as
begin
create table #t(col varchar(100))
set @var = @var+';'
while(charindex(';',@var)>0)
begin
insert into #t select left(@var,charindex(';',@var)-1)
set @var = stuff(@var,1,charindex(';',@var),'')
end
select * from #t
end