Stored procedure

Sep 8 2004 12:00 PM
Hi guys, Need some help with some basic stored procedure stuff. i have the following stored procedure. In which I want the procedure to count the number of records that have a status of a in column "REGISTRATION_TYPE". However whenever i test the procedure it asks me to input a value for @value and it does not work. ALTER PROCEDURE dbo.REGISTRATION ( @Value int OUTPUT ) AS SET NOCOUNT ON Select @Value = Count(*) FROM TB_REGISTRATION Where TB_REGISTRATION.REGISTRATION_TYPE = 'A' RETURN Thanks for the help