Hi..
I am Using SQL Server 2003.I have a Table which have Records about the Clients.In that Table there are Many fields like name,address etc.Two of the fields are "SeviceDateFrom" and "ServiceDateTo".These Fields have the Date from which the client started getting Service and date when he stoped getting Service.Now my problem is that How many clients got the service for a particular time period let say for month or fo week.Like i want to get the Number of Clients who were getting the serivce in the month of Feburary 2008.Now his "SeviceDateFrom" could be '20080101' and "ServiceDateTo"could be '200801231' .So how to calculate the Total.Can any 1 Help with that..plz