Dibatalkan

Convert SQL function into RPG (or C) language

There's a SQL function that needs to be translated into RPG (or C) language.

All the functionality in translated function has to be exactly as in the original. In the bidding, please mention the language you'll use for the outcome (RPG or C).

Below please review the original SQL function.

Thank you!

drop function [url removed, login to view]

go

create function [url removed, login to view]

(

-- Datetype for @rate changed to float

@rate float,

@periods smallint,

@principal numeric(20,2)

)

returns numeric (38,9)

as

begin

declare @pmt numeric (38,9)

declare @WK_periods float,

@WK_principal float,

@wk_One float,

@WK_power float

-- Convert data for calculation

select @WK_periods = @periods,

@WK_principal = @principal,

@WK_One = 1

select @pmt =

round(

-- Do all multiplication before division

( @WK_principal * (@rate*power(@WK_One+@rate,@WK_periods)))

/ (power(@WK_One+@rate,@WK_periods)-@WK_One)

,9)

return @pmt

end

Kemahiran: Pengaturcaraan C, Pengaturcaraan C++, MMORPG, Memasang Skrip, SQL

Lihat lebih lanjut: convert sql rpg, the c language, sql programming language, s programming language, rpg programming language, programming sql, programming in sql, programming function, original programming, needs for c# programming, language programming, go programming language review, function programming, function in programming, float programming, float c programming, create a programming language, c programming power, c programming function, programming language go, go programming language, all programming language, sql programming, Sql 2012, rpg

Tentang Majikan:
( 91 ulasan ) Cairo, Egypt

ID Projek: #1584712

4 pekerja bebas membida secara purata $30 untuk pekerjaan ini

bilal580

hi I can do this for you in C

$30 USD dalam sehari
(5 Ulasan)
4.2
vishram0709

Hey I am a computer engineer and I have IBM DB2 certification and can surly convert your SQL function to C code.

$30 USD dalam sehari
(0 Ulasan)
0.0
nhanphanmem

Hello! I'm good at c so I can convert it to c language.

$30 USD dalam sehari
(0 Ulasan)
0.0
miktug

That's easy, I'll do it in C and guarantee max quality work.

$30 USD dalam sehari
(0 Ulasan)
0.0