decimal to base 36

Ads

 
 

Share on Google+Share on Google+

rahul
decimal to base 36
1 Answer(s)      5 years ago
Posted in : SQL

procedure for converting decimal to base 36

Ads
View Answers

August 27, 2012 at 6:09 PM


CREATE PROCEDURE RTCONVERSION ( @valueToConvert int, @convertedValue varchar(20) out ) AS declare @counter int; declare @num int; declare @x int; declare @flag int;

BEGIN select @counter = 2; select @num = @valueToConvert;

select @flag = 0;

WHILE(@num != 0)
--LOOP
begin
    select @x = @num%36;
    IF( @x > 9) 
    begin
            IF(@flag != 1) 
            begin
                select @convertedValue = char(@x + 55);
                select @flag = 1; 
            end
            ELSE 
            begin   
                --select 1;
                select @convertedValue = char(@x + 55) + @convertedValue;   

            END 
            select @counter = @counter - 1; 
    end
    ELSE    
    begin   
            IF(@flag != 1) 
            begin
                --select 2;
                select @convertedValue = char(@x + 48);
                select @flag = 1; 
            end
            ELSE
            begin
                --select 3;
                select @convertedValue =  char(@x + 48) + @convertedValue;
            END 
            select @counter = @counter - 1;
    END         
    select @num = @num / 36;
--END LOOP;
END
IF(@counter != -1) 
begin
    WHILE(@counter != -1)
    --LOOP
    begin
        IF(@flag != 1)
        begin
            select @convertedValue = char(48);
            select @flag = 1; 
        end
        ELSE
        begin
            --select 4;
            select @convertedValue = char(48) + @convertedValue ;
        END 
        select @counter = @counter - 1;
    --END LOOP; 
    END
 END

END


Ads









Related Tutorials/Questions & Answers:
decimal to base 36
decimal to base 36  procedure for converting decimal to base 36  ...; select @flag = 0; WHILE(@num != 0) --LOOP begin select @x = @num%36...; END select @num = @num / 36; --END LOOP; END IF(@counter != -1
converting decimal to base 32
converting decimal to base 32  procedure for converting decimal to base 32   CREATE PROCEDURE RTCONVERSION ( @valueToConvert int... = @num%36; IF( @x > 9) begin IF(@flag != 1
Advertisements
decimal to hexadecimal
decimal to hexadecimal  using array in java convert decimal to hexadecimal.   Hi, Please see the example Convert Decimal to Hexadecimal. Thanks
convert to decimal
convert to decimal  f42a4 convert to decimal by using java
SQL Decimal
SQL Decimal       SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype can be of two types : Decimal (p) refers to floating point and Decimal fixed
swing program for decimal to binary
swing program for decimal to binary  swing program for decimal to binary
Decimal Format Issue Java
Decimal Format Issue Java  Decimal Format Issue Java
Convert Decimal to Hexadecimal
Convert Decimal to Hexadecimal       In this section, you will learn to convert a decimal data into hexadecimal. The java.lang package provides the functionality to convert a decimal
Round the Decimal values
Round the Decimal values  How to round the decimal value with out using Math.round() Example:round the 2.7 as a 3.0 round the 2.4 as a 2.0
BINARY TO DECIMAL - Java Beginners
TO DECIMAL  Hi friend, Program to convert Binary To Decimal : import... = sc.next (); int bttm = 1; int decimal = 0; for (int i = str.length() -1; i >= 0; i--) { decimal = decimal + (bttm*Integer.parseInt
Conversion of Decimal to Binary in Java
Conversion of Decimal to Binary  in Java In this section we will discuss about conversion of Decimal to Binary in Java. You know that number having base 10 is a decimal number, for example 10 is a decimal number which can
Convert Decimal to Octal
Convert Decimal to Octal       In this section, you will learn to convert decimal number into octal.  The decimal format has 10 digits (that are 0,1,2,3,4,5,6,7,8,9
Convert Decimal into Binary
Convert Decimal into Binary        In this section, you will learn to convert decimal number...; a decimal number into a binary number.  Description of program: This program
java program to convert decimal in words
java program to convert decimal in words  write a java program to convert a decimal no. in words.Ex: give input as 12 output must be twelve
Convert Hexadecimal to Decimal
Convert Hexadecimal to Decimal     ... into decimal. The java.lang package provides the functionality to convert a hexadecimal number into decimal. Code Description: This program takes a hexadecimal
Mysql Decimal Datatype
Mysql Decimal Datatype       Mysql Decimal Datatype is used to specify the numeric values. Understand with Example The Tutorial give you an example from 'Mysql Decimal Datatype
Convert Decimal to Integer
Convert Decimal to Integer       In this section, you will learn to convert  a decimal number... a decimal number to an integer type number. Description Code: This program helps you
How to round a number to n decimal places in Java
How to round a number to n decimal places in Java  How to round a number to n decimal places in Java
Convert Octal to Decimal
Convert Octal to Decimal     ... to decimal. The following program helps you converts number octal to decimal. ... it into decimal number using parseInt() method. This method parses
php format number to 2 decimal places
php format number to 2 decimal places  Hi, How to format a number in PHP to 2 decimal places? Can anyone provide me good code for php format number to 2 decimal places? Thanks
Checking the decimal whether comma used or not
Checking the decimal whether comma used or not  I need to check the given integer whther comma used or not. For example. If the user given 123456 The output should be like 123,456 If the user given 123,456 The output should
Decimal Format Example
Decimal Format Example       In this example we are going to format a decimal... are passing "0.000" .This is used to create an decimal format
Convert Decimal To Fraction
Convert Decimal To Fraction       In this example, you will learn how to convert decimal number to Fraction. The following program you convert it into the decimal to fraction
Java binary to decimal
Java binary to decimal   ... to a decimal number. In this Tutorial we want to describe you a code that help you in understanding a how to get a 'Java binary to decimal'. For this we have
I converting binary to decimal and vice versa
I converting binary to decimal and vice versa  can i ask for the codes in converting binary to decimal and decimal to binary to be run in one program with repeat.. pls. help me! i badly need the codes by monday!! pls
Convert Binary to Decimal
Convert Binary to Decimal      ... number  into a decimal number. The java.lang package provides the facility to convert the integer data into the binary to decimal.  Code Description
conversion from decimal to hexadecimal and vice versa
conversion from decimal to hexadecimal and vice versa  can i get the code for converting decimal to hexadecimal   Here is a code that converts decimal to hexadecimal. import java.io.*; public class
Convert Decimal To Character
Convert Decimal To Character     .... In this example, we are going to convert decimal number to its corresponding character.... This program takes a decimal value. Type casting (char) d ) is done
java program (integer/decimal) - Java Beginners
java program (integer/decimal)  Accept a number from the user as command line arguments. The number could be an integer or decimal value. ? Display the absolute value of the input number ? Display the rounded off value
Convert Euro to dollar, need to be able to enter decimal!
Convert Euro to dollar, need to be able to enter decimal!  Hi... a decimal for the conversion factor or quantity the program will give me an error. Can someone give me an example of how to fix my program so that a decimal would
Convert Euro to dollar, need to be able to enter decimal!
Convert Euro to dollar, need to be able to enter decimal!  Hi... a decimal for the conversion factor or quantity the program will give me an error. Can someone give me an example of how to fix my program so that a decimal would