I did a test using a string parser, which returned 512 records, the XML parser took cosistantly 2 ms and my string parser bounced between 0 and 1 ms.

However, I'd...

This is the function that I am currently using, is it more efficient than the CTE ?

create FUNCTION [dbo].[func_CreateClientTableOrdered]

(

@item_list as varchar(4000)

)

RETURNS @Items Table(OrderNo int, Item varchar(60))

AS

BEGIN

declare...

I like your function, because you use a CTE.:-D

I've been learning how and when to use CTE's and this is just another item that has helped me to better understand...