SQL Server Forums - Simple Percentage Conversion

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Simple Percentage Conversion

New Topic

Author

Topic

funk.phenomena
Yak Posting Veteran

Canada
97 Posts

Posted - 03/26/2012 : 17:11:48

Hi All - I have a VERY simple SELECT statement that involves a percentage calculation.



SELECT ((1+1+1+0)/4)
SELECT  STR (((1+1+1+0)/4)*100,12,2)

I would like the following statement to output '0.75', but instead it keeps outputting '0.00'.

Any ideas?

Edited by - funk.phenomena on 03/26/2012 17:13:13

russell
Pyro-ma-ni-yak

USA
4967 Posts

Posted - 03/26/2012 : 17:20:27

SELECT STR (((1+1+1+0)/4.0),12,2)

funk.phenomena
Yak Posting Veteran

Canada
97 Posts

Posted - 03/26/2012 : 17:30:58

Works!
Didn't realize I had to have the denominator formatted as decimal.

russell
Pyro-ma-ni-yak

USA
4967 Posts

Posted - 03/26/2012 : 17:32:43

yep, else it assumes integers and returns the floor.

Topic

New Topic

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.