K3库龄分析带金额.doc

文档介绍：SET NOCOUNT ON
CREATE TABLE #Happen(
FItemID int Null,
FStockID int Null,
FQty decimal(28,10) Null,
FCUUnitQty decimal(28,10) Null,
FQty1 Decimal(28,10),
FCUUnitQty1 Decimal(28,10),
FQty2 Decimal(28,10),
FCUUnitQty2 Decimal(28,10),
FTemp bit )
CREATE TABLE #Happen1(
FItemID int Null,
FStockID int Null,
FQty decimal(28,10) Null,
FCUUnitQty decimal(28,10) Null,
FQty1 Decimal(28,10),
FCUUnitQty1 Decimal(28,10),
FQty2 Decimal(28,10),
FCUUnitQty2 Decimal(28,10),
FTemp bit )
INSERT INTO #Happen1
Select , As FStockID,0,0,
(case when >=convert(datetime,convert(varchar,DATEADD(dd,-89,'2011-03-31'),101)) AND <=convert(datetime,convert(varchar,DATEADD(dd,-0,'2011-03-31'),101)) then else 0 END) As FQty1,
((case when >=convert(datetime,convert(varchar,DATEADD(dd,-89,'2011-03-31'),101)) AND <=convert(datetime,convert(varchar,DATEADD(dd,-0,'2011-03-31'),101)) then else 0 END))/ As FCUUnitQty1,
(case when >=convert(datetime,convert(varchar,DATEADD(dd,-90,'2011-03-31'),101)) AND <=convert(datetime,convert(varchar,DATEADD(dd,-90,'2011-03-31'),101)) then else 0 END) As FQty2,
((case when >=convert(datetime,convert(varchar,DATEADD(dd,-90,'2011-03-31'),101)) AND <=convert(datetime,convert(varchar,DATEADD(dd,-90,'2011-03-31