create table #tab(BillNo varchar(50),diff1 int)

insert into #tab

select 20131009001,0 union all

select 20131009001,0 union all

select 20131009001,27 union all

select 20131009001,27 union all

select 20131009001,0 union all

select 20131009002,0 union all

select 20131009002,0 union all

select 20131009002,0 union all

select 20131009003,0 union all

select 20131009003,0 union all

select 20131009003,0 union all

select 20131009003,0 union all

select 20131009003,0 



select *, 

(select SUM(diff1) from #tab b where a.BillNo=b.BillNo

group by BillNo)sum,

(select SUM(diff1) from #tab)sum1

from #tab a

-------------------------------------------

BillNo                                             diff1       sum         sum1

-------------------------------------------------- ----------- ----------- -----------

20131009001                                        0           54          54

20131009001                                        0           54          54

20131009001                                        27          54          54

20131009001                                        27          54