将以下代码转换为ms SQL Server 2008中的存储过程 [英] Convert the following codes as a stored procedure in ms SQL server 2008

问题描述

亲爱的专家，



需要使用早期的编程语言将以下代码转换为ms sql server中的存储采购。

Dear Expert,

need to convert the following codes to a stored procure in ms sql server from an earlier programming language .

PRIVATE MCNT,MRCNT,MROWS,COLMS
MROW6=0
COLMS=0
MCNT=0
MRCNT=0

SELECT vTaxvalue
GO TOP
COUNT TO MROWS

COLMS=6

DECLARE  TAXARR[MROWS,COLMS]

MCNT=1
SELECT vTaxvalue
GO TOP

MCNT=1

DO WHILE  MCNT<=MROWS   

	TAXARR[MCNT,1]=BAND
	TAXARR[MCNT,2]=VALUE
	TAXARR[MCNT,3]=RATE

	MCNT=MCNT + 1
	SKIP

ENDDO


MRCNT=1

DO WHILE MRCNT <= MROWS
	
	IF MRCNT=1
		TAXARR[MRCNT,4]=TAXARR[MRCNT,2]
		ELSE
		TAXARR[MRCNT,4]=TAXARR[MRCNT-1,4]+TAXARR[MRCNT,2]
	ENDIF


	TAXARR[MRCNT,5]=(TAXARR[MRCNT,4])/12

	IF MRCNT =1
		TAXARR[MRCNT,6]=0
		ELSE
		TAXARR[MRCNT,6]=(TAXARR[MRCNT,3]/100)*(TAXARR[MRCNT,5]-TAXARR[MRCNT-1,5])+TAXARR[MRCNT-1,6]
	ENDIF
	
	MRCNT=MRCNT+1

ENDDO

基本上该程序可以以下计算

Essentially the program does the following computation

BAND NO AMOUNT RATE (%) CUMULATIVE AMOUNT COMPUTATION
--------------------------------------------------------------------
101      100     0            100           0 ==0
102      200     5            300          (300-100)*(5/100) + 0  == 10 
103      250    10            550          (550-300)*(10/100)+ 10 == 35
104      350    20            900          (900-550)*(20/100)+ 35 ==105

如何在 ms sql server 2008中作为存储过程执行此功能

或 C＃。



谢谢



我尝试了什么：



查看其他程序和互联网，但没有AV AIL

How do you perform this function in ms sql server 2008 as a stored procedure
or in C#.

Thanks

What I have tried:

LOOKED AT OTHER PROGRAMS AND THE INTERNET BUT TO NO AVAIL

推荐答案

它不是那样的工作。

我们不是代码编写服务;我们不为你工作。

如果你想让别人写你的代码，你必须付钱 - 我建议你去Freelancer.com并在那里问。

但要注意：你得到了你付出的代价。支付花生，买猴子。



或者，学习早期编程语言和C＃或SQL并自己动手。

It doesn't quite work like that.
We are not a code writing service; we do not do your work for you.
If you want someone to write your code, you have to pay - I suggest you go to Freelancer.com and ask there.
But be aware: you get what you pay for. Pay peanuts, get monkeys.

Alternatively, learn the "earlier programming language" and either C# or SQL and do it yourself.

这篇关于将以下代码转换为ms SQL Server 2008中的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！