create proc [dbo].[CreateArray]@string varchar(1024)
as
create table #array (id int identity,value varchar(32))
set @string='insert #array select '''+replace(@string,',','''as str union all select ''')+''''
exec(@string)
select * from #array
go
exce createArray 'sdks,sds,sdsd'