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 |
|
interclubs
Yak Posting Veteran
63 Posts |
 Posted - 2004-08-08 : 16:02:29
|
| I have a very simple count query which I need to add with a sum query, and I can't get it to work. I've tried casting converting, etc.... and I am sure I am just missing something really dumb....(select Sum(probability/100) from Stats) + (select count(ID) from Attending)and I keept getting an error. The first part of the query returns a number such as (2.6000000000000001)Thanks.... |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2004-08-08 : 16:15:32
|
[code]select (select Sum(probability/100) from Stats) + (select count(ID) from Attending)[/code]quote:
and I keept getting an error.
Care to share the error message with us? |
 |
|
|
|
|
|
Simple Math ? is driving me nuts.....