DECLARE @T TABLE
(
	Priext INT,
	field1 VARCHAR(100),
	field2 VARCHAR(100),
	loggeddate	VARCHAR(100)
)
INSERT INTO @T
SELECT 206, '00:07;54', NULL, '20080927__P9P1112223333' UNION ALL
SELECT 206, '00:14;30', '00;07', '20080927' UNION ALL
SELECT 206, '00:03;23', NULL, '20080927__P9P1112223333' UNION ALL
SELECT 208, '00:11;19', '00;15', '20080927' UNION ALL
SELECT 206, '00:00;53', NULL, '20080928__P9P1112223333'

SELECT	DISTINCT SUBSTRING(T.loggeddate, 1, 8) AS 'date'
		, T.Priext AS 'ext'
		, ISNULL(TIN.Inbound, 0) AS 'inbound calls'
		, ISNULL(TOT.Outbound, 0) AS 'outbound calls'
FROM @T T
LEFT JOIN
		(
			SELECT SUBSTRING(loggeddate, 1, 8) AS 'date', Priext AS 'ext', COUNT(Priext) AS 'Inbound'
			FROM @T
			WHERE field2 IS NOT NULL
			GROUP BY SUBSTRING(loggeddate, 1, 8), Priext
		) TIN ON T.Priext = TIN.ext AND TIN.date = SUBSTRING(T.loggeddate, 1, 8)
LEFT JOIN
		(
			SELECT SUBSTRING(loggeddate, 1, 8) AS 'date', Priext AS 'ext', COUNT(Priext) AS 'Outbound'
			FROM @T
			WHERE field1 IS NOT NULL AND field2 IS NULL
			GROUP BY SUBSTRING(loggeddate, 1, 8), Priext
		) TOT ON T.Priext = TOT.ext AND TOT.date = SUBSTRING(T.loggeddate, 1, 8)

SELECT LEFT(loggeddate,CASE WHEN CHARINDEX('_',loggedate)>0 THEN CHARINDEX('_',loggeddate)-1 ELSE LEN(loggeddate) END) AS date,
Priext AS Ext,
SUM(CASE WHEN NULLIF(Countfield,'') IS NOT NULL THEN 1 ELSE 0 END) AS InboundCalls,
SUM(CASE WHEN NULLIF(Countfield,'') IS NULL THEN 1 ELSE 0 END) AS OutboundCalls
FROM YourTable
GROUP BY LEFT(loggeddate,CASE WHEN CHARINDEX('_',loggedate)>0 THEN CHARINDEX('_',loggeddate)-1 ELSE LEN(loggeddate) END),Priext