select IsNull(sum(case UnitProjectName when '道路工程' then mangeSum else 0 end), 0) AS '0道路工程RoadNum',
IsNull(sum(case UnitProjectName when '结构工程' then mangeSum else 0 end), 0) AS '0结构工程RoadNum',
IsNull(sum(case UnitProjectName+type when '道路工程0' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '道路工程1' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice2',
IsNull(sum(case UnitProjectName+type when '结构工程0' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '结构工程1' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice2',
from 视图
where roadtype='0' and year='2005' and month='6' and
(UnitProjectName ='结构工程' or UnitProjectName = '道路工程') and
(type = '0' or type = '1') and
(CreatedBy = '2005063000000049' or CreatedBy = '2005063000000051')
IsNull(sum(case UnitProjectName when '结构工程' then mangeSum else 0 end), 0) AS '0结构工程RoadNum',
IsNull(sum(case UnitProjectName+type when '道路工程0' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '道路工程1' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice2',
IsNull(sum(case UnitProjectName+type when '结构工程0' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '结构工程1' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice2',
from 视图
where roadtype='0' and year='2005' and month='6' and
(UnitProjectName ='结构工程' or UnitProjectName = '道路工程') and
(type = '0' or type = '1') and
(CreatedBy = '2005063000000049' or CreatedBy = '2005063000000051')
IsNull(sum(case UnitProjectName when '结构工程' then mangeSum else 0 end), 0) AS '0结构工程RoadNum',
IsNull(sum(case UnitProjectName+type when '道路工程0' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '道路工程1' then mangeSum*RationPrice else 0 end), 0) AS '0道路工程RoadPrice2',
IsNull(sum(case UnitProjectName+type when '结构工程0' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice1',
IsNull(sum(case UnitProjectName+type when '结构工程1' then mangeSum*RationPrice else 0 end), 0) AS '0结构工程RoadPrice2',
from 视图
where roadtype='0' and year='2005' and month='6' and
(UnitProjectName ='结构工程' or UnitProjectName = '道路工程') and
(type = '0' or type = '1') and
(CreatedBy = '2005063000000049' or CreatedBy = '2005063000000051')