有一個問題哦，看看個位高手先進有沒有辨法幫小弟解決 如下： A0001 洗碗精 2004/1/12 A0001 洗碗精 2004/1/15 A0001 洗碗精 2004/3/10 A0001 洗碗精 2004/5/21 A0021 手套 2004/1/12 A0021 手套 2004/2/25 我想把上面的五比資料分出來，分成比如 編號 產品 Jan Feb Mar Apr May A0001 洗碗精 2 0 1 0 5 A0021 手套 1 1 0 0 0 可以教我是不是可以用SQL語法做一個解決呢><"謝謝

Hi iii928,    請參考以下文章 http://delphi.ktop.com.tw/topic.php?topic_id=49969 改用以下語法試試

SELECT  PRODID,
        PRODNAME,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  1 THEN 1 ELSE 0 END) AS JAN_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  2 THEN 1 ELSE 0 END) AS FEB_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  3 THEN 1 ELSE 0 END) AS MAR_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  4 THEN 1 ELSE 0 END) AS APR_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  5 THEN 1 ELSE 0 END) AS MAY_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  6 THEN 1 ELSE 0 END) AS JUN_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  7 THEN 1 ELSE 0 END) AS JUL_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  8 THEN 1 ELSE 0 END) AS AUG_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) =  9 THEN 1 ELSE 0 END) AS SEP_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) = 10 THEN 1 ELSE 0 END) AS OCT_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) = 11 THEN 1 ELSE 0 END) AS NOV_COUNT,
        SUM(CASE WHEN DATEPART(MONTH,DTFIELD) = 12 THEN 1 ELSE 0 END) AS DEC_COUNT
FROM    TABLE1
WHERE   DATEPART(YEAR,DTFIELD) = 2004
GROUP BY
        PRODID,
        PRODNAME
ORDER BY
        PRODID

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

哇 ，這位大哥你還真是神呢，能把SQL語法玩到這麼神乎奇技，看來小弟我還有一段長長的路要走呢，謝謝你囉~!!