Hi!

thanks again.

No, my rounding statement was of course nonsense, it was probably more like
a placeholder for something better while I was trying to get the stored
procedure to be accepted.

What I really wanted to do is round the data to full integer values. Because
of the 0.5 added, it will probably take an IF statement to account for
negative values. I thought I'd need a stored procedure for that.

I didn't have a lot of precision problems so far, thanks for pointing me to
the problem. I understand for 'money' one should alway use things like
NUMERIC(13,2)?

Best wishes,
Tobias