if object_id(‘[A]‘) is not null drop table [A]go create table [A]([日期] datetime,[金额] int)insert [A]select * from [A]select ‘2014-05-01‘,100 union allselect ‘2014-05-02‘,200 union allselect ‘2014-05-05‘,300 union allselect ‘2014-05-06‘,200declare @stdate smalldatetime,        @eddate smalldatetimeselect  @stdate=min([日期]),        @eddate=max([日期]) from [A];with sel as( select @stdate as [date],1 as val union all select  dateadd(day,val,@stdate),val+1 as val from sel where val<=datediff(day,@stdate,@eddate))select sel.[date] as [日期],sum(isnull(A.[金额],0)) as [金额] from selleft join [A] on sel.[date]=[A].[日期] group by sel.[date]