我如何清点星期日＃39;在特定月份S

Declare @Month Bigint

Set @Month =11

Declare @date date;

Set @date='2011-11-01'

 

while DATEPART(Month,@date)=@Month

Begin

	--Select DATEPART(DAY,@date);

	--Select DATEPART( WEEKDAY, @DATE )

	DECLARE @Name VARCHAR(20)

 

	SELECT  @Name = CASE ( DATEPART(dw, @Date) + @@DATEFIRST ) % 7

                         WHEN 1 THEN 'Sunday'

                         WHEN 2 THEN 'Monday'

                         WHEN 3 THEN 'Tuesday'

                         WHEN 4 THEN 'Wednesday'

                         WHEN 5 THEN 'Thursday'

                         WHEN 6 THEN 'Friday'

                         WHEN 0 THEN 'Saturday'

                       END 

	If @Name='Sunday'

	Begin

		

		--Insert Data Into Your Table

		Select @date

	End

	

	Set @date=DATEADD(Day,1,@date);	

End