declare @dtime as varchar(20)delete kucunmingxiku
insert into kucunmingxiku (bianma,kucunliang) select bianma,kucunliang from shouhuoku where shdate>=cast(@dtime as datetime)
insert into kucunmingxiku (bianma,kucunliang) select bianma,kucunliang from shouhuoku where shdate>=cast(@dtime as datetime)
insert into kucunmingxiku (bianma,kucunliang) select bianma,kucunliang from shouhuoku where shdate>=cast(@dtime)
insert into kucunmingxiku (bianma,kucunliang) select bianma,kucunliang from shouhuoku where shdate>=@dtime as datetime