Over the next few days we are going to start the migration to a new forum
application. I'm going to start with high post count and active users. You may
receive an invitation to the new forums. It's not spam. It's just me trying to
seed the user base. My goal is to open it up over the weekend.
Once we open the site we'll block registrations here. We should be open
shortly on the new site.
As you found out, this is because of integer division. If any one of the participants in the arithmentic expression are of floating point type, then that will force non-integer division. So for example, people do this:
Also, when you cast to DECIMAL, give a precision and scale so you know what you are getting rather than letting SQL Server default.