create procedure sp_split_string ( @string NVARCHAR(4000) ) AS BEGIN
DECLARE @object_id nvarchar(500) DECLARE @i INT DECLARE @len INT
IF (@string IS NULL) OR (LTRIM(@string) = '') RETURN WHILE CHARINDEX(',',@string) > 0 BEGIN SET @len = LEN(@string) SET @i = CHARINDEX(',', @string) SET @object_id = LEFT(@string, @i-1)
select @object_id SET @string = RIGHT(@string, @len - @i) end
SET @object_id = @string select @object_id end return