ChrisM@Work: I have never used cross apply before. Will have to study that one.

I see you placed an group by...

Is this needed or optional.

I am trying your version now, withoute hte group by.

It seemes to query, bit slow maybe, I will have to evaluate when finished.

BR

Dan