SET DATEFIRST 1
;
WITH
dd AS (
  SELECT
    [wn] = DATEPART( WEEK, ss.[date] ),
    [wd] = DATEPART( WEEKDAY, ss.[date] ),
    ss.[date]
  FROM (
      SELECT
        [date] = ( CONVERT( DATE, '20170101' ) )
    ) ss
  UNION ALL
  SELECT
    [wn] = DATEPART( WEEK, ss.[date] ),
    [wd] = DATEPART( WEEKDAY, ss.[date] ),
    ss.[date]
  FROM
    dd
    CROSS APPLY (
      SELECT
        [date] = DATEADD( DAY, 1, dd.[date] )
    ) ss
  WHERE
    dd.[date] < '20171231'
)
SELECT
  [wn],
  [mon] = MAX( CASE WHEN [wd] = 1 THEN [date] END ),
  [tue] = MAX( CASE WHEN [wd] = 2 THEN [date] END ),
  [wed] = MAX( CASE WHEN [wd] = 3 THEN [date] END ),
  [thu] = MAX( CASE WHEN [wd] = 4 THEN [date] END ),
  [fri] = MAX( CASE WHEN [wd] = 5 THEN [date] END ),
  [sat] = MAX( CASE WHEN [wd] = 6 THEN [date] END ),
  [sun] = MAX( CASE WHEN [wd] = 7 THEN [date] END )
FROM
  dd
GROUP BY
  [wn]
OPTION (
  MAXRECURSION 0 
)

declare @dt date = getdate();

;with m_days as 
(
	select top 31 
		 RIGHT('00' + CONVERT(VARCHAR(2), ROW_NUMBER() over(order by (select null))), 2) as m_day
		,RIGHT('00' + CONVERT(VARCHAR(2), month(@dt)), 2) as m_month
		,CONVERT(VARCHAR(4), year(@dt)) as m_year
	from master..spt_values v
)

, src  as 
(
	 select 
	 m_day
	,datename(dw, convert(date, concat(m_year, m_month, m_day))) as dw
	,datepart(week, convert(date, concat(m_year, m_month, m_day))) as wk
	from m_days
	where isdate(concat(m_year, m_month, m_day)) = 1
)

select p.*
from
(
	select * 
	from src
) p_src
pivot(max(m_day) for dw in (Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday)) as p

    ;WITH cte_days AS
    (
        SELECT
            dp_day = CONVERT(smalldatetime, '20170101')

        UNION ALL

        SELECT
            dp_day = DATEADD(DAY, 1, c.dp_day)
        FROM cte_days c
        WHERE c.dp_day < CONVERT(smalldatetime, '20170331')
    )
    SELECT
        *
    FROM cte_days
    OPTION (MAXRECURSION 0)