如何存儲過程實現日報進銷存！（高手請進，，感恩！！）
create table #Temp_Stock
(Dt_op Datetime,
Id_wc int,
Beg_Qty decimal(16,4),
In_Qty decimal(16,4),
Out_Qty decimal(16,4),
Scr_Qty decimal(16,4),
End_Qty decimal(16,4)
)
每日回報各id_wc的In_Qty,Out_Qty,Scr_Qty數據！
期末值：end_Qty=beg_QTy+In_Qty＋Out_Qty-Scr_Qty
存儲過程實現各id_wc 期初，進，銷，期末。
查詢時，昨日期末=今日期初
---請幫忙指示方法！！！
[解决办法]
给点原绐数据
[解决办法]
----参考：
select
T2.Id_wc,T2.dt_op,(T1.In_qty-T1.Out_qty-T1.Scr_Qty) AS Beg_Qty,
T2.In_qty,T2.Out_qty,T2.Scr_Qty,(T1.In_qty-T1.Out_qty-T1.Scr_Qty) +
T2.In_qty-T2.Out_qty-T2.Scr_Qty AS End_QTY
fom #temp_Stock T2
join
(
select id_wc,dt_op,Beg_Qty,In_Qty,Out_Qty,Scr_Qty
from #temp_Stock
)T1
ON CONVERT(varchar, T2.T2.dt_op, 120 )T1.T2.dt_op = CONVERT(varchar, T1.T2.dt_op-1, 120 )
[解决办法]
--上面手误
----参考：
select
T2.Id_wc,T2.dt_op,(T1.In_qty-T1.Out_qty-T1.Scr_Qty) AS Beg_Qty,
T2.In_qty,T2.Out_qty,T2.Scr_Qty,(T1.In_qty-T1.Out_qty-T1.Scr_Qty) +
T2.In_qty-T2.Out_qty-T2.Scr_Qty AS End_QTY
fom #temp_Stock T2
join
(
select id_wc,dt_op,Beg_Qty,In_Qty,Out_Qty,Scr_Qty
from #temp_Stock
)T1
ON CONVERT(varchar, T2.dt_op, 120 )= CONVERT(varchar, T1.dt_op-1, 120 )
