Performance may end up being important here, I've not decided, I may just pre-process the data in which case it's not overly important, thanks for the CTE example, I'll give that a look in a while - I've been meaning to investigate CTEs more so even if it's not used for performance gains I'd like to play with it!

Cheers!