DATES

  declare @date_from datetime, @date_to datetime
set @date_from = DATEADD(month, DATEDIFF(month, 0, getdate()), 0)
set @date_to = DATEADD(day, -1, getdate())
;with dates as(
    select @date_from as dt
    union all
    select DATEADD(d,1,dt) from dates where dt<=@date_to
)
select *
into ##dates
from dates


DECLARE @cols NVARCHAR(MAX)
SELECT @cols = STUFF((
				--SELECT ',' + QUOTENAME(LEFT(DATENAME(day, DATE),3) + '/' + CAST(Month(DATE) AS CHAR(4)))
				select ',' + QUOTENAME(convert(varchar(6), dt, 107))
               FROM (select distinct dt from ##dates) x ORDER BY dt FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')


DECLARE @query NVARCHAR(MAX)
SET @query = 'select * from
 (SELECT  Cost, convert(varchar(6),date, 107) as Date FROM dpttempt
             ) x
             PIVOT
             (sum( Cost) for Date in
             (' +@cols + ')
            ) as pvt'

            EXEC SP_EXECUTESQL @query


 drop table ##dates