>>Try Naomi's suggestion with Precision and Scale.
>
>I will; thank you. But does setting the type in my stored procedure as "numeric(10,2)" correct?
Yes, it's fine in SQL Server. You can use decimal (10,2) as well - should be no difference.
If it's not broken, fix it until it is.
My Blog