SQL Server 2005.我需要帮助建立AR老化报告.剧本出了什么问题?

Question

SELECT 
   invno,invdte,
   CASE     
        WHEN (invdte >= (getdate() - 30) and itotal !=0 THEN 'itotal') AS '0-30'
        WHEN (invdte BETWEEN getdate(), - 31)  AND (getdate(), - 60) AND itotal !=0 THEN 'itotal') AS '31-60'
        WHEN (invdte < getdate(),- 61) and itotal !=0 THEN 'itotal') AS '61>'
            Else '0'
   END AS [Aging AR]
   SUM(itotal) AS 'Outstanding Total'
FROM   
   [01].[ARINVOI]
GROUP BY 
   invno, invdte
ORDER BY 
   Outstanding Total DESC

Answer 1

SELECT 
   invno, invdte,
   SUM(CASE WHEN invdte >= (getdate() - 30) and itotal !=0 THEN itotal END) AS [0-30]
   SUM(CASE WHEN invdte BETWEEN (getdate() - 31)  AND (getdate() - 60) AND itotal !=0 THEN itotal END) AS [31-60]
   SUM(itotal) AS 'Outstanding Total'
FROM   
   [01].[ARINVOI]
GROUP BY 
   invno, invdte
ORDER BY 
   Outstanding Total DESC