T-Sql İlgili Ayın dökümünü almak almak SP

Merhaba ,

Faydalı olması dileğiyle

Çıktı Önizleme

01.01.2017 Pazar
02.01.2017 Pazartesi
03.01.2017 Salı
04.01.2017 Çarşamba
05.01.2017 Perşembe
06.01.2017 Cuma
07.01.2017 Cumartesi
08.01.2017 Pazar
09.01.2017 Pazartesi
10.01.2017 Salı
11.01.2017 Çarşamba
12.01.2017 Perşembe
13.01.2017 Cuma
14.01.2017 Cumartesi
15.01.2017 Pazar
16.01.2017 Pazartesi
17.01.2017 Salı
18.01.2017 Çarşamba
19.01.2017 Perşembe
20.01.2017 Cuma
21.01.2017 Cumartesi
22.01.2017 Pazar
23.01.2017 Pazartesi
24.01.2017 Salı
25.01.2017 Çarşamba
26.01.2017 Perşembe
27.01.2017 Cuma
28.01.2017 Cumartesi
29.01.2017 Pazar
30.01.2017 Pazartesi
31.01.2017 Salı

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

ALTER PROCEDURE [dbo].[SP_AY_dökümü]
    @AY NVARCHAR(10) ,
    @YIL NVARCHAR(10)
AS
    BEGIN
        SET LANGUAGE Turkish;
        DECLARE @COUNT INT;
        DECLARE @CIKTI NVARCHAR(MAX);
        DECLARE @DATE NVARCHAR(50);
        DECLARE @DAY NVARCHAR(50);
        SET @COUNT =  DAY(DATEADD(
                                    d ,
                                    -DAY(DATEADD(m, 1, CAST( '01.'+ @AY+'.'+@YIL AS DATETIME  ))),
                                    DATEADD(m, 1, CAST( '01.'+ @AY+'.'+@YIL AS DATETIME  ))
                                )
                        );
        DECLARE @Sayac INT = 1;
        WHILE @Sayac <= @COUNT
            BEGIN

                SET @DAY = CONVERT(
                                      NVARCHAR(20) ,
                                      CAST(CAST(@Sayac AS NVARCHAR(5)) + '.'
                                           + @AY + '.' + @YIL AS DATETIME),
                                      104
                                  );
                SET @DATE = DATENAME(
                                        dw ,
                                        CAST(@Sayac AS NVARCHAR(5)) + '.'
                                        + @AY + '.' + @YIL
                                    );

                SET @Sayac += 1;

                SET @CIKTI = @DAY + ' ' + @DATE;
                PRINT @CIKTI;

            END;

    END;

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