[易飞]呆滞仓物料预计领用

最近公司要我写一个预警，每周发送给QC,PMC等。

需求：呆滞仓物料在未来两月内的预计领用报表。

写一存储过程：

-- =============================================   
-- Author: <David Gong>   
-- Create date: <2013-05-23>    
-- Description: <呆滞仓物料预计领用预警>   
-- ============================================= 
ALTER Proc [dbo].[UP_IdleStockPreNeed]
(
	@0 as nvarchar(15)=null
)
as
begin

---订单预计领用--------
declare @startdate as nvarchar(8),@enddate as nvarchar(8)
set @startdate=Convert(varchar(10),Getdate(),112) 
set @enddate=Convert(varchar(10),dateadd(MONTH,2,Getdate()),112) ;

with ct as(
select a.Item,sum(a.Qty) as Qty from (
select TD004 as Item,sum(cast(TD008-TD009+TD024-TD025 as int)) as Qty from COPTD
where TD013>=@startdate and TD013<=@enddate
group by T