Thanks for the reply.

Derived column - yes, that sounds like a plan.

The number of updates would be an issue for speed, I think - which I why I initially favoured...

[BUMP]

My solution as described above, even after refinement and indexing, is still too slow - has anyone any different thoughts on a way to do this?  One possibility I'm thinking...

Thanks for everyones input - I got it working by my original method, posted here if anyone's interested.  It took a long time to run (6 hours on a decent...

Thanks for the replies.  The solution I had in mind was more like David's interpretation than Marco's, but both were gratefully received.  My initial post wasn't all that straightforward to...

There isn't any official news on the replacement for the P4 as yet - the original replacement (codenamed Tejas) was officially cancelled in May.  There seem to be a couple...