更新时间:2022-11-07 07:55:02
添加日期到您的结果sql表 dbo.mytableforecast
Add a date to your result sql table dbo.mytableforecast
更改select SQL语句,使其仅选择
Change the select SQL statement such that it only selects data after
select
Dt
,CustomerName
,ItemRelation
,SaleCount
,DocumentNum
,DocumentYear
,IsPromo
from dbo.mytable
where Dt > (select max(Dt) from dbo.mytableforecast)