I currently have 1 procedure:ALTER PROCEDURE [dbo].[sp_Support_Out_In_Detail] @No AS NVARCHAR(4000), @FromDate DATETIME, @ToDate DATETIME, @TransInvoiceID INT AS SELECT x.No,x.Name,x.ZIPCODE,x.FromDate,x.ToDate,x.Total450c, n.Total450k, x.Total24c, ISNULL(x.Total450c,0)-(ISNULL(n.Total450k,0)) TotalCheck450, /*-Save TotalCheck450 to calculate and compare--*/ ((x.Total24c)*1000) ATMTotalSupport24, CASE WHEN ISNULL(x.Total450c,0)-(ISNULL(n.Total450k,0)) <0 THEN x.Total450c*800 WHEN ISNULL(x.Total450c,0)-(ISNULL(n.Total450k,0)) >0 THEN n.Total450k*800 WHEN ISNULL(x.Total450c,0)-(ISNULL(n.Total450k,0)) =0 THEN x.Total450c*800 END ATMToatlSupport45INTO #tmpSupportCost0003 FROM Tbl_AmountTranpost_Detail_Out x LEFT JOIN Tbl_AmountTranpost_Detail_In n ON n.No=x.No AND x.No = n.NoWHERE x.No=@No AND CONVERT(NVARCHAR(10),x.FromDate,112) = CONVERT(NVARCHAR(10),@FromDate,112) AND CONVERT(NVARCHAR(10),x.ToDate,112) = CONVERT(NVARCHAR(10),@ToDate,112) --AND x.No=b.No /*--Update Data --*/INSERT INTO Tbl_SupportCost (No ,Name ,ZIPCODE ,FromDate ,ToDate ,Total450c ,Total450k ,Total24c ,TotalCheck450 ,ATMTotalSupport24 ,ATMToatlSupport45 ,IsDelete ,CreateDate ,TransInvoiceID)SELECT @No ,Name ,ZIPCODE ,@FromDate ,@ToDate ,Total450c ,Total450k ,Total24c ,TotalCheck450 ,ATMTotalSupport24 ,ATMToatlSupport45 ,0 ,GETDATE() ,@TransInvoiceID FROM #tmpSupportCost0003 DROP TABLE #tmpSupportCost0003
Table save Totalcheck450 is structured as follows: Now when the next month, I want to n.Total450k + Totalcheck-01/2013: ISNULL (x.Total450c, 0) - (ISNULL (n.Total450k, 0)) TotalCheck450 = A (A number will be saved, TotalCheck450)-02/2013: ISNULL (x.Total450c, 0) - (ISNULL (n.Total450k, 0)) TotalCheck450here A number would be : A + (ISNULL (n.Total450k, 0)- What can I do to get results ?Looking forward to the help from everyoneI thank you very much.