That's fine, since T-SQL doesn't have a percent function. The return type of most mathematical operations depends on the types of the arguments passed in; int/int returns int, hence the truncation ...