Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Query result rounding down

    Thank you,

    1.0 * b.[total shipping days] / c.[shipping days] works as well if you want to display more than 1 decimal place.

    Best Regards,

    Steve Chapman

  • RE: Query result rounding down

    Thank you very much for your help. This has solved the problem.

    Best Regards,

    Steve Chapman

  • RE: Query result rounding down

    Thanks for your quick response,

    I had already tried that and got an error. The error message is -:

    Msg 8115, Level 16, State 8, Line 1

    Arithmetic overflow error converting int to...

Viewing 3 posts - 1 through 3 (of 3 total)