Thanks for posting the data, but if you could post it in consumable format, then people could help you a lot easier - and you would get tested solutions. This article will show you how to post in a way to get the best help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you post CREATE TABLE and some INSERTS (enough for people to see the problem)... if you have confidential data in your table(s) feel free to obscure it (or if it's not necessary, leave it out).