在DTS中中新建sql任务,sql语句应该为:
select a.start_Qty + isnull(b.Sale_Qty, 0) - isnull(c.MoveIn_Qty, 0) from a
left join b on a.Prdt_NO= b.Prdt_NO
left join c on a.Prdt_NO= c.Prdt_NO
select a.start_Qty + isnull(b.Sale_Qty, 0) - isnull(c.MoveIn_Qty, 0) from a
left join b on a.Prdt_NO= b.Prdt_NO
left join c on a.Prdt_NO= c.Prdt_NO
DTS - Data Transformation Service, 数据转化服务,你的任务里面没有数据转化啊?
anyway, the SQL statements are as following: create talbe a
(
Prdt_NO varchar(10)Primary,
Qty int, ---数量
start_Qty int,---期数量
start_date dateTime 期初时间
)
create talbe b
(
Prdt_NO varchar(10) Primary,
Sale_Qty int, --卖 出去的数量
Saled_Time --卖 出去的时间)
create talbe c(
Prdt_NO varchar(10)Primary ,
MoveIn_Qty int, 进货的数量
MoveIn_Time datetime
)
declare @time datetime select a.start_Qty + isnull(b.Sale_Qty, 0) - isnull(c.MoveIn_Qty, 0) from a
left join b on a.Prdt_NO= b.Prdt_NO
left join c on a.Prdt_NO= c.Prdt_NO
where b.Saled_Time < @Time and c.MoveIn_Time < @Time -- 如果是取今天的话就是DateTime.Now() 传给替换 @Time 就行了。