Hi,

You're right, using the Tally table is faster:

using this parameter:

DECLARE @Parameter VARCHAR(8000)

SET @Parameter = REPLICATE('Element01,Element02,Element03,Element04,Element05,',159)

So I got next execution times (running the same script several times):

- my function: 120 ~ 180 miliseconds

- Lynn's function: 90 ~ 140 miliseconds

- Jeff's function (a function created based on Jeff's example, using Tally table (already created on my database) : 90 ~ 140 miliseconds

Thanks!

Thanks.