How to calculate no. in 2 digit afte decimal point

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

i am developing the software for Body Mass Index in windows application. i have problem on calculating BMI in 2 digit after decimal point ...how can i calculate it

If any one knows please help me...Thanks in advance.

Posted 24-Aug-11 22:22pm

nishikant.K

Add a Solution

Comments

Herman<T>.Instance 25-Aug-11 4:24am

first: show your code? so we can see sharp what your problem is.
DO you use e decimal? or should sql2005 result in 2 decimals?

2 solutions

Solution 2

SQL

SELECT Cast(Round(12.3456,2,1) As Decimal(4,2))

If you use only Round it will return 12.3400, casting to Decimal will truncate ending zeroes.

Posted 24-Aug-11 22:33pm

Enver Maroshi

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2011-08-24T22:30:00

Solution 1

Use the Math.Round[^] method.

Posted 24-Aug-11 22:30pm

CPallini

How to calculate no. in 2 digit afte decimal point

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to calculate no. in 2 digit afte decimal point

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us