Problem:
How to round a NUMBERIC number to an integer number

Solution:
Try a UDF rather than a stored procedure.  Stored procedures 
have the same data semantics as the database.  UDF's have 
the data semantics of the programming language in which they 
are written (e.g. NULLs are not supported).  You may invoke 
rounding UDF from a stored procedure if you wanted to use all 
possible mechanisms.