Hmmm.... I thought this looked familiar. I recommend that we take our posts to the nearly identical post listed here http://www.sqlservercentral.com/Forums/Topic1401136-392-1.aspx#bm1401339 because it more correctly identifies the request and the reason why this task is actually impossible with the current data given.
--Jeff Moden
Change is inevitable... Change for the better is not.