Posted by Hermes on 05/17/07 16:25

I have a statement in my code;
Sum(CASE WHEN Rcv > 0 and Rcv < 100 THEN Rcv ELSE 0 END) as D100

It gives me a different number if I just add an "=" sign regarding the
0;
Sum(CASE WHEN Rcv > = 0 and Rcv < 100 THEN Rcv ELSE 0 END) as D100

Does anyone know why this would happen?

• Next in forum: Re: SQL Server 2005 - > = 0 is not the same as > 0?
• Prev in forum: Re: SqlServer 2005: Importing Data: Idenitity fields getting made into non-identities
• Thread view: SQL Server 2005 - > = 0 is not the same as > 0?

[Reply to this message]