请更正商店程序例程 [英] Please correct the store procedure routine

问题描述

1.  @ZBACK is the number of times the routine will run

2.  @ZIDNO and   @ZLOANUMBER   is the particular record which is      

    selected from the 2 linked tables a. LOANS and b. INTEREST


Request
______


Can you please provide a better way to perform the undernoted routine

ALTER Procedure [dbo].[sp_Construction]
(
		@ZIDNO           VarChar(50),
                @ZAPPRS_NO       VarChar(50),
                @ZLOANUMBER      VarChar(50),
                @ZBACK           SMALLINT        , 
                @RETURN          VARCHAR(4)OUTPUT
 )
 
 

	SET @ZCCNT =1
	
	
	WHILE @ZCCNT <= @ZBACK 
				
	BEGIN


	CREATE TABLE #VOANS
	(
	AIDNO       varchar(20),
	ACOMPCOUNT  smallint ,
	BINT_NO     varchar(20),
	BINT_NAME   varchar(50),
	BRATES      numeric(18,4)
)



	INSERT INTO #VOANS
	SELECT A.IDNO     AS AIDNO         ,
	A.COMPCOUNT     AS  ACOMPCOUNT  ,
	B.INT_NO        AS  BINT_NO     ,
	B.INT_NAME      AS  BINT_NAME   ,
	B.RATES         AS  BRATES
	FROM LOANS A JOIN INTEREST B
	ON A.INT_NO = B.INT_NO WHERE  B.INT_NO=@ZINT_NAME AND A.IDNO =@ZIDNO AND A.LOANUMBER= @ZLOANUMBER


	DECLARE NNLOANS CURSOR FOR SELECT  AIDNO  ,
				    ACOMPCOUNT  ,
				   BINT_NO     ,
				   BINT_NAME   ,
				   BRATES FROM #VOANS

	        
	OPEN NNLOANS

	FETCH NEXT FROM NNLOANS  INTO    @AIDNO     ,
				   @ACOMPCOUNT   ,
				   @BINT_NO     ,
				   @BINT_NAME  ,
				   @BRATES         
				
									   
	WHILE @@FETCH_STATUS = 0
	BEGIN	

			 UPDATE LOANS  SET 
					OUTSTAND  =       @AADVLOAN-@MMPRINC, 
					TOTPAYMT  =       @MMDEDUCT 
					 WHERE IDNO =@AIDNO AND LOANUMBER=@ALOANUMBER
		
	
	END
	
		
	SET @ZCCNT =@ZCCNT+1
			
	END
	
				
	CLOSE NNLOANS
		
	DEALLOCATE NNLOANS

推荐答案

我们不做你的作业：这是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！



如果遇到具体问题，请询问相关问题，我们会尽力提供帮助。但我们不打算为你做这一切！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!

这篇关于请更正商店程序例程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！