I have a Message Log table which records the date and time for all the online members which login onto the online systems. Now I have to provide the count for the logins/incoming traffic for our member portal page.
The login count rule is that if a member login on a particular date for eg 06/17/12 more than one time still it will be consider as a single login for that day. The login date count are based on the month.
So should I load my table normally and join it with the calendar table that i have created or there is some catch during the loading in order to achieve the required count rule.