Coding a multi-functional Record filtering SPROC

GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[spQualification]

            @passedTaxAuthorityID            int,
            @passedMatchingEvent            int,
            @passedMatchingTaxYear            int,
            @passedExclusionHOldType    int,
            @passedExclusionEvent01            int      = null,
            @passedExclusionEvent02            int = null,
            @passedExclusionEvent03            int      = null,
            @passedExclusionEvent04            int      = null,
            @passedExclusionEvent05            int      = null,
            @passedExclusionEvent06            int      = null,
            @passedExclusionEvent07            int      = null,
            @passedExclusionEvent08            int      = null,
            @passedBalanceCutoff            float = 100,
            @ReturnDidItQualify              char(1) = 'N'  Output

 AS
 SET NOCOUNT ON;

 Declare @RestrictedHoldFOund int
 Declare @passedPropertyID    int

 SET @RestrictedHoldFOund = 0
 SET @passedPropertyID = 0

 --
 -- This first execute calls a SPROC to dermine if the exclusion Hold is associated with this @passedTaxAuthorityID
 -- If it is there really is no need to check further and I can set the return code and exit the SPORC without
 -- going any further.
 --
 -- I don't know how to exit the SPROC without going any further.
 --
 -- In this case the Property passed to the SPROC is always 0, that's whiy I declared the variable @passedPropertyID

 Execute dbo.spCheckExistenceOfHoldType @passedPropertyID, @passedTaxAuthorityID, @passedExclusionHOldType, @RestrictedHoldFOund

 If @RestrictedHoldFOund=1
 Begin
            Set @ReturnDidItQualify='N'
        Return 0
 End /*If*/
--
--  The next part of the logic is supposed to make sure the passed @passedMatchingEvent occurred for this
--  @passedTaxAuthorityID in the @passedMatchingTaxYear and that the balance of the record is
--  greater than or equal to the @passedBalanceCutoff
--
--  If thecriterion is not met there is no point in chekcing further we can exit the SPROC although
--  I odn't know hjow to do that.
--
--
If Not Exists(
    Select EventID
    From dbo.vtblEvents_EventID_TAID_FromYear_ThruYear_Balance
    Where (TaxAuthorityID = @passedTaxAuthorityID) and
            (EventID        = @passedMatchingEvent) and
            (@passedMatchingTaxYear Between FromYear and ThruYear) and
            (TABalance     >= @passedBalanceCutoff)
)
Begin
    Set @ReturnDidItQualify = 'N'
    Return
End /*If*/

--
-- If we get to this point we know that there is no hold restriction on the @passedTaxAuthorityID
-- and there was an event for this matching event @passedTaxAuthorityID in the @passedMatchingTaxYear
-- greater than or equal to the @passedBalanceCutoff
--
-- Now we have to make sure there isn't an event matching any of the passedExcusionEvents  for this
-- @passedTaxAuthorityID in the year @passedMatchingTaxYear.
--
-- ALl of the @passedExclusionEvents are optional.  That's why I formatted the Select that way.
--
 Select @ReturnDidItQualify =
    Case When Exists(
         Select EventID
         From dbo.vtblEvents_EventID_TAID_FromYear_ThruYear_Balance
         Where (TaxAuthorityID = @passedTaxAuthorityID) and
                   (@passedMatchingTaxYear Between FromYear and ThruYear) and
               ((EventID IN (@passedExclusionEvent01, @passedExclusionEvent02, @passedExclusionEvent03, @passedExclusionEvent04,
                             @passedExclusionEvent05, @passedExclusionEvent06, @passedExclusionEvent07,@passedExclusionEvent08)))
         )
                     Then 'N'
                     Else 'Y'
                     End
--
--  If none of the exclusions match then record qualifies
--
 RETURN