SELECT		EmployeeID,
		SUM(CASE
			WHEN ProjectID = '0200' OR ActID LIKE '0%' THEN Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7
			ELSE 0
		END),
		SUM(CASE
			WHEN ProjectID <> '0200' OR ActID NOT LIKE '0%' THEN Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7
			ELSE 0
		END)
FROM		TableA
GROUP BY	EmployeeID


SELECT		ISNULL(x.EmployeeID, y.EmployeeID) EmployeeID,
		ISNULL(x.s, 0),
		ISNULL(y.s, 0)
FROM		(
			SELECT		EmployeeID,
					SUM(Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7) s
			FROM		TableA
			WHERE		ProjectID = '0200'
					OR ActID LIKE '0%' 
			GROUP BY	EmployeeID
		) x
FULL JOIN	(
			SELECT		EmployeeID,
					SUM(Day1 + Day2 + Day3 + Day4 + Day5 + Day6 + Day7) s
			FROM		TableA
			WHERE		ProjectID = '0200'
					OR ActID LIKE '0%' 
			GROUP BY	EmployeeID
		) y ON y.EmployeeID = x.EmployeeID
ORDER BY	1