It may sound like a DW solution, but actually it isn't. It will end up being more transactional in nature. The 180 months are projections into the future...

Thanks for the replies so far.

To answer some of your questions: We do use Excel pivot tables extensively. This was one of the reasons I chose to...

I recall a CBT I took a while back that demonstrated just this scenario. The topic of the CBT was Full Text Indexing in SQL Server 2000. It...