create table #t(mydate datetime, sum1 decimal( 10 , 2 ))

insert #t values('20020901',  30 )
insert #t values('20020902',  10 ) 
insert #t values('20020903',  30 ) 
insert #t values('20020904',  90 ) 
insert #t values('20020905',  20 ) 
insert #t values('20020906',  30 )


select a.mydate, max(a.sum1) as sum1, sum(isnull(b.sum1,  0 ))+max(a.sum1) as tot_sum
from #t a 
left outer join #t b on b.mydate > a.mydate
group by a.mydate having (sum(isnull(b.sum1,  0 ))+max(a.sum1)) <=  150 
order by a.mydate desc


drop table #t

select a.client, a.product, a.mydate, max(a.sum1) as sum1, sum(isnull(b.sum1,  0 ))+max(a.sum1) as tot_sum
from #t a 
left outer join #t b on b.mydate > a.mydate
group by a.client, a.product, a.mydate having (sum(isnull(b.sum1,  0 ))+max(a.sum1)) <=  150 
order by a.client, a.product, a.mydate