Jack Corbett (8/29/2014)

---

Sounds like a good use for RowNumber() something like this (since I don't have your schema I'm just guessing at some things see the first link...