Cheers Guys.

Jeff - Yup I thought about adding ROW_NUMBER() too for the same reason Luis made about missing ID's (thanks Luis)

Dwain - Cheers to your feedback. Nice to see lovely...

Thanks ColdCoffee and Jeffem - Appreciate the replies. Will give these suggestions a try.

My original attempt to code this problem ended up being a ugly cursor - I knew the...