• This explains it:

    http://msdn.microsoft.com/en-us/library/aa258274(SQL.80).aspx

    For division:

    [EDITED - was incorrect, apologies CFF]

    scale of the result = max(6, s1 + p2 + 1)

    where s1 is the scale of the numerator and p2 is the precision of the denominator.

    Forum Etiquette: How to post data/code on a forum to get the best helpMake sure that you include code in the appropriate IFCode tags, e.g. <your code here>. You can find the IFCode tags under the INSERT options when you are writing a post.