--> 测试数据：[test]
if object_id('[test]') is not null drop table [test]
create table [test]([riqi] datetime,[LDHM] bigint,[LDCH] int)
insert [test]
select '2011-02-01',13611797573,1 union all
select '2011-02-01',13611797571,1 union all
select '2011-02-01',13611797572,2 union all
select '2011-02-02',136117975743,3 union all
select '2011-02-02',136117975743,4 union all
select '2011-02-02',136117975733,1 union all
select '2011-02-03',136117975723,1 union all
select '2011-02-03',136117975713,1 union all
select '2011-02-04',13611797571,1 union all
select '2011-02-04',73611797571,5 union all
select '2011-02-04',73611797577,1 union all
select '2011-02-05',73611797572,1 union all
select '2011-02-05',73611797576,1

with t
as(
select 
    ID=ROW_NUMBER()over(order by [riqi]),
    CONVERT(varchar(10),[riqi],120) as [riqi],
    COUNT([LDHM]) as [LDHM],
    COUNT([LDCH]) as [LDCH]
from 
    test
group by
    CONVERT(varchar(10),[riqi],120),[riqi]
)
select 
ltrim(DAY(a.riqi))+'-'+ltrim(day(b.riqi)) as riqi,a.LDCH+b.LDCH as LDCH,
a.LDHM+b.LDHM as LDHM
from t a inner join t b on b.ID=a.ID+1
/*
riqi    LDCH    LDHM
1-2    6    6
2-3    5    5
3-4    5    5
4-5    5    5
*/