累计折旧不对调整.docVIP

累计折旧不对调整 第一步： if exists (select * from sysobjects where id = object_id(N[dbo].[aatjb]) and OBJECTPROPERTY(id, NIsUserTable) = 1) drop table [dbo].[aatjb] GO CREATE TABLE [dbo].[aatjb] ( [Num1] [varchar] (48) NULL , [sDeptName] [varchar] (48) NULL , [sTypeName] [varchar] (30) NULL , [iperiod] [int] NULL , [lCount] [int] NULL , [Life] [varchar] (12) NULL , [sUnit] [varchar] (10) NULL , [dblBalanceValue] [float] NULL , [dblDeprT] [float] NULL , [dblBalance] [float] NULL , [dblRate] [float] NULL , [dblBVOfSum] [float] NULL , [dblDepr] [float] NULL , [dblCanWorkOfSum] [float] NULL , [dblWorkT] [float] NULL , [dblBuildAreaOfSum] [float] NULL , [lBuildNumOfSum] [int] NULL , [lMachinNumOfSum] [int] NULL , [dblMachinWOfSum] [float] NULL ) ON [PRIMARY] GO 第二步： if exists (select * from sysobjects where id = object_id(N[dbo].[fa_Q_TJB_new]) and OBJECTPROPERTY(id, NIsProcedure) = 1) drop procedure [dbo].[fa_Q_TJB_new] GO SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GO Create PROC fa_Q_TJB_new(@iDeptLevel int, @iTypeLevel int, @LoginPeriod int, @LoginDate DateTime, @lDeptChilds int, @lTypeChilds int) AS ---------------------- Create YXKP Sets ---------------------------- CREATE TABLE #YXKP(sCardID varchar(20)) EXEC fa_Q_INSERT_YXKP @LoginDate ---------------------- Cretae TempTable ---------------------------- SELECT 2 AS sSort, AS Num1, AS Num2, Count(*) AS lCount, Sum(fa_Cards.dblValue) AS dblBalanceValue, ----dblDeprT(累计折旧)---- Sum((CASE @LoginPeriod WHEN 1 THEN [dblDeprT1] WHEN 2 THEN [dblDeprT2] WHEN 3 THEN [dblDeprT3] WHEN 4 THEN [dblDeprT4] WHEN 5 THEN [dblDeprT5] WHEN 6 THEN [dblDeprT6] WHEN 7 THEN [dblDeprT7] WHEN 8 THEN [dblDeprT8] WHEN 9 THEN [dblDeprT9] WHEN 10 THEN [dblDeprT10] WHEN 11 THEN [dblDeprT11] WHEN 12 THEN [dblDeprT12] END)) AS dblDeprT, Sum(fa_Cards.dblBV) AS dblBVOfSum, ----dblDepr(本期折旧)---- Sum((CASE @LoginPeriod WHEN 1 THEN [dblDepr1] WHEN 2 THEN [dblDepr2] WHEN 3 THEN [dblDepr3] WHEN 4 THEN [dblDepr4] WHEN 5 THEN [dbl