Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vision99
Starting Member
14 Posts |
 Posted - 2009-06-25 : 10:24:49
|
| Hi, In my sql statement am using SUM(((ISNULL(grossLeads,0)-(ISNULL(netLeads,0) - ISNULL(finalized,0)))/(ISNULL(grossLeads,0)*1.0)) *100.0) AS 'Completion_Per' in the SELECT statement its displaying the result like 71.000000000000000, my requirement is to display only 2 decimal points like 71.00. Am using ROUND function but its displaying errors.. plzz help on thisThanks-Vision |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-06-25 : 10:26:15
|
| use CAST asCAST(fieldname as decimal(10,2)) |
 |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-06-25 : 22:08:31
|
| CONVERT(DECIMAL(10,2), fieldname) |
|
|
|
|
|
|
Display only two decimal points?