WITH t AS
(
SELECT '0001' cd, '20130101' dt, 100 amt
UNION ALL SELECT '0001', '20130201', 120
UNION ALL SELECT '0002', '20130101', 100
UNION ALL SELECT '0002', '20130201', 100
UNION ALL SELECT '0003', '20130101', 300
UNION ALL SELECT '0003', '20130301', 300
)
-- 1. PIVOT --
SELECT *
  FROM t
 PIVOT (SUM(amt) FOR dt IN ("20130101", "20130201", "20130301")) p
 ORDER BY cd
;
-- 2. Group By, Sum(Case) --
SELECT cd
     , SUM(CASE dt WHEN '20130101' THEN amt END) "20130101"
     , SUM(CASE dt WHEN '20130201' THEN amt END) "20130201"
     , SUM(CASE dt WHEN '20130301' THEN amt END) "20130301"
  FROM t
 GROUP BY cd
 ORDER BY cd
;