CREATE PROCEDURE TEST @results numeric(9,4) OUTPUT AS BEGIN SELECT @results = 9999.9999 END