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 |
|
cbrochhagen
Starting Member
5 Posts |
 Posted - 2002-08-16 : 10:50:40
|
| I have the situation where I'm multiplying two numbers together and the resulting product may be zero due to the size of the column being inserted into. Is there a way to prevent inserting the row if the product will be zero? I'm not performing any type of aggregate functions so I don't think using "HAVING" will work. Thanks in advance for any and all advice.Curt |
|
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-08-16 : 11:33:05
|
| If you could post your SQL statement, it would make it much easier. Here is a guess. If you are not grouping, then you must be mutilplying two columns together. If this is the case use something like this:SELECT column1, column2*column3 as NewColumnFROM tableWHERE column2*column3 <> 0If this is not what you meant, please post SQL.Jeremy |
 |
|
|
|
|
|
Eliminate Rows with Zero Product