converting decimal to base 32

converting decimal to base 32

procedure for converting decimal to base 32

View Answers

August 27, 2012 at 6:04 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









Related Tutorials/Questions & Answers:
converting decimal to base 32
converting decimal to base 32  procedure for converting decimal to base 32   CREATE PROCEDURE RTCONVERSION ( @valueToConvert int, @convertedValue varchar(20) out ) AS declare @counter int; declare @num int; declare @x
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
Advertisements
decimal to base 36
decimal to base 36  procedure for converting decimal to base 36   CREATE PROCEDURE RTCONVERSION ( @valueToConvert int, @convertedValue varchar(20) out ) AS declare @counter int; declare @num int; declare @x int
converting From Hexadecimal to Decimal System - Java Interview Questions
converting From Hexadecimal to Decimal System  Write a program in Java user is required to enter a number system XVI and turn it into the decimal... { public static void main(String args[]) { int decimal=0; Scanner input=new
SQL Decimal
to a maximum of 32 significant digits and Decimal fixed point can store upto 16... SQL Decimal       SQL Decimal is used to specify the values in decimal datatype. The Decimal datatype
java program 32
java program 32  Write a java program to create server and clint such that server receives data from clint using BufferedReader and send reply to client using PrintStream
temperature converting
Fahrenheit temperatures from 32 to 212 degrees in 10 degree intervals Both columns in each chart should be printed to one decimal place Print the charts... * temp) + 32; } public static double celsius(int temp) { return
decimal to hexadecimal
decimal to hexadecimal  using array in java convert decimal to hexadecimal.   Hi, Please see the example Convert Decimal to Hexadecimal. (adsbygoogle = window.adsbygoogle || []).push({}); Thanks
convert to decimal
convert to decimal  f42a4 convert to decimal by using java
Convert Decimal to Octal
Enter the decimal number: 26 octal:=32 C:\codejava>... Convert Decimal to Octal       In this section, you will learn to convert decimal number into octal
java 9 32 bit download
java 9 32 bit download  Hi, I am trying to install JDK..., and then contact software publisher. What is this issue? How o get get Java 9 32 Bit..., 32 bit installer is not available. I you have 32 bit operating system you won't
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 Hexadecimal to Decimal
the Hexadecimal number: 32 Decimal:=50 C:\corejava>... Convert Hexadecimal to Decimal     ... into decimal. The java.lang package provides the functionality to convert
Converting ISO8601-compliant String to java.util.Date
Converting ISO8601-compliant String to java.util.Date  Converting ISO8601-compliant String to java.util.Date
Convert Decimal to Hexadecimal
a decimal value and  converts it  into  a hexadecimal (Base 16... Convert Decimal to Hexadecimal       In this section, you will learn to convert a decimal data
How to convert binary to decimal in Java?
and then converting it to a decimal number. The java.lang package provides..., in this example we are converting binary value to decimal value in Java... How to convert binary to decimal in Java program? In this section
Convert Decimal to Integer
This program helps you in converting a decimal type data into an integer. The parseInt... Convert Decimal to Integer       In this section, you will learn to convert  a decimal number
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
Convert Octal to Decimal
Convert Octal to Decimal     ... to decimal. The following program helps you converts number octal to decimal. ... at console converts it into decimal number using parseInt() method. This method
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
base 10 is a decimal number, for example 10 is a decimal number which can...; integer in base 2. Example : Code to convert Decimal to Binary using...Conversion of Decimal to Binary  in Java In this section we will discuss
converting string to double in java
converting string to double in java  Please post an example to converting string to double in java. Thanks!   Convert String to Double Tutorial
DecimalFormat
DecimalFormat       java.text.DecimalFormat is the class that is used for converting the decimal... automatically rounds off  to the number of decimal places.    Handling
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:ADS_TO_REPLACE_1
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
Converting PDF in to XML
Converting PDF in to XML  I have to convert PDF into XMl without any loss in text. Please suggest sth good
converting field to text sql
converting field to text sql  I wanted to convert the field to TEXT in SQL.. is it possible?   SQL - Converting the field to TEXT works SELECT CONVERT(TEXT,fld_name) FROM TABLE_NAME   SQL - Converting
Convert Binary to Decimal
decimal long. This method has been used for converting a long to a string... Convert Binary to Decimal      ... number  into a decimal number. The java.lang package provides the facility
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
Converting a NSString into NSDate
Converting a NSString into NSDate  hello. How can I create a NSDate object out of it and then get different components like day, month, date, year from it. I have date string: Tuesday, October 19, 2010.ADS_TO_REPLACE_1
ModuleNotFoundError: No module named 'decimal-monkeypatch'
ModuleNotFoundError: No module named 'decimal-monkeypatch'  Hi, My... named 'decimal-monkeypatch' How to remove the ModuleNotFoundError: No module named 'decimal-monkeypatch' error? Thanks   Hi
ModuleNotFoundError: No module named 'micropython-decimal'
ModuleNotFoundError: No module named 'micropython-decimal'  Hi, My... named 'micropython-decimal' How to remove the ModuleNotFoundError: No module named 'micropython-decimal' error? Thanks   Hi
ModuleNotFoundError: No module named 'pycopy-decimal'
ModuleNotFoundError: No module named 'pycopy-decimal'  Hi, My... named 'pycopy-decimal' How to remove the ModuleNotFoundError: No module named 'pycopy-decimal' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'pycopy-decimal'
ModuleNotFoundError: No module named 'pycopy-decimal'  Hi, My... named 'pycopy-decimal' How to remove the ModuleNotFoundError: No module named 'pycopy-decimal' error? Thanks   Hi, In your python
Java Glossary Term - D
that is used for converting the decimal numbers into Strings. This class is also...; to the number of decimal places.   do while loop In java a do
prablems on oracle ee installation in windows7 ultimate(32 bit).
prablems on oracle ee installation in windows7 ultimate(32 bit).  Hai i have face several prablems when ever i m install oracle ee in my system(32 bit)windows7 ultimate.it is not installed in my system.can any body help me how
Java and converting a PDF to XML
Java and converting a PDF to XML  I reviewed your example - https://www.roseindia.net/tutorial/java/xml/pdftoXML.html - and on many users group, it receives high praise. I understand it uses iText but I am having a problem
Java and converting a PDF to XML
Java and converting a PDF to XML  I reviewed your example - https://www.roseindia.net/tutorial/java/xml/pdftoXML.html - and on many users group, it receives high praise. I understand it uses iText but I am having a problem
Converting string to Int - JDBC
Converting string to Int  String nrate=request.getParameter("t3"); i want convert this nrate to integer to make calculations on it... so what should i do??? where t3 is a text area name and i am fetching...  Hi
Converting XML to string
Converting XML to string  Hi Friends, I had an requirement in which a java program receives an xml messages from external web application such as (jsp, php) and then it converts the received xml message into a string. could
Mysql Decimal Datatype
Mysql Decimal Datatype       Mysql Decimal Datatype is used to specify the numeric values. Understand... Decimal Datatype'.To understand this example we create a table'Stu' that include
Converting Text Files into Bzip File
Converting Text Files into Bzip File  Hi, I am facing the problem during run the program, when converting text files into Bzip file. Please guide me how do i convert the text file into bzip file in PHP. I will welcome, if anyone
Converting NSURL to NSString creating a problem
Converting NSURL to NSString creating a problem  Hi , In my iPad/iPhone universal application, we are trying to covert theNSURL to NSString which cause the application crash. Does any one have idea about converting NSURL
Converting NSURL to NSString creating a problem
Converting NSURL to NSString creating a problem  Hi , In my iPad/iPhone universal application, we are trying to covert theNSURL to NSString which cause the application crash. Does any one have idea about converting NSURL
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
Converting jsp variable to java variable
Converting jsp variable to java variable  Hi how to convert java script variable to java variable on same jsp page
converting html file into pdf - Struts
converting html file into pdf  i want to convert html file into pdf file using java code please help me
converting image to byte[] - Java Beginners
converting image to byte[]  Dear Sir Can you please tell me a solution for converting a java.awt.Image to byte[] eg: java.awt.Image... for converting } Please give me a solution Thanks in Advance. Rahul
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

Ads