Faturalarda yazıyla para birimini gösteririz. Sql yazıyla ile rakamı yazıya dönüştürmek için aşağıdaki fonksiyonu kullanabilirsiniz. Gelen 2 parametresi vardır;
- rakam değeri (84305,5)
- para birimi (TRY,USD, vs)
para birimine göre seksendortbinüçyüzbeş.TL.beş.Kr. sonucunu bize verecektir.
create or alter function dbo.RakamiYaziyaDonustur2(@num AS numeric(18,2), @CurrencyCode as varchar(10))
-- 2022-10-18
returns varchar(255)
AS
BEGIN
declare @kurus varchar(10)
set @kurus=CASE WHEN @CurrencyCode = 'TRY' THEN '.Kr.'
WHEN @CurrencyCode = 'USD' THEN '.Cents.'
WHEN @CurrencyCode = 'EUR' THEN '.Cents.'
WHEN @CurrencyCode = 'GBP' THEN '.Cents.'
ELSE @CurrencyCode END
set @CurrencyCode=CASE WHEN @CurrencyCode = 'TRY' THEN '.TL.'
WHEN @CurrencyCode = 'USD' THEN '.USD.'
WHEN @CurrencyCode = 'EUR' THEN '.EUR.'
WHEN @CurrencyCode = 'GBP' THEN '.GBP.'
ELSE @CurrencyCode END
declare @isMoney bit
set @isMoney = 1
DECLARE @Split tinyint
DECLARE @iSplit tinyint
DECLARE @sNum varchar(20)
DECLARE @NumSet varchar(3)
DECLARE @Char char(1)
DECLARE @NumText varchar(255)
DECLARE @SetText varchar(100)
DECLARE @HunText varchar(100)
DECLARE @CharText varchar(50)
DECLARE @Match bit
DECLARE @Point tinyint
DECLARE @Cents varchar(2)
DECLARE @CentText varchar(100)
DECLARE @NumStrings TABLE (Num int, NumStr varchar(20))
--devamı resmin içinde
fonksiyonu Serkan Dönmez yazısından alıp kullanım amacımıza göre düzenledim.
8 yorum
thanks for approve my account 🙂
deSara
Hey people!!!!!
Good mood and good luck to everyone!!!!!
Artificial intelligence has started creating images, writing texts, and composing music. What will hit on next? Determination robots supersede humans?
Is this look-alike
created by false intelligence? Refreshing, isn’t it?
Excellent news for all us
Awesome news for all us
Your absolute mastery with strong practical equipment – you transform into a competitor, a pilot as well as an adventurer!
Tweak and boost system to suit you – grasp, explore, discover the world in your own way!
Experience memorable delight and unique thrills – from your accomplishments and outcomes!
Click here to get awesome model that your friend lacks right now!
Name new tablets at immense ecstasies – expanded also extra strong orgasms!
Never witnessed previously – highly newest at therapeutic knowledge research!
Completely protected plus successful – well elevated libido as even enhanced genital firmness!
Elevate volume of your expulsions instantly right now!
We rushing towards your aid—one crew among technicians which shall promptly repair some aftermath from a plumbing crisis at one’s residence!
Your fast reply – some answer for decreasing their costs for any later major repairs!
Feel one’s rapidity plus quality of help right now!