What you want to see on DotNetFunda.com ?
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 4257 |  Welcome, Guest!   Register  Login
 Home > Forums > Sql Server > Help with Decimal Roundings ...
Vuyiswamb

Help with Decimal Roundings

Replies: 3 | Posted by: Vuyiswamb on 8/12/2012 | Category: Sql Server Forums | Views: 265 | Status: [Member] [MVP] [Administrator] | Points: 10  


hi Guys , i am a bit stuck here

i have this value "0.833333333333333"

and i want the asnwer to be 83 , i tried this



SELECT ROUND(0.833333333333333,2)


but it does not work

Thank you for posting at Dotnetfunda
[Administrator]


Reply | Reply with attachment | Alert Moderator

 Responses below this adGet hundreds of .NET Tips and Tricks videos

 Replies

Pandians
Pandians  
Posted on: 8/12/2012 9:41:46 AM
Level: Silver | Status: [Member] [MVP] | Points: 50

Resolved

Pls try this
select Cast(0.833333333333333 * 100 AS INT)


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Vuyiswamb, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Shijohnjoseph
Shijohnjoseph  
Posted on: 8/12/2012 10:47:39 AM
Level: Starter | Status: [Member] | Points: 50

Resolved

double Temp = 0.833333333333333;

label1.Text= decimal.Round(Convert.ToDecimal(Temp), 2).ToString();

i cant understand where your using this if application means use this or specify where your using this !..

"Personality has the power to open many doors, but character must keep them open"

Vuyiswamb, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Vuyiswamb
Vuyiswamb  
Posted on: 8/12/2012 12:49:57 PM
Level: NotApplicable | Status: [Member] [MVP] [Administrator] | Points: 25

thanks it worked

Thank you for posting at Dotnetfunda
[Administrator]

Vuyiswamb, if this helps please login to Mark As Answer. | Reply | Alert Moderator 

Reply - Please login to reply


Click here to login & reply

About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/21/2013 8:48:59 PM