I can post sample DDL and DATA if people think that would be useful.

However, I'm really looking to see if someone has a different approach to the problem.