CREATE PROCEDURE CheckIfApplicationIsComplete
    @ApplicationId INT, @IsApplicationComplete BIT OUTPUT
AS
BEGIN
    SET NOCOUNT ON;

    IF (@ApplicationId < 10)
    BEGIN
        SET @IsApplicationComplete = 0;
        SELECT 'Application' [Key], 'Not complete' [Value];
    END
    ELSE
    BEGIN
        SET @IsApplicationComplete = 1;
        SELECT 'Application' [Key], 'Complete' [Value];
    END
END;
GO

SET NOCOUNT ON;
DECLARE @ApplicationId INT;
DECLARE @IsApplicationComplete BIT;
SET @ApplicationId = 5;
EXEC dbo.CheckIfApplicationIsComplete @ApplicationId, @IsApplicationComplete OUTPUT
PRINT @IsApplicationComplete -- Check Messages tab for result

SET @ApplicationId = 50;
EXEC dbo.CheckIfApplicationIsComplete @ApplicationId, @IsApplicationComplete OUTPUT
PRINT @IsApplicationComplete -- Check Messages tab for result