Yes it does,

CREATE TABLE [dbo].[Tally](

[N] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PK_Tally_N] PRIMARY KEY CLUSTERED

(

[N] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS =...

Interesting, Thanks for your help on this, much appreciated.

OK, this works...

createFUNCTION [dbo].[FN_SplitCommaInClause]

(

@ItemList NVARCHAR(4000),

@delimiter CHAR(1))

Returns TABLE

AS

RETURN

...

The first split function returned both an index and value. What is the best way of incorporating this into the second cte function?

Wow, the split function above made a huge difference. It's really fast now. I've attached the query plan for comparison. I ran sp_who2 and i didn'tget any spid repeating.... Do...

ALTER FUNCTION [dbo].[FN_SplitCommaInClause]

(

@ItemList NVARCHAR(4000),

@delimiter CHAR(1)

...

here are the 32 vs 64 bit plans for the same query

Extra info - 32 bit machine is a dual core (3gb ram), 64 bit is a quad core (12gb ram)