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 |
|
Sharath Bharadwaj
Starting Member
1 Post |
 Posted - 2008-07-05 : 23:38:00
|
| Hi guys,I have an issue.I have a table in that i have a column named overs nvarchar(50),overs6.56.54these are the rows.I want to sum the rows where i shud get the result as 17.4. If i do sum(overs) i will get result as 17 which is not the result i want.Pls suggest me asap as it is very urgent.Sharath |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-06 : 08:12:24
|
| I may be mistaken here , but the sum sum of 6.5 + 6.5 + 4 = 17Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 00:18:51
|
| Please specify your rules of how you think sum will be 17.4? |
|
|
|
|
|
|
SQL Help