Imp Sqlquery /* SQL QUERY */

create procedure udf_Weekdays(@Weekday int,@BeginDate datetime,@EndDate datetime)
as
begin

--@Weekday: 1 = Monday , ... ,7 = Sunday

select datediff(week,@BeginDate,@EndDate) + case when (@@datefirst + datepart(weekday,@BeginDate)) % 7 + case when (@@datefirst + datepart(weekday,@BeginDate)) % 7 = 0 then 7 else 0 end > @Weekday % 7 + 1 then 0 else 1 end - case when (@@datefirst + datepart(weekday,@EndDate)) % 7 + case when (@@datefirst + datepart(weekday,@EndDate)) % 7 = 0 then 7 else 0 end >= @Weekday % 7 + 1 then 0 else 1 end

end

Exec udf_Weekdays 7,'05/01/2010','05/31/2010'


---------------------------------

Select DATENAME(DAY,DATEADD(DAY,-1,DATEADD(Month,1,'February 2012')))

---------------------------------

select distinct AttendanceDate from dbo.AttendanceRegister where datename(dw,AttendanceDate) = 'Sunday' and month(AttendanceDate)='06'

--------------------------------