SET NOCOUNT ON;
USE tempdb;
GO
CREATE TABLE dbo.t (
  data date,
  n int,
  m int
  );
INSERT INTO dbo.t
  VALUES ('2012-02-15', 10, 0), ('2012-02-15', 0, 1),
      ('2012-02-20', 15, 0), ('2012-02-20', 0, 3);
GO
SELECT t.data, MAX(t.n) AS <img src="/forum/skins/default/images/emo/png-blue/icon_smile_disapprove.png" class="absmiddle emoticon" />, MAX(t.m) AS [m]
  FROM dbo.t t
  GROUP BY t.data;
GO
DROP TABLE dbo.t;