RETURNS @Strings TABLE (
		position INT IDENTITY PRIMARY KEY
		, value VARCHAR(8000)
		)

AS BEGIN
	DECLARE @index int
	SET @index = -1

	WHILE (LEN(@text) > 0) BEGIN
		-- Find the first delimiter
		SET @index = CHARINDEX(@delimiter , @text)

		-- No delimiter left?
		-- Insert the remaining @text and break the loop
		IF (@index = 0) AND (LEN(@text) > 0) BEGIN  
			INSERT INTO @Strings VALUES (@text)
			BREAK 
		END 

		-- Found a delimiter
		-- Insert left of the delimiter and truncate the @text
		IF (@index > 1) BEGIN
			INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))
			SET @text = RIGHT(@text, (LEN(@text) - @index))
		END
		-- Delimiter is 1st position = no @text to insert
		ELSE SET @text = RIGHT(@text, (LEN(@text) - @index))
	END
	RETURN
END

insert into order_items (order_id, qty, units, description, cost, invoice, invoice_id) values('10012', select value from fn_Split(select value from fn_Split(@items, '|'), ','), 'N', NULL)

	declare @values varchar(255)
	declare @iStart int, @iEnd int, @int_error int
	set @int_error = 0
	set @iStart = 0
	set @iEnd = 0

	while @iStart <= len(@p_items) - charindex('|', reverse(@p_items)) + 1
	begin
		set @iEnd = charindex('|', @p_items, @iStart + 1) - 1
		if @iEnd - @iStart <= 0
			set @iEnd = len(@p_items)+1
		select @values = substring(@p_items, @iStart + 1, @iEnd - @iStart)
		exec('insert into order_items (order_id, qty, units, description, cost, invoiced, invoice_id) values (' + @order_id + ', ' + @values + ', ''N'', NULL)')
		set @int_error = @@error
		if @int_error <> 0
			set @items_err = @int_error
		set @iStart = @iEnd + 1
		if @iStart = 0
			break
	end