I think Member number cycle begin date cycle end date111111 01/01/2012 01/31/2012 --------------31days111111 02/01/2012 02/28/2012 --------------28days222222 01/01/2012 01/31/2012 --------------31daysDECLARE @tab TABLE(MemberNumber int, cycleBeginDate date, cycleEndDate date)insert into @tab SELECT 111111, '01/01/2012', '01/31/2012' union allSELECT 111111, '02/01/2012', '02/28/2012' union allSELECT 222222, '01/01/2012', '01/31/2012'SELECT MemberNumber, SUM( DATEDIFF(dd, cycleBeginDate, cycleEndDate)+1 ) AS NoOfDaysFROM @tabGROUP BY MemberNumber
--Chandu