加一个job,调度为每天定时0:0:0,sql语句:
insert table2 select convert(char(8),dateadd(day,-1,getdate()),112),sum(...) from table1 where cobvert(char(8),datefield,112)=convert(char(8),dateadd(day,-1,getdate()),112)
insert table2 select convert(char(8),dateadd(day,-1,getdate()),112),sum(...) from table1 where cobvert(char(8),datefield,112)=convert(char(8),dateadd(day,-1,getdate()),112)
select top 1 getdate(),(select count(*) from table1) from table
create procedure sp_kk
as
declare li_shut int
declare cur_kk cursor for
select count(*)
from table
where convert(char(10),date,112) = convert(char(8),dateadd(day,-1,getdate()),112)
open cur_kk
fetch cur_kk into :li_shut
while @@fetch_sataus = 0
begin
insert into table2
(date,sl)
values(getdate,li_shut)
end
close cur_kk