SELECT SUM(S.intValue) As HolidayTime
FROM  tblDaySecBands S
WHERE
		(S.intEmpID = 3541)
		AND (S.dteDate >= '29 May 2006')
		AND (S.dteDate <= '2 Jun 2006')