Thanks for that.

I will stick with a CTE for now, as my data currently is only 400 rows post CTE function, well below the CTE limit. I have added the...

Kind of managed to get it working using a CTE

WITH CTE AS

(

Name,

StartPosition,

EndPosition,

'' AS Position,

Height

...

ok, epic fail on my part. I'm not advanced enough with TSQL to be able to add based on a tally table where the tally is unique depending on the...

Thanks mister.magoo I'll have a read and see how I go.