I need to convert integer into decimal by specifying the decimal point

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » I need to convert integer into decimal by...

I need to convert integer into decimal by specifying the decimal point

Rate Topic

Display Mode

Topic Options

Author

Message

Shree-903371

Posted Friday, February 15, 2013 10:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:26 AM
Points: 123, Visits: 222

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

Sean Lange

Posted Friday, February 15, 2013 10:58 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 10:16 AM
Points: 8,584, Visits: 8,225

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

Post #1420685

Shree-903371

Posted Friday, February 15, 2013 10:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:26 AM
Points: 123, Visits: 222

Yes, I just did it.

Thank you.

Post #1420687

« Prev Topic | Next Topic »

Permissions