DECLARE        @tblMonthYear TABLE
        (
                GUID INT,
                YearName VARCHAR(10),
                Quarter VARCHAR(2),
                                MonthYear VARCHAR(10),
                                MonthDay INT
         )

INSERT @tblMonthYear
SELECT 1,'08/09','Q4','Jan-09',1 UNION ALL
SELECT 2,'08/09','Q4','Jan-09',2 UNION ALL
SELECT 3,'08/09','Q4','Jan-09',3



DECLARE        @tblProject TABLE
        (
                ProjectID INT,
                ProjectTitle VARCHAR(10),
                TaskTitle VARCHAR(10),                                
                                Milestone INT,
                                MonthYear VARCHAR(10),
                                MonthDay INT
         )
INSERT @tblProject
SELECT 63,'Arsenal',NULL,NULL,NULL,NULL UNION ALL
SELECT 69,'COEP','Start',1,'Jan-09',1 UNION ALL
SELECT 69,'COEP','Start',1,'Jan-09',2

--SELECT * FROM @tblMonthYear
--SELECT * FROM @tblProject

SELECT	AP.GUID, AP.ProjectID, COUNT( P.ProjectID ) AS Milestone
FROM	(
			SELECT	MY.GUID, MY.MonthYear, MY.MonthDay, P.ProjectID
			FROM	@tblMonthYear MY
					CROSS JOIN
					(
						SELECT	DISTINCT ProjectID
						FROM	@tblProject
					) P
		) AP
		LEFT JOIN @tblProject P ON AP.ProjectID = P.ProjectID AND AP.MonthYear = P.MonthYear AND AP.MonthDay = P.MonthDay 
GROUP BY AP.GUID, AP.ProjectID