Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I need to convert integer into decimal by specifying the decimal point Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 10:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 6:58 AM
Points: 130, Visits: 258
Hello,
I need to convert an integer into decimal by specifying the decimal point.

For example, if i have 0000318750, when i try to convert into decimal it gives me 318750.00, but i need it to be 3.18750.

Can this be done? Thanks in adavance.

CREATE TABLE #X (Samp decimal(15,5));

INSERT INTO #X VALUES ('0000318750')

SELECT * FROM #X
Post #1420677
Posted Friday, February 15, 2013 10:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 13,067, Visits: 11,903
Like this?

update #X set Samp = Samp / 100000



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1420685
Posted Friday, February 15, 2013 10:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 6:58 AM
Points: 130, Visits: 258
Yes, I just did it.

Thank you.
Post #1420687
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse