DECLARE	@Sample TABLE (Att1 INT, Att2 INT, PPU MONEY)

INSERT	@Sample
SELECT	1, 1, $0.2 UNION ALL
SELECT	1, 1, $0.3 UNION ALL
SELECT	1, 1, $0.3 UNION ALL
SELECT	1, 1, $0.4 UNION ALL
SELECT	1, 1, $0.5 UNION ALL
SELECT	1, 2, $0.3 UNION ALL
SELECT	1, 2, $0.3 UNION ALL
SELECT	1, 2, $0.3 UNION ALL
SELECT	1, 2, $0.4

SELECT	DISTINCT
	Att1,
	Att2,
	(y1 + y2) / 2.0 AS Median
FROM	(
		SELECT	s1.Att1,
			s1.Att2,
			(SELECT MAX(d.PPU) FROM (SELECT TOP 50 PERCENT s2.PPU FROM @Sample AS s2 WHERE s2.Att1 = s1.Att1 AND s2.Att2 = s1.Att2 ORDER BY s2.PPU) AS d) AS y1,
			(SELECT MIN(d.PPU) FROM (SELECT TOP 50 PERCENT s2.PPU FROM @Sample AS s2 WHERE s2.Att1 = s1.Att1 AND s2.Att2 = s1.Att2 ORDER BY s2.PPU DESC) AS d) AS y2
		FROM	@Sample AS s1
	) AS e