Hope this helps.

One advice (i know people don't like advices, but i will have to tell it out :(), Please do not use a code in LIVE environment if u...

Actually ColdCoffee, I am trying to get my head around it;

If you can explain I would really appreciate it - thanx, Andy

Fantastic!

Thanks very much ColdCoffee

It is already working in the live environment 🙂

No that is not correct.

There are any number of "groups"...

My app is working perfectly fine using Stefan_G's second production (it seems to be the fastest apart from Paul's SQLCLR masterpiece)

Just a question based on this thread and the reason...

Yes thanks for that simple explanation.

I was actually stumped because the csi's (comma seperated integers) are in another table column and I was confused as to how to make that...

Are you sure that is correct? I get a different result from your original method.

And it takes a lot longer than 29 secs - more like 79 on my system!

Even slicker Stefan_G - Many thanks!

Well, here is an answer and pretty slick too 🙂

select number, c.proname from #table_s a

cross apply

iter_intlist_to_table(a.strInts) as b

inner join #table_p c

on b.number = c.idp

order by a.ids

with thanks to hanbingl ...

Thank you all very much.

I have implemented Pauls answer into my live code and it is working great!

Cheers

Andy

Well thank you for your prompt replies.

I was working on working out how to do as Jeff Moden says

Then I looked up and bingo the answer is there, twice!

I have...

Not happening for me too

Boo Hoo!¬! I WANT my point!!