嵌套查询

select * into #temp from
(select PM,PD,sum(M) as M from
(select SUBSTRING ( PD , 1 , 6 ) as PM,SUBSTRING ( PD , 1 , 4 )+'/'+SUBSTRING ( PD , 5 , 2 ) as PD ,M
from dbo.GCCM) a group by PM,[PD]) b
select a.PM,a.PD,a.M,(select sum(M) from #temp where PM<=a.PM) as TMile from #temp a