Thanks Chris,
Appreciate the feedback.
Looks like i was close so thats always a bonus.
Ive never used ntile before and it certainly looks interesting (although its not suitable for this requirement).
Initially i think i will use your first suggestion and see how that goes.
Thanks (and to dwain for the setup code - will come in handy)