Hi Guys,

Thanks for the continued input. I stopped DBA'ing about five years ago hence a bit rusty.

I'll test all the solutions against the database (c2M rows) and post back the...

Thanks for all your help, as the man in the Visa advert said 'That will do nicely Sir'

Re : Now find out how many mussels a mussleshucker could shuck if...

Hi Rufio,

Firstly:

Thanks for the pointer to the article. It was functionality that I was unaware of in SQL Server.

Secondly:

Your code seems to be almost there.

I chose some raw data:

SELECT ...

Thanks for the code but unfortunately it returned zero rows.

Paul