Sounds like you need to create a Pivot Table and groupings with a count of number months at zero ....
I will look into an example as this is something already done before.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.