ALTER PROCEDURE [dbo].[sp_TranpostSupport_Xuat_Nhap_ToTal]	

	@NO_ AS NVARCHAR(4000),
	@FromDate DATETIME,
	@ToDate DATETIME,
	@TransInvoiceID INT
	
AS	
SELECT x.NO_,x.NAMES,x.ZIPCODE,x.FromDate,x.ToDate,x.Total450c, n.Total450k,

	   (ISNULL(n.Total450k,0)-ISNULL(x.Total450c,0)) TotalCheck450,
		     
	CASE
		WHEN (ISNULL(n.Total450k,0)-ISNULL(x.Total450c,0)) >0 THEN TotalCheck450     /*The purpose is to store the condition value TotalCheck450 */
		WHEN (ISNULL(n.Total450k,0)-ISNULL(x.Total450c,0)) < 0 THEN TotalCheck450 =0 /*	(ISNULL(n.Total450k,0)-ISNULL(x.Total450c,0))*/ 
	END TotalCheck450

INTO                       #tmpSupportCost0003  
FROM  Tbl_AmountTranpost_Detail_Out x LEFT JOIN Tbl_AmountTranpost_Detail_In n ON 
		n.NO_=x.NO_ 
		AND n.ZIPCODE = x.ZIPCODE
WHERE	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)
		
/*--Update Data--*/	

INSERT INTO Tbl_BalanceTranpostCost
		(NO_
		,NAMES
		,ZIPCODE
		,FromDate
		,ToDate
		,TotalCheck450
		,IsDelete
		,CreateDate
		,TransInvoiceID)
		
SELECT  @NO_
		,NAMES
		,ZIPCODE
		,@FromDate
		,@ToDate      
		,TotalCheck450
		,0
		,GETDATE()
		,@TransInvoiceID		
FROM #tmpSupportCost0003     
 
DROP TABLE #tmpSupportCost0003