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.
11 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!
The World Games release expressed sincere anguish for this calamity and gave heartfelt condolences to the participant’s kin, close ones, and the full Orienteering Community. Our thoughts stay with everyone affected by this loss.
https://handtohandcombat4all.blogspot.com/2025/04/hand-to-hand-combat.html
The World Games announcement expressed profound regret for this tragedy and gave deep solace to the competitor’s loved ones, friends, and the entire Orienteering circle. Our prayers are with everyone impacted by this event.
https://lovenatureatall.blogspot.com/2025/04/love-nature.html
Picture coming home to find flood creeping into the rooms, belongings, and family treasures.
It’s stressful — but you don’t need to handle it by yourself.
We’re here to protect your family’s home and peace, responding fast and gently to stop the damage before it grows. Our team works with gentleness and protection, helping recover your space and your comfort.
We help you avoid mildew and hidden damage, protecting the comfort of your home. And with our round-the-clock help, you’re never left alone in the middle of a crisis — we’re here whenever you need us!
Call – 8338561951 and professionals will help you!