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