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 |
|
chien_fu
Starting Member
16 Posts |
 Posted - 2007-12-19 : 01:51:53
|
| I can not get this expression to NOT return a null value...I don't know why, anyone got any ideas?IIF(((SELECT IIF(Sum(Game_Schedule.Score) IS NULL, 0, Sum(Game_Schedule.Score)) FROM Game_Schedule WHERE Game_Schedule.T1_ID = standings.ID) + (SELECT IIF(Sum(Game_Schedule.Opp_Score) IS NULL, 0, Sum(Game_Schedule.Opp_Score)) FROM Game_Schedule WHERE Game_Schedule.T2_ID = standings.ID)) / (SELECT Count(ID) FROM Game_Schedule WHERE (Game_Schedule.T1_ID = standings.ID OR Game_Schedule.T2_ID = standings.ID) AND (Win=true OR Loss=true OR Tie=true)) IS NULL, 0, ((SELECT IIF(Sum(Game_Schedule.Score) IS NULL, 0, Sum(Game_Schedule.Score)) FROM Game_Schedule WHERE Game_Schedule.T1_ID = standings.ID) + (SELECT IIF(Sum(Game_Schedule.Opp_Score) IS NULL, 0, Sum(Game_Schedule.Opp_Score)) FROM Game_Schedule WHERE Game_Schedule.T2_ID = standings.ID)) / (SELECT Count(ID) FROM Game_Schedule WHERE (Game_Schedule.T1_ID = standings.ID OR Game_Schedule.T2_ID = standings.ID) AND (Win=true OR Loss=true OR Tie=true))) AS FixedItGPG |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-12-19 : 02:34:52
|
| This forums is for SQL SERVER, you post under MS -Access may be someone over there may be able to help youChiraghttp://www.chirikworld.com |
 |
|
|
|
|
|
Overflow when trying to SORT by calculation