1 Answer
1

Check the compatibility level of the server. It is likely at 80, which is for SQL Server 2000 compatibility. In SQL Server 2000, modulo only supported the INT data types. In SQL 2005 and up, other numeric data types are allowed and implicit conversions will happen, since in your formula you have both numeric and integer data types.

I found a script to modify compatibility level on all databases of a server with filtering of databases you wouldn't want to change.

Thanks @Sumo for your quick reply.<br />For the compability reason, my partner had used different computer but did as i did and He didn't get any problem like mine. So the problem maybe come from my computer or my both SQL Server 2005 and 2008..<br><br/>By the way, sorry for my bad english ^^
–
charenthJul 27 '12 at 6:45