且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

自动将数据从sql传输到R

更新时间: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)