Databases
StackOverflow2013
Postsdbo
POConverting numbers to words in Arabic
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConverting numbers to words in Arabic
    primarykey
    data
    text
    <blockquote> <p><strong>Possible Duplicate:</strong><br> <a href="https://stackoverflow.com/questions/14040702/recursive-function-wont-work-again-sql">recursive function.. won’t work again SQL</a> </p> </blockquote> <p>I created a table containing numbers between 0 and 99; for the numbers between these two numbers the query is working, and it's working for these numbers too: 100, 200, 1000, 2000, 1100, 2100, 1000000. In general it works for the numbers >100 and doesn't contain a number from the table that I already created.. and for all the other numbers I get 'null'. I think the problem is in the variable @Units but I can't focus on that anymore.</p> <pre><code>CREATE FUNCTION dbo.fnIntegerToWords(@Nb as BIGINT) RETURNS NVARCHAR(1024) AS BEGIN DECLARE @Millions as int DECLARE @Remainder as int DECLARE @Thousands as bigint DECLARE @Hundreds as int DECLARE @Units as int DECLARE @word as nvarchar (1024) DECLARE @result as nvarchar(1024) set @Millions = @Nb/1000000 set @Units = @Nb %1000000 IF @Millions &gt; 0 BEGIN if @Millions = 1 set @result = N' مليون' if @Units &gt; 0 begin set @Thousands = @Units / 1000 set @Units = @Units % 1000 if @Thousands &gt; 0 begin if @Thousands = 1 set @result = @result + N' و' + N'ألف' else if @Thousands = 2 set @result = @result + N' و' + N'ألفان' else if @Thousands between 100 and 199 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 begin set @result = @result + N' مائة ألف' set @Thousands = 0 end else if @Remainder &gt; 0 begin set @result = @result + N' و' + N'مائة' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder) + N' ألف' end END else if @Thousands between 200 and 299 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 begin set @result = @result + N' و' + N' مئتان ألف' set @Thousands = 0 end else if @Remainder &gt; 0 begin set @result = @result + N' و' + N' مئتان' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder) + N' ألف' end END else if @Thousands &gt; 299 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 begin set @result = @result + N' و' + dbo.fnIntegerToWords(@Hundreds) + N' مائة ألف' end else begin set @result = @result + N' و' + dbo.fnIntegerToWords(@Hundreds) + N' مائة' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder)+ N' ألف' end END else if @Thousands between 3 and 99 set @result = @result + N' و' + dbo.fnIntegerToWords(@Thousands) + N' ألف' END if @Units &gt; 0 Begin set @Hundreds = @Units / 100 set @Units = @Units % 100 if @Hundreds &gt; 0 BEGIN if @Hundreds = 1 set @result = @result + N' و' + N' مائة' else if @Hundreds = 2 set @result = @result + N' و' + N' مئتان' else set @result = @result + N' و' + dbo.fnIntegerToWords(@Hundreds) + N' مائة' END if @Units &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Units) End end END ELSE IF @Millions = 0 BEGIN set @Thousands = @Units /1000 set @Units = @Units %1000 IF @Thousands &gt; 0 BEGIN if @Thousands = 1 set @result = N' ألف' else if @Thousands = 2 set @result = N' ألفان' else if @Thousands between 100 and 199 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 set @result = N' مائة ألف' else if @Remainder &gt; 0 begin set @result = N' مائة' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder) + N' ألف' end END else if @Thousands between 200 and 299 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 begin set @result = N' مئتان ألف' end else if @Remainder &gt; 0 begin set @result = N' مئتان' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder) + N' ألف' end END else if @Thousands &gt; 299 BEGIN set @Hundreds = @Thousands / 100 set @Remainder = @Thousands % 100 if @Remainder = 0 begin set @result = dbo.fnIntegerToWords(@Hundreds) + N' مائة ألف' end else begin set @result = dbo.fnIntegerToWords(@Hundreds) + N' مائة' if @Remainder &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Remainder) + N' ألف' end END else set @result = dbo.fnIntegerToWords(@Thousands) + N' ألف' if @Units &lt;&gt; 0 BEGIN set @Hundreds = @Units / 100 set @Units = @Units % 100 if @Hundreds &gt; 0 BEGIN if @Hundreds = 1 set @result = @result + N' و' + N' مائة' else if @Hundreds = 2 set @result = @result + N' و' + N' مئتان' else set @result = @result + N' و' + dbo.fnIntegerToWords(@Hundreds) + N' مائة' END if @Units &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Units) END END END ELSE IF @Thousands = 0 BEGIN set @Hundreds = @Units / 100 set @Units = @Units % 100 if @Hundreds &gt; 0 BEGIN if @Hundreds = 1 set @result = N' مائة' else if @Hundreds = 2 set @result = N' مئتان' else set @result = dbo.fnIntegerToWords(@Hundreds) + N' مائة' if @Units &gt; 0 set @result = @result + N' و' + dbo.fnIntegerToWords(@Units) END else set @result = (select COALESCE(word,'') from number where @Units=number) END RETURN @result END </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USNejthe
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConverting numbers to words in Arabic
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POConverting numbers to words in Arabic
      1. USNejthe
      1. VTFavorite
    3. VO
      singulars
      1. POConverting numbers to words in Arabic
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO[Don't re-post your questions](http://stackoverflow.com/questions/14040702/recursive-function-wont-work-again-sql). If you continue to do this, you'll likely find yourself banned from asking questions on Stack Overflow. Is that what you want?
      singulars
      1. POConverting numbers to words in Arabic
      1. This table or related slice is empty.
    2. COwhy ?? im trying to know where's my fault i spend more than 24hours on that and it was working i'm trying to find someone that can see the error that im not seeing..
      singulars
      1. POConverting numbers to words in Arabic
      1. USNejthe
    3. COBecause duplicate questions are highly frowned upon in the Stack Exchange network of sites, that's why. The duplication of questions necessarily implies duplication of the efforts of those reading, commenting on, and answering said questions. Why do you wish to unnecessarily increase the amount of effort spent by others?
      singulars
      1. POConverting numbers to words in Arabic
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload