I am facing difficulty in building the logic mentioned below:
If a ID was activated and never deactivated till Today then consider it as active for all Months.
In the above output:
Jul 2012 had 2 IDs 1 and 2 ,therefore Count(ID)=2
Aug 2012 have only one ID(i.e. 2). ID 1 is not updated in Aug and also it is not deactivated in Jul 2012 .So,i have to count it as activate in Aug 2012 .