create proc proc_split_str(@param varchar(100))
as
BEGIN
DECLARE @temp varchar(100)
set @temp=''
while charindex(',',@param)>0
begin
SELECT @temp=left(@param,charindex(',',@param)-1)
set @param=stuff(@param,1,charindex(',',@param),'')
select @temp
--insert into test select @temp
end
--insert into test select @temp
select @param
END