SELECT *
FROM
(SELECT DATEPART(DAY,SW1.SubWork_DateInitiated) as MonthDay,
	   DATEPART(DAY,SW1.SubWork_DateInitiated) AS DatePart,
       DATENAME(DAY,SW1.SubWork_DateInitiated) AS DateName,
       COUNT(DATEPART(DAY,SW2.SubWork_DateInitiated)) AS CCWCount
FROM cs105.WSubWork SW1
JOIN cs105.WWork AS WW ON SW1.SubWork_WorkID = WW.Work_WorkID
JOIN cs105.WMap AS WM ON SW1.SubWork_MapID = WM.Map_MapID
JOIN cs105.WSubWork SW2 ON SW1.SubWork_WorkID = SW2.SubWork_WorkID
WHERE WW.Work_Status = 2
  AND WM.Map_MapObjID = 225435
  GROUP BY
		 DATENAME(DAY,SW1.SubWork_DateInitiated),
         DATEPART(DAY,SW1.SubWork_DateInitiated)
UNION
SELECT TOP 31 ROW_NUMBER() OVER(ORDER BY DATAID ASC) as MonthDay, null, null ,null
FROM cs105.DTree
ORDER BY MonthDay ASC) innertable