[阅读: 327] 2007-10-26 05:46:01
SELECT sum_time, min([1]) AS h1, min([2]) AS h2, min([3]) AS h3, min([4])
AS h4, min([5]) AS h5, min([6]) AS h6, min([7]) AS h7, min([8]) AS h8, min([9])
AS h9, min([10]) AS h10, min([11]) AS h11FROM tbl_report_access_halfhour PIVOT (sum(callin_number) FOR
tbl_report_access_halfhour.area_code IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11]))
AS pvt
WHERE 1 = 1
GROUP BY sum_time