CREATE PROCEDURE TEST @results numeric(9,4) OUTPUT 
AS

BEGIN
SELECT @results = 9999.9999
      
END

##</code><code>##

declare @mytest numeric(9,4)
exec TEST @results=@mytest OUTPUT
print @mytest