declare @bdate datetime,@enddate datetime
select @bdate='2002-5-1',@enddate='2003-3-1'select id
,[count1(date<=bdate)]=(select sum([count]) from tab1 where date<=@bdate)
,[count2(enddate>date>bdate)]=(select sum([count]) from tab1 where date<@bdate and date<@enddate)
,[count3(date=>enddate)]=(select sum([count]) from tab1 where date>=@enddate)
from tab1
group by id
存储过程中写insert into ...语句