SELECT SUM(TotalMoney) AS 本期金额, SmallType as 类型
FROM (SELECT TotalMoney, SmallType
FROM jzBillHuihe
WHERE OrganizationID =1 and MakeTime>=convert(char(10),dateadd(yy,-1,'2008-1-1'),120) and MakeTime <=convert(char(10),dateadd(yy,-1,'2008-2-1'),120) ) DERIVEDTBL
GROUP BY SmallType
FROM (SELECT TotalMoney, SmallType
FROM jzBillHuihe
WHERE OrganizationID =1 and MakeTime>=convert(char(10),dateadd(yy,-1,'2008-1-1'),120) and MakeTime <=convert(char(10),dateadd(yy,-1,'2008-2-1'),120) ) DERIVEDTBL
GROUP BY SmallType
SUM(case when MakeTime>='2008-1-1' and MakeTime <='2008-2-1' then TotalMoney else 0 end ) as 本期金额,
SUM(case when MakeTime>=dateadd(yy,-1,'2008-1-1') and MakeTime <=dateadd(yy,-1,'2008-2-1') then TotalMoney else 0 end ) as 上期金额
FROM jzBillHuihe
WHERE OrganizationID =1 and MakeTime>=dateadd(yy,-1,'2008-1-1') and MakeTime <='2008-2-1'
GROUP BY SmallType类型 本期金额 上期金额
费用报销 150 50
商品采购 100 450
商品销售 850 350