--按月份统计当年支出 Tab0--
SELECT ABS(SUM(TRANMONEY)) AS TRANMONEY,[Month] FROM (
SELECT TRANMONEY,SUBSTRING(CONVERT(VARCHAR(20),GETDATE(),120),6,2) AS [Month] FROM ZGTB_LOG_TRANALL
WHERE TRANACCOUNT=@TRANACCOUNT AND TRANMONEY<0
AND (SUBSTRING(CONVERT(VARCHAR(20),TRANTIME,120),1,4) =SUBSTRING(CONVERT(VARCHAR(20),GETDATE(),120),1,4))