This is probably because of the data types of your numerical columns. Please post DDL statements for all the tables referenced in the query.

Also take a look at the Data Type Precedence article:

http://msdn.microsoft.com/en-us/library/ms190309%28v=sql.100%29.aspx