Thank You All - Chris Harsham, ZZartin, Grant Fritchey and Jason A. Long
Not easy to comment without code - I know - but your answers were exactly the sort...

Thank you to everyone for helping out... I will investigate the replies and mark up the answers in due course
I will also check out Jeffs guide on encapsulating IF...

Hi Drew,

Love the "There is no spoon" reference... 🙂

And having read your response - hits forehead with palm - of course of course of course 🙂

Thanks for the beautifully put...

Hear hear Luis - and yes that's exactly how I see it - a great learning opportunity 🙂 - and yes given the partition approach it does alleviate the...

Lol Kevin - wish I was on the same rate you were 🙂

Thanks for looking at this Luis...

The good news is that I had already adopted the windows partitioning approach as you suggested - so good to know I was heading in...

To anyone interested...

Underlying cause for the my original WHERE {field on table} IN @{Multi-value Parameter} issue not working as usual

Symptoms - Query working in SSMS and SSDT Query Builder but...

Hi Sergiy

Thanks for this... a whole new arena to get to grips with.... Tally Tables...

I did a little reading up last night and this approach will prove most useful

Thanks

Thanks Alan

Beautifully and succinctly put... I now also understand yours and Gail's reference to it being a table valued function

I have now successfully added function... and have executed the simply...

Hi Luis,

I guess why I am confused is that I am not trying to split a string based on a delimiter - I am trying to build a string with...

Thanks Gail - love the Qui-Gon Jinn icon 🙂

Looked at the article and slightly confused as to how to utilise the function... no I lie - correction - I am...

Thanks John - CTE - perfect thanks