Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @list varchar(MAX), @i int
- select @i=0, @list ='4,7,12,22,19,'
- while( @i < LEN(@list))
- begin
- declare @item varchar(MAX)
- SELECT @item = SUBSTRING(@list, @i,CHARINDEX(',',@list,@i)-@i)
- select @item
- print @item
- --do your stuff here with @item
- --exec p_MyInnerProcedure @item
- set @i = CHARINDEX(',',@list,@i)+1
- if(@i = 0) set @i = LEN(@list)
- end
Add Comment
Please, Sign In to add comment